Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"SQL Server DBA Training" is no longer available

No Reviews Yet

Kalyan Nagar, Bangalore

Course ID: 33808

Kalyan Nagar, Bangalore

Thiru picture
No Reviews Yet

About the Course

Microsoft SQL Server 2012/14/16 DBA Training Program




This course is a soup-to-nuts course that will teach you everything you need to build,configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure solution. You'll learn how to automate daily, weekly, and hourly tasks (like backups), the details of security, SQL Server clustering, replication, disaster recovery, and using jobs and database maintenance tasks. This course consists of all practical techniques to troubleshoot issues which may arise in day to day activities. Each and every topic is covered with unique case studies. This course is divided into 6

modules and totals up to more than 40 hours of instructor-led training for SQL

Server 2012/14/16 administration.




Total Training Duration: 40 Hours





* IT Professionals who administer and maintain SQL Server databases.

* Freshers who looking for career opportunity in IT industry.



Course Outline:


Module-1 SQL Server Architecture

Introduction to SQL Server 2012

Overview on RDBMS and Beyond Relational

Big picture of SQL Server 2012

Components & Services of SQL Server 2012

Roles of production DBA

System Databases

Master, Model, MSDB, Tempdb & Resource

SQL Server 2012 Editions & Capacity Planning

Principal Editions [Enterprise, BI, Standard]

Specialized Editions [Web]

Breadth Editions [Developer, Express]

Hardware Requirements

OS and Software requirements

Pages & Extents


Extents [Uniform & Mixed]

Managing Extent Allocations

Tracking Free Space

Files and File groups

Database Files

Primary data files

Secondary data files

Log Files

Database File groups [Primary & User-defined]

T-Log Architecture

Transaction Log Logical Architecture

Transaction Log Physical Architecture

Recovery phases [Analysis, Redo & Undo]

Checkpoint Operation

Write-Ahead Transaction Log

Managing T-log

Truncating and shrinking the log file

Managing T-Log issues by using DBCC commands


Module-2 Installing, Upgrading, Configuration, Managing services and



SQL server 2012 Installation

Planning the System/Pre-Requisites

Installing SQL server 2012

Best Practices on Installation

Uninstalling SQL server

Common Installation Issues

Upgrading to SQL server 2012 R2/2012

Upgrading the server by applying service packs

Upgrading the server by applying Hot fixes

In-Place Up gradation from SQL server 2005 to 2012

Pre-Upgrade Checks

Upgrade advisor

Best Practices to follow while upgrading

Managing services

Server/Engine Connectivity issues

Security/Firewall access issues

Starting and Stopping Services through

Configuring SQL Server

Configuring Network Protocols from SQL Server configuration manager

Configuring other settings through SP_Configure

Configuring Memory Settings

Configuring Database Settings

Tempdb configuration

Best Practices on tempdb & Database settings

Migrating SQL Server

Side-By- Side Migration Techniques

Difference between in-place & Side by Side Migration/Upgradation

Advantages/Disadvantages of In-Place to Side-by-Side

Migrating Databases

 Migration by using Attach and Detach Method

 Migration by using Back and restore method

Migration by using Copy Database Wizard

Migrating Logins [Fixing Orphaned Users]

Creating and migrating linked servers

Migrating Jobs

Data movement by using Import & Export wizard

Migrating jobs & logins by using SSIS



Module-3 Security, Automation & Monitoring


Automating Administrative Tasks

About SQL server Agent

Creating Jobs, Alerts and Operators

Scheduling the Jobs

Working with Job activity Monitor

Resolving failure Jobs

Configuring Alert system in SQL server agent

Best practices on job maintenance

Monitoring SQL Server

The Goal of Monitoring

Choosing the Appropriate Monitoring Tools

Monitoring Job activities by job activity monitor

Monitoring SQL Server Error Logs/Windows by log file viewer

Best Practices on Monitoring


Security Principles & Authentications

Server & Database Roles

User-defined server roles

Server and Database Principles

Server & Database Securable

Creating Logins and mapping Users to databases

Connecting to contained databases from SSMS

Granting to Object level Permissions

Best Practices on security

Module-4 Backup & Restore, High Availability & Replication

Backup & Restore:

Recovery Models [Simple, Bulk-Logged & Full]

How Backup Works

Types of backups

 Full backup

 Diff backup

 T-log backup

 Copy Only



 Compressed backups

Restoring Modes [With Recovery, No Recovery, Read only/Standby]

Disaster Recovery Planning

Performing Restore (point-in-time recovery)

Partial availability of database

Database Recovery advisor

Backup strategy: Developing and executing a Backup Plan

Creating Maintenance Plans

Resolving Backup failures in Real time scenarios

Best Practices on Backup & Recovery


Module-5 High Availability:


Replication Overview

Replication Models (snapshot/Transactional/Merge/Updatable/Peer to Peer)

Replication agents

Configuring Distributor

Deploying Transactional Replication for High Availability

Deploying Merge Replication for Bi-directional

Creating Subscriptions [Homogeneous / heterogeneous]

Monitoring Replication by using replication monitor

Scripting Replication

Best Practices on Replication

Configuring peer to peer replication

Frequently asked questions in replication

DB Mirroring

Concepts of DB Mirroring

Configure DB Mirroring

Types of DB Mirroring

Log Shipping

Concepts of Log Shipping

Configure Log Shipping

Monitoring Log Shipping


Module-6 Performance Tuning, Indexing & Optimizing SQL Server

Optimizing SQL server

Index Architecture

How to optimally take advantage of indexes

Clustered & Non-Clustered indexes

Covering Index or index with included column

Creating covering indexes

Filtered indexes

Creating filtered indexes to minimize the CPU pressure

Column store Index Overview

Column store Index Fundamentals and Architecture

Creating column store index to improve the performance

Index Fragmentation

How to determine fragmentation

Creating maintenance plan for rebuilding/reorganizing indexes

Best Practices on Indexing

Locking & Concurrency

Blocking [SP_Who2]

Resolving blocking issues in SQL Server

Working with Activity Monitor

Capturing deadlock information in error logs

Deadlocks and deadlock chain detection.

Performance Tuning

Factors That Impact Performance

Best Practices on Performance Tuning.

Date and Time

Not decided yet.

About the Trainer

Thiru picture

Avg Rating





MCITP, MCP, ITIL, MCSA & SixSigma Certified

8 plus year of experience in SQL Server Administration.
Handled more than 38 corporate training's with leading MNCs.
Trained SQL DBA to more than 600+ professionals through online and classroom training.


No reviews currently


Post your requirement and let us connect you with best possible matches for MS SQL Administration Training Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more