MS SQL Server DBA Workshop

MS SQL Server DBA training is a very hands-on and practical training. And focus on job oriented approach of understanding and practically doing each topic hand-on.

Day 1:

Introduction
Installation
Configuration
T-SQL
Install Sample Database
Database Creation
Object Creation
Querying the database
DML and DDL
Joining tables.
Creating store procedure
Creating Views
Day 2:

Backup
Restore
Import/Export
Security
Jobs
Database Maintenance
Project
Day 3:

High Availability/Disaster Recovery
Replication
Mirroring
Logshipping
Project
Day 4:

Troubleshooting
Tracing using SQL Server Profiler tools.
Auditing
Error logs analysis
Performance tuning
DMV(Dynamic Management Views)
Project
4 hours each class.

Register to Book your Seat

 

Verification