Administering Microsoft SQL Server 2012 Databases (M10775)


Description In this course, you will gain the knowledge and skills to administer and maintain database applications using the SQL Server 2012 product features and tools.


  • Database professionals who administer and maintain SQL Server databases including database maintenance
  • Database professionals who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from SQL Server databases


  • Working knowledge of relational databases
  • Basic knowledge of Microsoft Windows operating systems and its core functionality
  • Experience with database design
  • Completion of Querying Microsoft SQL Server 2012 (M10774)

Learning Objectives
Learn how to maintain a SQL Server 2012 database.

  • Plan and install SQL Server
  • Physical structure and configuration options for databases
  • Create and implement different backup strategies with transaction log, SQL Server recovery models, and restoration of SQL Server databases
  • Import/Export wizards and how they relate to SSIS
  • Partial database containment option provided by SQL Server 2012
  • SQL Server security models, logins, users, and database containment with users authenticated at the database level
  • Fixed server roles, fixed database roles, user-defined server roles, and user-defined database roles
  • Assigning and using permissions
  • SQL Server Audit
  • SQL Server Agent, jobs, and job history
  • Implement SQL Server Agent security, proxy accounts, and credentials
  • Configure database mail, alerts, and notifications
  • Create database maintenance plans
  • How hot fixes, cumulative updates, and service packs are related and when to apply each type of update
  • How to enable and when to use automatic updates
  • Upgrading data-tier applications with SQL Server 2012
  • SQL Profiler and SQL Trace stored procedures
  • Dynamic Management Views (DMV) and configuration of data collection
  • Core concepts of High Availability, AlwaysOn, and Replication in SQL Server 2012
  • Work with central management servers, multi-server queries, virtualization of SQL Server, and data-tier applications
  • Troubleshoot SQL Server databases