This Azure 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 and Security Management.
This SQL DBA Online Training also practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters as well as in LINUX Clusters. Additionally, this SQL DBA Training Course extents to Microsoft (Cloud) SQL Azure Migrations, Geo Replication, Azure DB Sync, Azure Database Tuning and Security Management. Study Material, MCSA SQL DBA Certification (DP 300) with Real-time Projects for your Resume as also a part of this SQL DBA Training Course. Versions: SQL Server 2014, 2016, 2017 and 2019.
PLAN A | PLAN B | PLAN C | |
SQL DBA Job Profile | Azure DBA | Core DBA + Azure DBA |
Core DBA + Azure DBA + ETL Admin |
Course Contents | Ch 31 to Ch 40 | Ch 21 to Ch 40 | Ch 1 to Ch 58 |
Azure SQL Database Migration | ✔ | ✔ | ✔ |
Azure SQL DB Security, HA-DR | ✔ | ✔ | ✔ |
Azure Always-On, PowerShell | ✔ | ✔ | ✔ |
Azure Virtual Machines (VM) | ✔ | ✔ | ✔ |
DP 300 Exam : Guidance | ✔ | ✔ | ✔ |
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 | ✖ | ✔ | ✔ |
ETL Admin | ✖ | ✖ | ✔ |
ADE: Azure Data Factory [ADF] | ✖ | ✖ | ✔ |
ADE: Azure Synapse | ✖ | ✖ | ✔ |
ADE: Azure Storage | ✖ | ✖ | ✔ |
ADE: Stream Analytics & Azure Databricks | ✖ | ✖ | ✔ |
SQL DBA Course Duration | 3 Weeks | 9 Weeks | 16 Weeks |
Schedules for Core DBA [Chapters 1 to 30] | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
1 | 6 AM - 7 AM | June 26th | Register |
2 | 9 PM - 10 PM | June 7th | Register |
Schedules for Azure DBA [Chapters 31 to 40] | |||
S No | Time (IST, Sat & Sun) | Start Date | |
---|---|---|---|
3 | 6:30 AM - 8 AM (W) | June 10th | Register |
4 | 9 PM - 10:30 PM (W) | June 3rd | Register |
Azure 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 Azure 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
|
Mod 1: Azure Data Factory [ADF], Synapse |
Mod 2: Azure Storage & Stream Analytics |
Mod 3: Azure Databricks & SparkSQL |
Chapter 1: Cloud Basics, Azure SQL DB
|
Chapter 1: Azure Storage & Containers
|
Chapter 1: Azure Intro, Azure Databricks
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Migration, BLOB Imports
|
Chapter 2: SQL Notebooks & Python
|
Chapter 3: Azure Data Factory Concepts
|
Chapter 3: Azure Tables, Shares
|
Chapter 3: Python Notebooks
|
Chapter 4: ADF Pipelines, Polybase
|
Chapter 4: Azure Storage Security, Admin
|
Chapter 4: Open Data Sources, DeltaLakes
|
Chapter 5: OnPremise Data with ADF
|
Chapter 5: Azure Monitoring, Power BI
|
Chapter 5: Databricks Security & Jobs
|
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: Databricks @ BLOB, Power BI
|
Chapter 7: ADF Data Flow - 2
|
Chapter 7: IoT Hubs & Event Hubs
|
Chapter 7: Databricks Integrations
|
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Azure Stream Analytics Security
|
Real-Time Project
|
Chapter 9: Synapse Analytics with Spark
|
||
Chapter 10: Incremental Loads @ Synapse
|
||
Chapter 11: Optimizations, Power Query
|
||
Chapter 12: Pipeline Monitoring, Security
|
Above course curriculum applicable for registrations from Dec 2nd, 2020
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and Mock Tests.