Course content:

  1. Transaction Locks and Deadlocks
  2. Database Backups Strategies
  3. Database Restores and Recovery Paths
  4. SQL Server Jobs & Alerts
  5. Data Replications and DR Process
  6. Log Shipping and DB Mirroring
  7. Security and Data Encryption
  8. Server Audits and DB Monitors
  9. Database Maintenance Plans (SSIS)
  10. Partitions and Full Text Indexes
  11. Database Engine Tuning Advisor (DTA)
  12. Alerts and Troubleshooting
  13. DB Engine Configurations and PBM
  14. Server Updates and Upgrades
  15. Windows and SQL Cluster Configurations
  16. SQL Cluster Issues and Troubleshooting