AZURESQLDBASlider1

#Azure SQL DBA

Cloud Database Administrators (DBAs) are always in demand. As an Azure SQL DBA, we are responsible for Cloud Database Maintenance, Automated & Manual Repairs, Troubleshooting, Optimizations, Cloud Computing, Updates, Upgrades, Security, Data Cleaning, HA-DR, Always-On (AG) Groups and more..

Training Highlights

✅ Azure SQL Administration
✅ Database Deployment, Migrations
✅ Backup, Restore, Geo-Replication
✅ High Availability, DR Setup
✅ Intelligent Query Processing
✅ Security, RBAC, Data Masking
✅ Monitoring & Log Analytics
✅ Automation with Azure Runbooks
✅ 1:1 Mentorship, DP 300 Exam Guidance

Modules We Learn:

✅Plan A: Azure SQL DBA
✅Plan B: Core SQL DBA + Azure SQL DBA

Course Duration: 10 Weeks

Get Ready for High-Demand Database Careers with Azure SQL DBA Training by SQL School India

SQL DBA
Course Contents:

Brochure Download Request a Callback

Module 1: Database & SQL Concepts

Ch 1: SQL Database Job Roles

Introduction to Databases
DBA Job Roles
Routine DBA Activities
Emergency DBA Activities
SQL DBA Job Scope, Job Growth

Ch 2: Database Intro & Installations

Database Intro & Types (OLTP, DWH, ..)
DBMS Concepts
SQL Server 2025 Installations
SSMS Tool Installation
Server Connections, Authentications
Installation Issues, Solutions

Ch 3: SQL Basics

SSMS Tool Usage
SQL Basics
DDL: Create, Alter, Drop
DML: Insert, Update, Delete
SELECT
Excel Imports

Ch 4: Constraints, Keys & RDBMS

Unique, Primary Key Constraints
Foreign Key & References
Default, Check Constraints
Normal Forms

Ch 5: Joins & Audits

Joins: Table Comparisons
Inner Joins & Matching Data
Outer Joins: LEFT, RIGHT
Full Outer Joins & Aliases
Cross Join & Table Combination

Ch 6: Database Objects

Views: Realtime Usage
DML, SELECT with Views
Stored Procedures: Realtime Use
System Stored Procedures
Inline & Multiline Functions

Ch 7: Linked Servers

SQL Server Instances
Linked Server : Creation
Linked Server : Testing
Realtime Usage @ DBA
Remote DB Access

Ch 8: Server Architecture

Database Engine Components
Parser, Compiler & Optimizer
Protocols and Query Processing
MDAC and CLR Components
Memory Manager & IO Managers
SQL OS Components, MDAC

Ch 9: DB Architecture (VLDB)

Planning Large Databases
Filegroups, Spacing and Sizing
Log File: Usage and Precautions
Pages and Extents for Storage
VLF, MiniLSN & Checkpoint

Module 2: Core SQL DBA Concepts

Ch 10: Backups

Database Backups & Types
DB, Filegroup, File Backups
Copy Only Backups, Usage
Partial Backups, Split Backups
Mirror Backups
Backup Verifications
Checksum, ContinueOnError

Ch 11: Restores

DB, Filegroups, File Restores
GUI Restores: Limitations
Restoring & Online States
FILELISTONLY
MOVE Options with Restores
Standby Mode Restores
Point-In-Time (PITR) Restores

Ch 12: Jobs, Maintenance & DB Mail

SQL Server Agent Service
Job Steps & Schedules
DB Maintenance Plans
Backup Maintenance
Common Errors, Solutions
SMTP, Email Profile
Alert System : Agent Settings
Operators, Job Notifications j

Ch 13: Security Management

Security Objects, Logins
Users, Roles & Principals
Schema Level Security
Object, Column Level Security
Security Audit, Logon Failures
Keys & Certificates
Encryptions & Data Security

Ch 14: DB Migrations

Creating Credentials
Creating SSIS Proxies
Creating CDW Packages
Database Detach – Attach
SMO Migration Method
DB Migration Schedules
Detect, Fix Orphan Users

Ch 15: Tuning: Audits, AM Tool

Activity Monitor Tool
Perfmon Tool & Counters
Query Audits: DMVs, DMFs
Plan Handle, Execution Time
Long Running Queries
Query Store & Data Flush

Ch 16: Tuning: Indexes

Indexes : Sort Locations
Clustered & Online Indexes
Non Clustered, Column Store
Included Indexes in Realtime
Filtered Indexes & Usage
Covering Index & Selectivity
Indexed Views (Materialized)

Ch 17: Tuning: Partitions

Partitions: Performance Tuning
Partition Functions & Schemes
Partition Un-partitioned Tables
Compressions: ROW, PAGE
Partitions Limitations in OLTP
Partitions with DWH

Ch 18: Statistics & Tuning

Statistics: Realtime Usage
Index & Column Statistics
Statistics & Key Purpose
Statistics Versus Indexes
Stats Updates on Tables
Stats Updates on Views

Ch 19: Index Management

Index Management Options
Index Rebuilds, Re-Organize
Database Maintenance Plans
Page Count and DOP
Resumable & Online Indexes
PAUSE, RESUME in Rebuilds

Ch 20: Tuning Tools

Tuning Tools: Workload Files
Profiler Tuning, Events
DTA, Profiler Options
Physical Design Structures
PDS Recommendations
Query Execution Cache
Tuning Tools: Precautions

Ch 21: Execution Plans

Execution Plan Analysis
IO Cost and CPU Cost
SubTree & Operator Cost
NUMA Nodes, Processor Affinity
Thread Count, DOP
CTEs & Tuning

Ch 22: Lock Management

Open Transactions in Realtime
Open Transaction, Blocking
LOCKS: Types & Audits
S, X, IX, U and MD Locks
Sch-M and Sch-S Locks
SP_WHO2, SP_LOCK
sysprocesses & Lock Waits

Ch 23: Isolation Levels

Lock Hints and Isolation Levels
Read Committed, Uncommitted
Serializable, Repeatable Read
Snapshot Isolation, Versioning
Read Committed Snapshot
sysprocesses & sp_who2
Choosing Correct Isolation Level

Ch 24: Deadlocks, LIVE Locks

Deadlocks in Real-world
Profiler Tool & Deadlocks
Lock Management: Deadlocks
Deadlock Graphs & Events
Deadlock Avoidance, Prevention
Deadlock Prevention
sysprocesses & sp_who2

Ch 25: Recovery Models

Recovery Models
Database Properties
Full Recovery Model
Simple & Bulk Logged
Realtime Uses
Backups Versus Recovery Models

Ch 26: HA DR @ Replication – 1

Replication : Realtime Usage
Distributor Configurations
Publisher and Subscriber
Replication Types: Snapshot
Transactional Replication
Log Reader Agent & Usage
Replication Monitor, Alerts

Ch 27: HA DR @ Replication – 2

Merge Replication & Usage
Peer – Peer Replication
Push & Pull Subscriptions
Conflict Detection, Avoidance
Scripting Replication Agents
Limitations with Replication
Common Errors, Solutions

Ch 28: HA DR @ Log Shipping

Log Shipping Configurations
Primary, Secondary Servers
Working with Network Shares
Jobs: Backup, Copy, Restore
NORECOVERY, STANDBY
Manual Failover Process
Common Errors, Solutions

Ch 29: HA DR @ DB Mirroring

Database Mirroring Concepts
Configuring Principal, Mirror
Configure Witness, EndPoint
Synchronous, Asynchronous
Automated Failover Process
Manual Failover, Monitoring
Common Errors, Solutions

Ch 30: DB Health Checks, Repairs

DBCC Commands in Realtime
DBCC for Audits, Repairs
MSDB Suspect Pages
User Database Repairs
Single User Mode
Emergency Mode
Recovery & Restoring Modes

Ch 31: Issues & Solutions

Log Space Issues, Solutions
TempDB Issues, Solutions
Memory Issues, Solutions
Health Check Strategies
Healthy Backups
Maintenance Plans
Database States

Ch 32: Updates & Upgrades

Pre-Maintenance Checklist
Updates Process
Upgrades Process (In-Place)
Cautions & Maintenance
Rollbacks

Ch 33: System DB Rebuilds, DAC

Command Line Installations
System DB Rebuilds
Server Down Issues
Service Startup Issues
DAC: Dedicated Admin Console
Login Failure Issues
SQL CMD : Secondary Logins

Ch 34: SQL DBA Project – 1

Routine DBA Activities
Emergency DBA Activities
Maintenance DBA Activities
SLA – OLA Process
Ticketing Tools
3rd Party Tools
Common Errors & Solutions

Ch 35: SQL DBA Project – 2

Login Failure Errors
Slow Database Issues
Network Errors
Security Strategies
HA DR Strategies
Common Error Codes
Need for Azure Cloud

Module 3: Realtime Project 1

Enterprise SQL Server Database Administration Project (On-Premises)
Domain: E-Commerce / Retail
Environment

Windows Server
SQL Server 2022 Enterprise
Routine SQL DBA Activities
Maintenance DBA Activities
Performance Tuning
Troubleshooting

Module 4: Azure SQL DBA with AI

Ch 36: Cloud Basics, Azure Funda

Cloud Fundamentals
Cloud Concepts, Benefits
IaaS, PaaS, SaaS Cloud Types
Azure Cloud Concepts
Azure Resources & Usage
Azure Services & Purpose
Azure Account & Subscription

Ch 37: Azure SQL Deployments

Azure SQL Services
Azure SQL Server Creation
Azure SQL Databases
Azure Firewall : Rules
Test Connections from SSMS
SSMS Tool : Test Connections
ADS Tool : Installation, use

Ch 38: Azure SQL DB Licensing

Azure SQL DB Licensing
Per Database Licensing
DTUs: Basic, Standard Types
VPU and Plan Types
DTU Versus VPU Licensing
Elastic DTUs (eDTU) Usage
Elastic Query Processing

Ch 39: Azure SQL DB Migrations

SQL DB Migration Options
Data Migration Assistant: DMA
DMA Tool, Migration Options
On-Premises DB Export
Azure SQL Database Import
Azure Storage Account

Ch 40: Azure SQL DB Metrics

Azure SQL DB Metrics
CPU, Memory, Log Metrics
Data File Metrics, Alerts
Action Groups & Emails
Query Performance Insight
Automated Tuning Options
Query Recommendations

Ch 41: Azure SQL DB Tuning, AI

Server Level Tuning
Database Level Tuning
Built-In Intelligence
AI Search Service, Tuning
AI Indexes, Practical Use
Watermark Columns

Ch 42: Azure Backups, Restores

Azure SQL DB Backups
Backup Retention Options
LTR Backups, Log Backups
Automated Backups
LTR, PITR Restores
Backup Versus Export
Restore Versus Import

Ch 43: HA DR @ Replication

Azure HA DR Mechanisms
Geo Replication
Primary & Secondary
Manual Failover
Automated Failover
DMVs For Replication
Testing Read Only Databases

Ch 44: HA DR @ Server Failover

Multi Database Replication
Configure Server HADR
Adding Replica Databases
Replica DB: Capacity
Replica DB: Status
Automated Failover

Ch 45: Azure Security

Logins & Users in Azure
Grant, With Grant
Dynamic RLS
Dynamic Data Masking
Implementing RBAC
MFA Authentication

Ch 46: Azure Virtual Machine

Azure IaaS Implementation
Configure Disk, Network
Configure SQL Security
CPU, Processor & IO
IP & RDP Connections
Migrating SQL 2025 to VM

Ch 47: Azure VM Clusters

Azure Active Directory
Azure AD DS Services
Azure Networking Options
Listeners and Realtime Use
FSW: File Share Witness

Ch 48: SQL Clusters, Always-On

Creating SQL Clusters
Configure Always-On
Testing, Using Always-On
AOAG Implementation
AOAG Monitoring
Comparing Paas & IaaS

Ch 49: PowerShell

Azure PowerShell
Az and get Commands
Creating Resources
Lists & Validations
Firewall Config
Resource Cleanups

Ch 50: Azure Managed Instance

Azure MI Implementation
Network Entities for MI
Cloud Azure MI Access
Azure MI Implementation
Azure MI Migrations

Module 5: Realtime Project – 2

Enterprise SQL Server Database Administration Project (Azure Cloud)
Domain: E-Commerce / Retail
Environment

Routine SQL DBA Activities
Maintenance DBA Activities
Performance Tuning
Troubleshooting
Azure Cloud Migrations
Azure Cloud Management
Azure Cloud (IaaS) Clusters
Always-On

Module 6: DP-300 Exam Guidance

Realtime Project For your Resume: End to End Project
CoPilot Integrations For DB Administration
Resume Guidance (1:1)
Mock Interview, DP 300 Exam Guidance

SQL SCHOOL vs Other Institutes

Training Modes

LIVE Online Training

Instructor Led

Self Paced Videos

On-Demand

Corporate Training

With 100% Hands-On

Why Choose SQL School

100% Real-Time and Practical
ISO 9001:2008 Certified
Concept wise FAQs
TWO Real-time Case Studies, One Project
Weekly Mock Interviews
24/7 LIVE Server Access

A man smiling and giving a thumbs up while holding a notebook.

Realtime Project FAQs
Course Completion Certificate
Placement Assistance
Job Support
Realtime Project Solution
MS Certification Guidance