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 + Azure DevOps |
SQL DBA Course Duration | 3 Weeks | 9 Weeks | 13 Weeks |
Course Contents | Ch 28 to Ch 39 | Ch 1 to Ch 39 | Ch 1 to Ch 57 |
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 | ✖ | ✔ | ✔ |
Azure DevOps Benefits | ✖ | ✖ | ✔ |
SDLC, Dev & Operations, DevOps | ✖ | ✖ | ✔ |
DevOps Tools, Git & GitHub | ✖ | ✖ | ✔ |
Docker, Kubernetes, AzureDevOps | ✖ | ✖ | ✔ |
Azure Boards, Azure Repos | ✖ | ✖ | ✔ |
Azure Testing, Azure Artifacts | ✖ | ✖ | ✔ |
Azure Pipelines (CI, CD) | ✖ | ✖ | ✔ |
Total Course Fee * Payable in Installments |
INR 9,000 USD 122 |
INR 27,000 USD 365 |
INR 39,000 USD 527 |
Schedules for Azure DBA [Chapters 28 to 39] | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Weekend Schedules [Sat & Sun] | ||||
1 | 6 AM - 8 AM | Mar 13th | Register | |
2 | 8 PM - 10 PM | Mar 27th | Register |
Schedules for SQL DBA [Chapters 1 to 27] | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | Mar 23rd | Register |
2 | 8 PM - 9 PM | Mar 4th | 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: 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 INTRO, AZURE CONFIG
|
Ch 32: XEL, STRETCH DATABASES
|
Ch 36: POWERSHELL, AZURE VMs
|
Ch 29: AZURE SQL SERVER CONFIG
|
Ch 33: ALERTS, BACKUPS / RESTORES
|
Ch 37: Windows Clusters with Azure VM
|
Ch 30: ELASTIC DTUs, MIGRATION
|
Ch 34: HA - DR : Geo Replication, DB Sync
|
Ch 38: Always-On in SQL Server Clusters
|
Ch 31: AZURE SQL DATABASE TUNING
|
Ch 35: SECURITY MANAGEMENT, RLS
|
Ch 39: Project Work, DP 300 Exam
Real-time Project
DP 300 Certification Guidance
|
Module I: Azure Funda & DevOps Basics |
Module II: Azure DevOps Service - 1 |
Azure DevOps Service - 2
|
Ch 1. Azure Fundamentals
|
Ch 7: Organizations & Projects
|
Ch 13: Azure Functions, App Service, Alerts
|
Ch 2. Azure Services, Configurations
|
Ch 8: Azure Boards
|
Ch 14: Azure DevOps Resources in Portal
|
Ch 3. Azure Active Directory, Monitoring
|
Ch 9: Azure Repos
|
Ch 15: Azure DevOps Strarter, App Insights
|
Ch 4. SDLC, Dev & Operations, DevOps
|
Ch 10: Azure Pipelines For CI/CD - 1
|
Ch 16: Power Shell & Azure DevOps
|
Ch 5. DevOps Tools, Git & GitHub
|
Ch 11: Azure Pipelines For CI/CD - 2
|
Ch 17: DevOps Server - Configurations
|
Ch 6. Docker, Kubernetes, AzureDevOps
|
Ch 12: Azure Testing & Artefacts
|
Ch 18: DevOps Server & Visual Tools
|
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.