Microsoft Technical Support – Microsoft SQL Server

Introduction

Delegates attending this 4-day tutor led training course will get a comprehensive overview of the knowledge and skills required to capitalise on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server system. This workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of Oracle database management to SQL Server database management. Each module also provides demos.

Pre-Requisites

Prior to attending this course, students must have Oracle DBA experience and familiarity with Microsoft Windows platforms as well as an understanding of operating system fundamentals.

Who Should Attend

This course is intended for experienced Oracle database administrators (DBAs) who work in an enterprise-level environment and require the skills to begin supporting and maintaining a SQL Server database.

Course Benefits

• Develop skill in a new area
• Improve technical skills
• Improve self-sufficiency
• Open new career doors
• Professional development
• Expand knowledge in this field

Course Outline

• Overview
• Database and Instance
• Database Architecture
• Instance Architecture
• Data Objects
• Data Access
• Data Protection
• Basic Administration
• Server Management
• Managing Schema Objects
• Database Security
• Data Transport
• Backup and Recovery
• Performance Tuning
• Scalability and High Availability
• Monitoring
• SQL Server Migration Assistant (SSMA)
• Summarising what the delegates have learned