MS SQL Server 2012 Administration

Test Outline

Architecture
Cloud
Data Types
Installation
System Databases
Transaction Isolation Levels
Backup and Restore
Database Backup
Database Recovery Advisor
Database Restore
Server Recovery
Command Line Tools and Utilities
DBCC
Dynamic Management Views
Powershell
SQLCMD Utility
T-SQL
Database Management
Database Mail
Import and Export Operations
Index Management
Upgrade
Graphical Tools and Utilities
Database Engine Tuning Advisor
SQL Profiler
SQL Server Configuration Manager
SQL Server Management Studio
High Availability
AlwaysOn
Clustering
Log Shipping
Mirroring
Replication
Security
Encryption
Principals, Securables and Permissions
Schema
Server Logins and Role
Users and Database Roles
Troubleshooting
Client Connections
Extended Events
Performance
Query Performance Tuning
Server Services

 

Go Back