SQL DBA Course

 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