Complete Real-time and Practical Azure SQL Database Training with Real-time Scenarios. This course includes complete practical approach to Azure SQL Database Administration (Azure SQL DBA) activities including On-premise to Azure Azure Database Migrations, Troubleshooring, Security Management, Geo Replication, Azure Server Failover, Storage Management, Virtual Machines, In-depth Query Tuning, Stretch Databases, Azure Shell, Power Shell, In - Memory Tables, Azure Search, Sharding, and SQL Managed Instances. This Azure SQL DBA course also includes One Real-time Project with Routine DBA Activiteis and Emergency DBA Activities.
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 | Feb 27th | Register | |
2 | 8 PM - 10 PM | Mar 13th | 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 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: 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 March 6th, 2020