Microsoft SQL Server 2012 - Administering Microsoft SQL Server 2012 Databases

Our 5-day Administering Microsoft SQL Server 2012 Databases course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database

Pre-requisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

• 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012

Course Outline

• Module 1: Introduction to SQL Server 2012 and its Toolset
• Module 2: Preparing Systems for SQL Server 2012
• Module 3: Installing and Configuring SQL Server 2012
• Module 4: Working with Databases
• Module 5: Understanding SQL Server 2012 Recovery Models
• Module 6: Backup of SQL Server 2012 Databases
• Module 7: Restoring SQL Server 2012 Databases
• Module 8: Importing and Exporting Data
• Module 9: Authenticating and Authorizing Users
• Module 10: Assigning Server and Database Roles
• Module 11: Authorizing Users to Access Resources
• Module 12: Auditing SQL Server Environments
• Module 13: Automating SQL Server 2012 Management
• Module 14: Configuring Security for SQL Server Agent
• Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
• Module 16: Performing Ongoing Database Maintenance
• Module 17: Tracing Access to SQL Server 2012
• Module 18: Monitoring SQL Server 2012
• Module 19: Managing Multiple Servers
• Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

Exam to be taken after completing the 5 day Administering Microsoft SQL Server 2012 Databases (course 10775)

• Exam 70-462 - Administering Microsoft SQL Server 2012 Databases