This SQL DBA Video Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities : Capacity Planning, Query Tuning, Index Management, DB Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management, Security Management, Upgrades. Additionally includes Azure SQL DBA Activities including Azure Active Directory, Azure SQL DB Migrations, Azure SQL DB Tuning, XEL, Azure DB Sync, Server Failover, Geo Replication, Azure Virtual Machines and Azure HA-DR.
This SQL DBA Video 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 (DP 300) and Real-time Projects for your Resume. Versions: SQL Server 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 + Azure DevOps |
No of Videos | Videos 1 to 27 | Videos 1 to 39 | Videos 1 to 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 | ✖ | ✔ | ✔ |
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 18,000 USD 244 |
INR 27,000 USD 365 |
INR 39,000 USD 527 |
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 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 |
Video 1: JOB ROLES, INSTALLATION
|
Video 10: BACKUPS - DB, Filegroup, File
|
Video 19: REPLICATION For HA - Level 1
|
Video 2: SSMS Tool, SQL BASICS - 1
|
Video 11: RESTORES & DB RECOVERY
|
Video 20: REPLICATION For HA - Level 2
|
Video 3: SQL BASICS For DBAs - 2
|
Video 12: JOBS, MAINTENENCE PLANS
|
Video 21: LOG SHIPPING (HA - DR)
|
Video 4: SCHEMAS, TEMP TABLES
|
Video 13: SECURITY MANAGEMENT - 1
|
Video 22: DB MIRRORING (HA - DR)
|
Video 5: CONSTRAINTS, INDEX Basics
|
Video 14: MIGRATIONS & SECURITY - 2
|
Video 23: Health Checks, Issues, Solutions
|
Video 6: JOINS & AUDITS
|
Video 15: Tuning 1 - Audits, Indexes
|
Video 24: PATCHES, UPGRADES, CUs
|
Video 7: View, Procedures, UDF Basics
|
Video 16: Tuning 2 - INDEX MANAGEMENT
|
Video 25: ALWAYS ON AVAILABILITY
|
Video 8: Triggers & Transactions
|
Video 17: Tuning 3 - Tuning Tools
|
Video 26: SQL DBA PROJECT - Level 1
|
Video 9: Server, DB Architecture
|
Video 18: Tuning 4 - Lock Management
|
Video 27: SQL DBA PROJECT - Level 2
|
Video 28: CLOUD INTRO, AZURE CONFIG
|
Video 32: XEL, STRETCH DATABASES
|
Video 36: POWERSHELL, AZURE VMs
|
Video 29: AZURE SQL SERVER CONFIG
|
Video 33: ALERTS, BACKUPS / RESTORES
|
Video 37: Windows Clusters with Azure VM
|
Video 30: ELASTIC DTUs, MIGRATION
|
Video 34: HA - DR : Geo Replication, DB Sync
|
Video 38: Always-On in SQL Server Clusters
|
Video 31: AZURE SQL DATABASE TUNING
|
Video 35: SECURITY MANAGEMENT, RLS
|
Video 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
|
Video 1. Azure Fundamentals
|
Video 7: Organizations & Projects
|
Video 13: Azure Functions, App Service, Alerts
|
Video 2. Azure Services, Configurations
|
Video 8: Azure Boards
|
Video 14: Azure DevOps Resources in Portal
|
Video 3. Azure Active Directory, Monitoring
|
Video 9: Azure Repos
|
Video 15: Azure DevOps Strarter, App Insights
|
Video 4. SDLC, Dev & Operations, DevOps
|
Video 10: Azure Pipelines For CI/CD - 1
|
Video 16: Power Shell & Azure DevOps
|
Video 5. DevOps Tools, Git & GitHub
|
Video 11: Azure Pipelines For CI/CD - 2
|
Video 17: DevOps Server - Configurations
|
Video 6. Docker, Kubernetes, AzureDevOps
|
Video 12: Azure Testing & Artefacts
|
Video 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.