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 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 Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Routine SQL DBA Activities Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Emergency SQL DBA Activities Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Server, DB Maintenance Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
DB Repairs, Security Management Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Migrations, Patches, Upgrades Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
HA-DR : Replication, Log Shipping Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
HA-DR : Mirroring, Common Errors Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Clustering, Always-On Availability Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Tuning Tools, Execution Plans Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Ticketing Tools, 3rd Party Tools Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SLA-OLA, Incident Management Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure SQL Database Migration Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure SQL DB Security, HA-DR Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure Always-On, PowerShell Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure Virtual Machines (VM) Croos-symbol-for-Yes Check-Symbol-for-Yes
MCSA Exams : Guidance Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure Data Access for Analysis Check-Symbol-for-Yes
Basic to Advanced Analytics Check-Symbol-for-Yes
Report Design, Modeling, Security Check-Symbol-for-Yes
Power BI Cloud, Gateways Check-Symbol-for-Yes
Report Server Administration Check-Symbol-for-Yes
Gateway Management, Admin Check-Symbol-for-Yes

SQL DBA Training - Trainer : Mr. Sai Phanindra T [13+ 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 Classroom 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.