This SQL DBA Online Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities : Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management, Security Management including Azure SQL DBA Activities like Azure Sync, Azure Server Failover, Azure Virtual Machines and Azure DB Migrations.
This SQL DBA Online Training also includes practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters , LINUX Clusters and Real-time Azure SQL DBA activities. Additionally, this SQL DBA Training Course includes complete guidance for your Job Profile, Study Material, MCSA SQL DBA Certification (70-764 & 70-765) and Real-time Projects for your Resume. Versions: SQL Server 2014, 2016, 2017 and 2019. Download SQL DBA Curriculum Here
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
SQL DBA Job Profile | Core DBA | Core DBA + Azure DBA |
Core DBA + Azure DBA + MSBI |
SQL DBA Course Duration | 6 Weeks | 8.5 Weeks | 15 Weeks |
Number of Chapters | 30 Chapters | 42 Chapters | 72 Chapters |
Real-time Issues, Solutions | ![]() |
![]() |
![]() |
SQL Server, DB Architecture | ![]() |
![]() |
![]() |
Query Tuning and Plan Analysis | ![]() |
![]() |
![]() |
HA - DR, Issues, Troubleshooting | ![]() |
![]() |
![]() |
DB Repairs, Security Management | ![]() |
![]() |
![]() |
Migrations, Updates, Upgrades | ![]() |
![]() |
![]() |
Errors & Troubleshooting | ![]() |
![]() |
![]() |
Events, Traces, Encryptions | ![]() |
![]() |
![]() |
SQL Server on Windows Clusters | ![]() |
![]() |
![]() |
SQL Server on LINUX Clusters | ![]() |
![]() |
![]() |
Always-On Availability Groups | ![]() |
![]() |
![]() |
SLA, OLA, Licensing Plans | ![]() |
![]() |
![]() |
SQL DB Migration to Azure | ❌ | ![]() |
![]() |
Azure SQL Database Admin | ❌ | ![]() |
![]() |
Azure SQL DB: HA-DR | ❌ | ![]() |
![]() |
Azure Virtual Machines, XEL | ❌ | ![]() |
![]() |
Azure PowerShell, Azure CLI | ❌ | ![]() |
![]() |
MCSA 70-764 Certification | ❌ | ![]() |
![]() |
MCSA 70-765 Certification | ❌ | ![]() |
![]() |
MSBI (SSIS, SSAS, SSRS) | ❌ | ❌ | ![]() |
DWH & OLAP Admin | ❌ | ❌ | ![]() |
Report Admin | ❌ | ❌ | ![]() |
Deployments, Security | ❌ | ❌ | ![]() |
Total Course Fee (Payable in installments) | INR 20,000 USD 300 |
INR 28,000 USD 400 |
INR 46,000 USD 650 |
S. No | Timings (IST) | Start Date | |
---|---|---|---|
Schedules for Chapter 1 to 30 (For Core SQL DBA) | |||
1 | 6:30 AM - 7:30 AM | Jan 28th | Register |
2 | 10:15 AM - 11:15 AM | Dec 16th | Register |
3 | 7:30 PM - 8:30 PM | Dec 23rd | Register |
Schedules for Chapters 31 to 42 (For Azure DBA) | |||
4 | 6:30 AM - 8:30 AM (W) | Jan 4th | Register |
5 | 10:00 AM - 12 PM (W) | Dec 21st | Register |
SQL DBA TRAINING HIGHLIGHTS :
✔ In-depth Tuning | ✔ HA - DR Issues |
✔ Azure Migrations | ✔ XEL Graphs |
✔ DAC, PBM | ✔ Stretch Databases |
✔ DB Migrations | ✔ Licensing Plans |
✔ Azure HA - DR | ✔ In-Memory Tables |
✔ DMA Tool | ✔ POCs, RCA |
✔ Ticketing Tool | ✔ Tuning Tools |
✔ Updates, Rollbacks | ✔ Always-On |
✔ SLA / OLA | ✔ Upgrades, Rollbacks |
✔ Lite Speed | ✔ Windows Clusters |
✔ Managed Instance | ✔ Realtime Errors |
✔ Linux (RHEL) | ✔ Virtual Machines |
✔ Capacity Planning | ✔ Power Shell |
✔ Service Startups | ✔ Shard Keys |
✔ BLOB Storage | ✔ Azure Storage Keys |
✔ DBA Checklists | ✔ Azure RM, eDTU |
✔ MCSA Guidance | ✔ Rebuilds, Repairs |
✔ Managed Instances | ✔ Foglight, Automations |
All Trainings are completely Practical and Real-Time. Curriculum Download
Chapter wise FAQs with Answers, Real-time Project are part of this SQL DBA Online Training Course Register
Module I: SQL Server & T-SQLInstallation, Architecture, Indexes |
Module II: Basic SQL DBABackup-Restores, Jobs, Tuning, Security, Migrations |
Module III: Advanced SQL DBAHA-DR, Errors & Solutions, Always-On, SLA |
Day 1: SQL DBA - JOB ROLES, INTRO
|
Day 12: BACKUPS - DB, Filegroup, File
|
Day 23: REPLICATION For HA - Level 1
|
Day 2: INSTALLATIONS, FIREWALL
|
Day 13: RESTORES & DB RECOVERY
|
Day 24: REPLICATION For HA - Level 2
|
Day 3: SSMS Tool, SQL BASICS - 1
|
Day 14: JOBS, MAINTENENCE PLANS
|
Day 25: LOG SHIPPING (HA - DR)
|
Day 4: SQL Basics - 2
|
Day 15: SECURITY MANAGEMENT - 1
|
Day 26: DB MIRRORING (HA - DR)
|
Day 5: SQL Basics - 3
|
Day 16: SECURITY MANAGEMENT - 2
|
Day 27: CLUSTER CONFIGURATION
|
Day 6 : CONSTRAINTS, KEYS
|
Day 17: DB Migrations, Health Checks
|
Day 28: ALWAYS ON AVAILABILITY
|
Day 7: JOINS, T-SQL Queries : Level 1
|
Day 18: ISSUES & SOLUTIONS
|
Day 29: PATCHES, UPGRADES, CUs
|
Day 8: View, Procedure, Function Basics
|
Day 19: Tuning 1 - Audits & Partitions
|
Day 30: INCIDENT MANAGEMENT
|
Day 9: Triggers & Linked Servers
|
Day 20: Tuning 2 - Index Management
|
SQL DBA REAL-TIME PROJECT
ROUTINE SQL DBA ACTIVITIES :
EMERGENCY SQL DBA ACTIVITIES :
|
Day 10: Transactions, Architecture
|
Day 21: Tuning 3 - TUNING TOOLS
|
|
Day 11: DB, Index Architecture
|
Day 22: Tuning 4 - Lock Management
|
|
REAL-TIME PROJECT (With Solution : For your Resume)
Our SQL DBA Online Training
Course includes one Real-time Project on E-Commerce Database.
This project involves Real-time DBA Issues and Solutions including the usage of Ticketing Tools, 3rd Party Tools.
We deal with Routine SQL DBA Activities, Emergency DBA Activities
and Maintenance Activities with Solutions.
Also include
200+
Errors and Solutions
, Database Migrations, Upgrades,
Always-On Availability Groups Implementation in a Clustered Environment.
This Real-time Project gives greater in-depth insight on Real-world SQL
DBA Job Work and can also be used in your Resumes.
|
Module IV : AZURE SQL DATABASE |
Module V : AZURE SQL DBA |
Day 31: AZURE CLOUD INTRO, CONFIGURATION
|
Day 37 : BACKUPS / RESTORES, HA-DR Level 1
|
DAY 32 : LICENSING, DTU ARCHITECTURE
|
Day 38 : HA-DR: Level 2, Azure Always-On
|
DAY 33 : AZURE STORAGE, MIGRATIONS
|
Day 39 : SECURITY MANAGEMENT, RLS
|
DAY 34 : AZURE SQL DATABASE TUNING
|
Day 40 : AZURE POWER SHELL, AZURE CLI
|
DAY 35 : XEL GRAPHS, STRETCH DATABASES
|
Day 41 : AZURE VIRTUAL MACHINE - WINDOWS
|
Day 36 : ALERTS, ON-PREMISE DIFFERENCES
|
Day 42 : LINUX VM, MANAGED INSTANCES
|
MCSA 70 - 764 Certification : Guidance, Sample Papers, Material |
MCSA 70 - 765 Certification : Guidance, Sample Papers, Material |
Above course curriculum applicable for registrations from Dec 1st, 2019.
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and Mock Tests.