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 (DP 300) 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 + Power BI |
SQL DBA Course Duration | 6 Weeks | 9 Weeks | 13 Weeks |
Course Contents | Ch 1 to Ch 27 | Ch 1 to Ch 39 | Ch 1 to Ch 57 |
Completely Practical, Real-time | ✔ | ✔ | ✔ |
Routine SQL DBA Activities | ✔ | ✔ | ✔ |
Emergency SQL DBA Activities | ✔ | ✔ | ✔ |
SQL Server, DB Maintenance | ✔ | ✔ | ✔ |
DB Repairs, Security Management | ✔ | ✔ | ✔ |
Migrations, Patches, Upgrades | ✔ | ✔ | ✔ |
HA-DR : Replication, Log Shipping | ✔ | ✔ | ✔ |
HA-DR : Mirroring, Common Errors | ✔ | ✔ | ✔ |
Clustering, Always-On Availability | ✔ | ✔ | ✔ |
Tuning Tools, Execution Plans | ✔ | ✔ | ✔ |
Ticketing Tools, 3rd Party Tools | ✔ | ✔ | ✔ |
SLA-OLA, Incident Management | ✔ | ✔ | ✔ |
Azure SQL Database Migration | ✖ | ✔ | ✔ |
Azure SQL DB Security, HA-DR | ✖ | ✔ | ✔ |
Azure Always-On, PowerShell | ✖ | ✔ | ✔ |
Azure Virtual Machines (VM) | ✖ | ✔ | ✔ |
DP 300 Exam : Guidance | ✖ | ✔ | ✔ |
70-764, 70-765 Exams : Guidance | ✖ | ✔ | ✔ |
Power BI: Report Design, Visuals | ✖ | ✖ | ✔ |
Power BI: M Lang, DX for ETL | ✖ | ✖ | ✔ |
Power BI: Report Server, Admin | ✖ | ✖ | ✔ |
Power BI: Data Modelling with DAX | ✖ | ✖ | ✔ |
Power BI: PL 300 Exam Guidance | ✖ | ✖ | ✔ |
Total Course Fee * Payable in Installments |
INR 18,000 USD 244 |
INR 27,000 USD 365 |
INR 35,000 USD 473 |
Schedules for SQL DBA [Chapters 1 to 27] | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | Aug 18th | Register |
2 | 8 PM - 9 PM | Aug 29th | Register |
Schedules for Azure DBA [Chapters 28 to 39] | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Weekend Schedules [Sat & Sun] | ||||
3 | 6 AM - 7:30 AM | Aug 27th | Register | |
4 | 8 PM - 9:30 PM | Aug 20th | Register |
Schedules for Power BI [Chapters 40 to 57] | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 8 AM - 9 AM | Aug 30th | Register | |
2 | 6 PM - 7 PM | Jul 28th | Register | |
3 | 9 PM - 10 PM | Sep 5th | 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 |
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, DB Basics |
Module II: Basic SQL DBABackup-Restores, Jobs, Performance Tuning, Security |
Module III: Advanced SQL DBAHA-DR, Errors & Solutions, Always-On, SLA |
Ch 1: JOB ROLES, INSTALLATION
|
Ch 10: BACKUPS - DB, Filegroup, File
|
Ch 19: REPLICATION For HA - Level 1
|
Ch 2: SSMS Tool, SQL BASICS - 1
|
Ch 11: RESTORES & DB RECOVERY
|
Ch 20: REPLICATION For HA - Level 2
|
Ch 3: SQL BASICS For DBAs - 2
|
Ch 12: JOBS, MAINTENENCE PLANS
|
Ch 21: LOG SHIPPING (HA - DR)
|
Ch 4: SCHEMAS, TEMP TABLES
|
Ch 13: SECURITY MANAGEMENT - 1
|
Ch 22: DB MIRRORING (HA - DR)
|
Ch 5: CONSTRAINTS, INDEX Basics
|
Ch 14: MIGRATIONS & SECURITY - 2
|
Ch 23: Health Checks, Issues, Solutions
|
Ch 6: JOINS & AUDITS
|
Ch 15: Tuning 1 - Audits, Indexes
|
Ch 24: PATCHES, UPGRADES, CUs
|
Ch 7: View, Procedures, UDF Basics
|
Ch 16: Tuning 2 - INDEX MANAGEMENT
|
Ch 25: ALWAYS ON AVAILABILITY
|
Ch 8: Triggers & Transactions
|
Ch 17: Tuning 3 - Tuning Tools
|
Ch 26: SQL DBA PROJECT - Level 1
|
Ch 9: Server, DB Architecture
|
Ch 18: Tuning 4 - Lock Management
|
Ch 27: SQL DBA PROJECT - Level 2
|
Ch 28: Cloud Introduction & Azure
|
Ch 32: AZURE SQL DATABASE TUNING
|
Ch 36: Azure SQL Server in VM
|
Ch 29: Azure SQL Server, Database
|
Ch 33: Backups, Restores & HA DR
|
Ch 37: WINDOWS CLUSTERS SETUP
|
Ch 30: Azure Storage & Explorer Tool
|
Ch 34: Data Sync, Active Directory
|
Ch 38: ALWAYS-ON WITH SQL Server
|
Ch 31: Azure SQL DB Migration
|
Ch 35: SECURITY MANAGEMENT, RLS
|
Ch 39: Azure PowerShell
DP 300 Certification Guidance
|
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Ch 1 : POWER BI BASICS
|
Ch 7 : POWER QUERY LEVEL 1
|
Ch 13 : POWER BI CLOUD - 1
|
Ch 2: BASIC REPORT DESIGN
|
Ch 8 : POWER QUERY LEVEL 2
|
Ch 14 : POWER BI CLOUD - 2
|
Ch 3 : Visual Sync, Grouping
|
Ch 9 : POWER QUERY LEVEL 3
|
Ch 15 : EXCEL & RLS
|
Ch 4 : Hierarchies, Filters
|
Ch 10 : DAX Functions - Level 1
|
Ch 16 : Report Server, RDL
|
Ch 5 : Bookmarks, Azure, Modeling
|
Ch 11 : DAX Functions - Level 2
|
Ch 17: MSBI Integrations
|
Ch 6 : Visualization Properties
|
Ch 12 : DAX FUNCTIONS Level 3
|
Ch 18 : REAL-TIME PROJECT
|
Above course curriculum applicable for registrations from Apr 23rd, 2022
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and Mock Tests.