Course Name:Database Administration Fundamentals-Microsoft SQL Server 2012
Refer to Exam: Database Fundamentals (98-364)-MTA
Class Duration: 2hrs a day, Twice a week
Course Duration: 16 hrs

Course Outline:

• 1- Introduction to 70-462 Administering Microsoft SQL Server 2012
• 2- Planning a SQL Server 2012 Installation
• 3- Installing SQL Server 2012
• 4- Implementing a Migration Strategy
• 5- Configuring SQL Server Components
• 6- Managing SQL Server Agent
• 7- Configuring and Managing Databases
• 8- Configuring and Managing Instances
• 9- Implementing a Cluster Instance
• 10- Identifying and Resolving Concurrency Issues
• 11- Troubleshooting SQL Server
• 12- Auditing SQL Server
• 13- Implementing a Backup Strategy
• 14- Restoring Databases
• 15- Implementing and Maintaining Indexes
• 16- Importing and Exporting Data
• 17- Managing Logins and Server Roles
• 18- Managing Users and Database Roles
• 19- Managing and Troubleshooting Security
• 20- Implementing AlwaysOn Availability Groups
• 21- Implementing Database Mirroring
• 22- Implementing Replication