Administering Microsoft SQL Server 2012 Databases Expert Live with Encore
Overview/Description Target Audience Expected Duration Lesson Objectives Course Number Overview/Description
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.
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
Exams
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
Target Audience
Target Audience
This course is recommended for database administrators who are studying for the 70-462 exam or knowledge workers and server administrators who are familiar with database concepts but may not wish to take the professional exam.