Administering Microsoft SQL Server 2012 Databases (M10775)

COURSE OUTLINE:

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.

Audience

  • 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

Prerequisites

  • 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