Administering Microsoft SQL Server 2012 Databases

This course is included in the Microsoft Virtual Training Package training package.

  • 12 Months unlimited access
  • 2 Live Instructors in every class
  • Mentors available 24/7
  • Personal Success Advisers to help keep you on track
  • Certification practice exams
  • Comprehensive student resources

Overview

The Administering SQL Server 2012 course provides technology professionals the fundamentals to install, optimize, protect, and recover a SQL Server environment. Along with the typical database administration topics, such as securing databases and troubleshooting poor performance, this course also covers new high availability elements to SQL Server 2012. These topics include AlwaysOn Availability Groups and Multi-Subnet Clustering.

Duration

32 Hours

Prerequisites

Candidates for the exam should have one to two years of experience using SQL Server, any version. Students who are not taking the exam but are interested in learning about SQL Server should have previous experience in database environments. These environments can be driven by any vendor’s database solution. Thorough knowledge of TSQL is not required for this class; however it helps.

Certification

MCSA: Microsoft SQl Server 2012
This is the second of three courses for the MCSA SQL Server 2012 certification. MCSA SQL Server is the foundation for two MCSE tracks: MCSE: Data Platform and MCSE: Business Intelligence

 Exam

70-462: Administering Microsoft SQL Server 2012 Databases

 Outline

Administering Microsoft SQL Server 2012 Databases

Session 1 Installing SQL Server Instances and Creating Databases

  • Plan Installation
  • Install SQL Server and Related Services
  • Upgrade or Migrate to SQL Server 2012
  • Configure a SQL Instance
  • Database Architecture
  • User Databases
  • System Databases

Session 2 Managing Data

  • Create and Modify Databases in SQL Server 2012
  • Import and Export Data
  • Indexes
  • Full-Text Catalogs and Indexes
  • Partitioned Tables
  • Data Compression

Session 3 Optimizing and Troubleshooting

  • Benchmark a server
  • Performance Monitor
  • DBCC Statements
  • DMVs
  • XEvents
  • Diagnose waits
  • Distributed management views
  • Locks, blocks, and deadlocks
  • Trace flags
  • Kill a process
  • SQL Profiler
  • Database Tuning Advisor
  • SQL Data Collector / Data Warehouse
  • Resource Governor

Session 4 Recovering Databases, Configuring Mail, and Automating Tasks

  • Backing up Databases
  • Restoring Databases
  • Configuring Database Mail
  • Automating Tasks with SQL Server Agent
  • Standardizing with Policies

Session 5 Configuring Security

  • Authentication
  • Authorization
  • Encryption
  • Auditing

Session 6 Implementing high Availability

  • Log Shipping
  • Database Mirroring
  • Failover Clustering
  • AlwaysOn Availability Groups
  • Replication

SUBSCRIPTION COST



 

NEED HELP OR NOT SURE?