Overview

The 70-462: Administering Microsoft SQL Server 2012 online training course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Course Instructor: Brian Alderman

Course Outline

01. Module 1: Introduction to SQL Server 2012 and Its Toolset

  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services

02. Module 2: Preparing Systems for SQL Server 2012

  • Overview of SQL Server Architecture
  • Planning Server Resource Requirements
  • Pre-installation Testing for SQL Server

03. Module 3: Installing and Configuring SQL Server 2012

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Upgrading and Automating Installation

04. Module 4: Working with Databases

  • Overview of SQL Server Databases
  • Working with Files and File groups
  • Moving Database Files

05. Module 5: Understanding SQL Server 2012 Recovery Models

  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

06. Module 6: Backup of SQL Server 2012 Databases

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

07. Module 7: Restoring SQL Server 2012 Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time Recovery
  • Restoring System Databases and Individual Files

08. Module 8: Importing and Exporting Data

  • Transferring Data To/From SQL Server
  • Importing & Exporting Table Data
  • Inserting Data in Bulk

09. Module 9: Authenticating and Authorizing Users

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers

10. Module 10: Assigning Server and Database Roles

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles

11. Module 11: Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

12. Module 12: Auditing SQL Server 2012 Environments

  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

13. Module 13: Automating SQL Server 2012 Management

  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

14. Module 14: Configuring Security for SQL Server Agent

  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

15. Module 15: Monitoring SQL Server 2012 with Alerts and Notifications

  • Overview of Database Mail
  • Database Mail Profiles
  • Database Mail Security
  • Database Mail Logs and Retention

16. Module 16: Performing Ongoing Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

17. Module 17: Tracing Access to SQL Server 2012

  • Capturing Activity Using SQL Server Profiler and Extended Events Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Working with Tracing Options

18. Module 18: Monitoring SQL Server 2012

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

19. Module 19: Managing Multiple Servers

  • Working with Multiple Servers
  • Virtualizing SQL Server
  • Deploying and Upgrading Data-tier Applications

20. Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues

  • SQL Server Troubleshooting Methodology
  • Resolving Service-related Issues
  • Resolving Login and Connectivity Issues
  • Resolving Concurrency Issues

Skills Learned

After completing this online training course, students will be able to:

  • Plan, install, and troubleshoot SQL Server 2012 and SQL Server databases
  • Working knowledge of SQL Databases, the concept of the transaction log, SQL Server 2012 database recovery, backup and restoration
  • SQL Server 2012 security models, logins and users
  • Fixed server roles, user-defined server roles, fixed database roles and permissions and the assignment of permissions, user-defined database roles
  • Partial database containment option provided by SQL Server 2012
  • SQL Profiler
  • Virtualization of SQL Server 2012 and Data-Tier Applications, Central Management Servers and Multi-Server queries
  • Auditing SQL Server 2012 environments
  • Monitoring and maintaining SQL Server 2012 databases
  • Managing and working with multiple servers including virtualizing SQL Server 2012and deploying and upgrading data-tier applications