SQL Database Administration (SQL DBA) Course

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

 
 
24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today

SQL DBA (with Server, T-SQL, Azure SQL DBA)

  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 9 Weeks 13 Weeks
Course Contents Ch 1 to Ch 27 Ch 1 to Ch 39 Ch 1 to Ch 57
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
70-764, 70-765 Exams : Guidance
Power BI: Report Design, Visuals
Power BI: M Lang, DX for ETL
Power BI: Report Server, Admin
Power BI: Data Modelling with DAX
Power BI: DA 100 Exam Guidance
Total Course Fee
* Payable in Installments
INR 18,000
USD 244
INR 27,000
USD 365
INR 35,000
USD 473

SQL DBA Training - Trainer : Mr. Sai Phanindra T [16+ Yrs of Exp]

 

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 Video Training click @ Here

All Trainings are completely Practical and Real-Time.

 

Curriculum Download


24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today

Job-Oriented Real-time Training @ SQL School Training Institute

SQL Server, SQL DBA, MSBI, Azure SQL Dev, Azure SQL DBA, Azure BI, Power BI Training

 
 
 
All Training Sessions are completely practical and real-time. 24x7 LIVE Server & Lab Available. Payments via Paypal in Installments.