MICROSOFT

MS SQL SERVER 2012

DESCRIPTION
This course is for administrators who wants to learn about performance optimization, troubleshooting, security and maintenance.
COURSE CONTENT

 

Module 1: Install and Configure SQL Server

  • Installation Decisions
  • Design the Storage for New Databases
  • Plan for Growth and Capacity
  • Service Account Configuration

Module2: Maintain Instances and Databases

  • Transparent Data Encryption
  • Database Compression
  • Failover Clustering
  • Affinity and Parallelism
  • Automation: SQL Agent Jobs and Alerts
  • Database Mail

Module 3: Performance Optimization and Troubleshooting

  • Locking, Blocking, and Deadlocks
  • Profiler
  • Auditing
  • Catalog Views and DMOs
  • Data Collector and the Management Data Warehouse

Module 4: Manage Data

  • Custom Backups and Backup Strategies
  • Restores and Recovery
  • Move Databases and Database Files
  • Ensure Database Integrity
  • Indexes, Statistics, and Maintenance

Module 5: Implement Security

  • Server Logins and Server-Level Roles
  • Database Users and Database-Level Roles
  • Implementing Permissions

Module 6: High Availability Options

  • What is High Availability?
  • Replication
  • Log Shipping
  • Mirroring
  • Always On
  • Failover Clustering