This SQL DBA 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 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 (70-764 & 70-765) 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 | 8 Weeks | 12 Weeks |
| Course Contents | Ch 1 to Ch 27 | Ch 1 to Ch 38 | Ch 1 to Ch 56 |
| 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) | ❌ | |
|
| MCSA Exams : Guidance | ❌ | |
|
| Azure Data Access for Analysis | ❌ | ❌ | |
| Basic to Advanced Analytics | ❌ | ❌ | |
| Report Design, Modeling, Security | ❌ | ❌ | |
| Power BI Cloud, Gateways | ❌ | ❌ | |
| Report Server Administration | ❌ | ❌ | |
| Gateway Management, Admin | ❌ | ❌ | |
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 |
For SQL DBA Online Training click @
Here
For SQL DBA Classroom Training click @
Here
For SQL DBA Video Training click @
Here
All Trainings are completely Practical and Real-Time.
