SQL SERVER DBA

SQL SERVER DBA TRAINING

SQL SERVER DBA TRAINING COURSE CONTENT


Overview of the SQL server 

  • Architecture of SQL server
  • The major versions and editions, upgrades from SQL
  • Installing SQL server and client components
  • Pre-requisites, system configuration check
  • installing selected components
  • High availability using Clustering       

SQL server clustering concept 

  • ​Security / User role management
  • Authentication modes, user and roles management
  • Object management
  • Creating, managing and maintaining databases
  • Tables / indexes / views / stored procedures
  • User defined functions
  • Monitoring activity
  • Monitoring the tasks, audits, SQL profiler
  • Backup and restore
  • Taking different types of backups and restoring
  • Backup and restore compression
  • Implementing Disaster recovery

Configuring log shipping 

  • Automation of tasks, alerts
  • Notifications using SQL server agent
  • Creating, managing, maintaining jobs, alerts
  • Notifications through mails
  • Implementing Replication
  • Configuring various methods of replications