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 + ETL Admin |
Course Duration | 6 Weeks | 9 Weeks | 20 Weeks |
Course Contents | Ch 1 to Ch 30 | Ch 31 to Ch 40 | Ch 1 to Ch 68 |
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 | ✖ | ✔ | ✔ |
ETL Admin | ✖ | ✖ | ✔ |
ADE: Azure Data Factory [ADF] | ✖ | ✖ | ✔ |
ADE: Azure Synapse | ✖ | ✖ | ✔ |
ADE: Azure Storage | ✖ | ✖ | ✔ |
ADE: Stream Analytics | ✖ | ✖ | ✔ |
ADE: Azure Databricks | ✖ | ✖ | ✔ |
Total Course Fee* | INR 20000 USD 300 |
INR 28000 USD 400 |
INR 50000 USD 630 |
Schedules for Core DBA [Chapters 1 to 30] | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
1 | 6 AM - 7 AM | Oct 23rd | Register |
2 | 9 PM - 10 PM | Oct 3rd | Register |
Schedules for Azure DBA [Chapters 31 to 40] | |||
S No | Time (IST, Sat & Sun) | Start Date | |
---|---|---|---|
3 | 6 AM - 7:30 AM (W) | Sep 23rd | Register |
4 | 8 PM - 9:30 PM (W) | Oct 14th | 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: DATABASE INTRO & SQL DBA
|
Ch 11: BACKUPS & MANAGEMENT
|
Ch 21: REPLICATION For HA - Level 1
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 12: RESTORES & DB RECOVERY
|
Ch 22: REPLICATION For HA - Level 2
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 13: JOBS, MAINTENENCE PLANS
|
Ch 23: LOG SHIPPING (HA - DR)
|
Ch 4: SQL BASICS - 2
|
Ch 14: RECOVERY, DB SNAPSHOTS
|
Ch 24: DB MIRRORING (HA - DR)
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 15: SECURITY MANAGEMENT
|
Ch 25: HEALTH CHECKS & ERRORS
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 16: DATABASE MIGRATIONS
|
Ch 26: LOCK MANAGEMENT
|
Ch 7: JOINS & LINKED SERVERS
|
Ch 17: SERVER ARCHITECTURE, AUDITS
|
Ch 27: PATCHES, UPGRADES, CUs
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 18: PAGE ARCHITECTURE, INDEXES
|
Ch 28: SLA, OLA PROCESS FOR DBA
|
Ch 9: TRIGGERS & TRANSACTIONS
|
Ch 19: TUNING: INDEX MANAGEMENT
|
Ch 29: SQL DBA PROJECT - Level 1
|
Ch 10: DB Architecture & Group By
|
Ch 20: TUNING TOOLS, EXEC PLANS
|
Ch 30: SQL DBA PROJECT - Level 2
|
Ch 31: CLOUD INTRO, AZURE CONFIG
|
Ch 36: HA-DR : GE REPLICATION, SYNC
|
Ch 32: AZURE SQL SERVER CONFIG
|
Ch 37: SECURITY MANAGEMENT, RLS
|
Ch 33: ELASTIC DTUs, MIGRATION
|
Ch 38: POWERSHELL, AZURE VMs
|
Ch 34: AZURE SQL DATABASE TUNING
|
Ch 39: WINDOWS CLUSTERS SETUP
|
Ch 35: ALERTS, BACKUPS / RESTORES
|
Ch 40: ALWAYS-ON WITH SQL Server
|
DP 300 - Exam Samples, Guidance |
Resume, Course Participation Certificate, Mock Interview |
Part 1: Azure Data Factory, Synapse Analytics |
Part 2: Data Lake Storage, Stream Analytics |
Part 3: Databricks, Spark, Python |
||
Chapter 1: Cloud Basics, Azure SQL
|
Chapter 1: Azure Fundamentals - Storage
|
Chapter 1: Azure Intro, Azure Databricks
|
||
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Storage Operations
|
Chapter 2: SparkDatabase, SQL Notebooks
|
||
Chapter 3: Azure Data Factory, Pipelines
|
Chapter 3: Azure Storage Security, ACLs
|
Chapter 3: Python Intro, Data Loads
|
||
Chapter 4: OnPremise Data Loads, Upsert
|
Chapter 4: SQL Database Migrations
|
Chapter 4: PySpark with ADLS
|
||
Chapter 5: File Incremental Loads in ADF
|
Chapter 5: Azure Tables & Replication
|
Chatper 5: PySpark Widgets
|
||
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: Architecture, Workflows
|
||
Chapter 7: ADF Data Flow - 2
|
Chapter 7: Azure Event Hubs
|
Chapter 7: Databricks Security, Scala
|
||
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Storage Architecture, Queues
|
Chapter 8: Scala with ADLS, Azure SQL
|
||
Chapter 9: Synapse Analytics with Spark
|
Chapter 9: Monitoring & Key Vaults
|
Chapter 9: DeltaLake Incr Loads, DWH
|
||
Chapter 10: Synapse Security & Parameters
|
Real-time Project (End to End)
|
|||
Chapter 11: Change Data Capture (CDC)
|
Azure Data Engineering with Power BI (For Power BI Registrations)
|
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.