SQL Server DBA Course Curriculum
 
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
  • New Features of SQL
  • Features that are indulged from old version SQL
  • Resource Governor, Activity Monitor, Intellisense
  • Auditing, Plug-in model for SSMS
  • Central Management Servers
  • Sql Server Analysis Services (SSAS)
  • Creating Measurements, dimension, cubes
  • BIDS or MSVS
  • Importing the cubes in SSAS, processing cubes
  • Editing cubes, managing cubes
  • Sql Server Reporting Services (SSRS)
  • Installing, Configuring and maintaining SSRS
  • Sql Server integration Services (SSIS)
  • Exporting and importing SSIS packages  Clarifications and discussions