Skip to main content
SQL_DBA_1920x700
previous arrow
next arrow

#SQL DBA with Azure, AI

Database Administrators (DBAs) are always in demand. As a DBA, we are responsible for Database Maintenance, Repairs, Troubleshooting, Optimizations, Updates, Upgrades, Security, Data Cleaning and more..

Training Highlights

✅ SQL Server Installation & Configuration
✅ Backup, Restore & Recovery Strategies
✅ HA-DR Strategies, Tuning & Issues
✅ Tuning, Alerts, Troubleshooting
✅ Upgrades, Patching & Security
✅ Azure SQL DB Migrations
✅ Azure AI Search, Licensing
✅ Azure VMs, Always-On (AOAG)
✅ 3rd Party Tools, DAC, Rebuilds 

Modules We Learn:

✅ Module 1: Database Concepts, Core SQL DBA
✅ Module 2: Azure SQL DBA
✅ Module 3: PostgreSQL DBA Concepts
✅ Module 4: PostgreSQL Administration (Azure)

Course Duration: 9 Weeks

 

 

Play VideoPlay Video

SQL DBA
Course Contents:

Brochure Download Request a Callback

Module 1: SQL Server Concepts & Architecture

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

  • SQL Server Installations
  • Instance & Collations
  • SSMS Tool Installation
  • Connections, Authentications
  • Common Installation Issues

Ch 3: SQL Basics

  • SQL Basics (DDL, DML, etc.)
  • Creating Databases, Tables
  • Data Inserts (GUI, SQL)
  • Basic SELECT Queries
  • Excel Data Imports

Ch 4: Schemas & Batches

  • Schemas & Table Grouping
  • Real-world Banking Database
  • 2 Part, 3 Part & 4 Part Naming
  • Batch Concept & “Go” Command

Ch 5: Constraints & Joins

  • Null, Not Null Constraints
  • Unique Key & Check
  • Primary Key Constraint
  • Foreign Keys, Default
  • Inner Joins & Matching Data
  • Outer Joins: LEFT, RIGHT
  • Full Outer Joins & Aliases

Ch 6: Database Objects

  • Views: Realtime Usage
  • Row Level Security (RLS)
  • Important System Views
  • Stored Procedures: Realtime Use
  • Parameters Concept with SPs

Ch 7: Transactions & ACID

  • Auto Commit Transaction
  • Explicit Transactions
  • COMMIT, ROLLBACK
  • Checkpoint & Query Blocking
  • READPAST, LOCKHINT

Ch 8: Linked Servers

  • SQL Server Instances
  • Linked Server: Creation
  • Linked Server: Testing
  • Scripting Linked Servers
  • Realtime Usage
  • Remote DB Access

Ch 9: Server Architecture

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

Ch 10: DB Architecture (VLDB)

  • Planning Large Databases
  • Primary, Secondary Data Files
  • Filegroups, Spacing and Sizing
  • Log File: Usage and Precautions
  • Creating Tables with Filegroups
  • Pages and Extents for Storage
  • VLF, MiniLSN & Checkpoint

Module 2: Core SQL DBA

Ch 11: Backups

  • Database Backups & Types
  • DB, Filegroup, File Backups
  • Copy Only Backups, Usage
  • Partial Backups, Split Backups
  • Mirror Backups, Verifications
  • Checksum, Continue On Error

Ch 12: 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 13: Jobs, Maintenance Plans

  • SQL Server Agent Service
  • Job Steps & Schedules
  • DB Maintenance Plans
  • Backup Maintenance
  • Common Errors, Solutions

Ch 14: Database Mail

  • DB Mail
  • SMTP, Email Profile
  • Alert System: Agent Settings
  • Operators, Job Notifications j
  • Email Connections, Tests

Ch 15: Security Management – 1

  • Security Objects, Logins
  • Users, Roles & Principals
  • Schema Level Security
  • Object, Column Level Security
  • Security Audit, Logon Failures

Ch 16: Security Management – 2

  • Keys & Certificates
  • Encryptions & Data Security
  • Master Key
  • Certificates & Subject
  • Password Encryptions

Ch 17: DB Migrations

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

Ch 18: 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 19: Tuning: Indexes

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

Ch 20: Tuning: Partitions

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

Ch 21: Statistics & Tuning

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

Ch 22: Index Management

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

Ch 23: Tuning Tools

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

Ch 24: Execution Plans

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

Ch 25: 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 26: 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 27: 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 28: Recovery Models

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

Ch 29: HA DR @ Replication – 1

  • Replication: Realtime Usage
  • Distributor Configurations
  • Publisher and Subscriber
  • Snapshot, Transactional
  • Replication Monitor, Alerts

Ch 30: HA DR @ Replication – 2

  • Merge Replication & Usage
  • Subscription Options
  • Push & Pull Subscriptions
  • Scripting Replication Agents
  • Limitations with Replication

Ch 31: HA DR @ Replication – 3

  • Peer – Peer Replication
  • Peer Originator Nodes
  • Conflict Detection, Avoidance
  • Scripting Replication Agents
  • Common Errors, Solutions

Ch 32: 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 33: 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 34: 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 35: Issues & Solutions

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

Ch 36: Updates & Upgrades

  • Updates Process
  • RTM, SP, CU (Cumulative Updates)
  • Upgrades Process (In-Place)
  • Cautions & Maintenance
  • Rollbacks

Ch 37: 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 38: SQL DBA, SLA & OLA Process

  • SLA – OLA Process
  • Ticketing Tools
  • 3rd Party Tools
  • Incident Management

Ch 39: SQL DBA Project – Phase 1 (Enterprise SQL Server Database Administration)

  • Routine DBA Activities
  • Emergency DBA Activities
  • Maintenance DBA Activities
  • Auditing Techniques
  • RCA (Root Cause Analysis)

Ch 40: SQL DBA Project – Phase 2 (Enterprise SQL Server Database Administration)

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

Module 3: Azure SQL DBA

Ch 41: Cloud Basics, Azure Funda

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

Ch 42: Azure SQL Deployments

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

Ch 43: Azure SQL DB Licensing

  • Azure SQL DB Licensing
  • Per Database Licensing
  • DTUs: Basic, Standard Types
  • VPU and Plan Types
  • DTU Versus VPU Licensing

Ch 44: Elastic Pools

  • Creating Elastic Pools
  • Elastic DTUs (eDTU) Usage
  • Elastic Query Processing
  • Per Database Allocations
  • Cost Optimizations

Ch 45: Azure Storage Account

  • Azure Storage Account
  • Azure Data Lake Storage Account
  • Hierarchical Name Space (HNS)
  • Storage Containers
  • File Uploads

Ch 46: Azure SQL DB Migrations

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

Ch 47: Azure SQL DB Tuning – 1

  • Server Level Tuning
  • Database Level Tuning
  • Built-In Intelligence
  • Index Options
  • Index Hints

Ch 48: Azure SQL DB Tuning – 2

  • Using Azure AI
  • AI Search Service
  • AI Indexes, Practical Use
  • Watermark Columns
  • Index Refresh Options

Ch 49: Azure SQL DB Metrics

  • Azure SQL DB Metrics
  • CPU, Memory, Log Metrics
  • Data File Metrics, Alerts
  • Action Groups & Emails
  • Query Recommendations

Ch 50: Azure SQL DB Backups

  • Azure SQL DB Backups
  • Backup Retention Options
  • LTR Backups, Log Backups
  • Automated Backups
  • Backup Configurations
  • Backup History

Ch 51: Azure SQL DB Restores

  • Azure SQL DB Restores
  • LTR Restores
  • PITR Restores
  • Server Level Restores
  • Database Level Restores

Ch 52: HA DR @ Replication

  • Geo Replication
  • Primary & Secondary
  • Manual Failover
  • Automated Failover
  • DMVs For Replication
  • Testing Read Only Databases

Ch 53: HA DR @ Server Failover

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

Ch 54: Azure Security – 1

  • Azure SQL Server Security
  • Creating Logins & Users
  • Grant, With Grant
  • Database Roles & Security
  • Schema Level Security

Ch 55: Azure Security – 2

  • Row Level Security (RLS)
  • Predicate Function
  • Dynamic RLS
  • Security Functions
  • Dynamic Data Masking
  • Email and Phone Number Masking

Ch 56: Azure Security – 3

  • Azure AD Users
  • AD Principals
  • IAM Concepts
  • Implementing RBAC
  • MFA Authentication

Ch 57: Azure Virtual Machines

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

Ch 58: Azure VM Clusters

  • Azure Active Directory
  • Azure AD DS Services
  • Availability Groups, Usage
  • Listeners and Realtime Use
  • FSW: File Share Witness

Ch 59: SQL Server Clusters

  • Creating SQL Clusters
  • Cluster Nodes
  • Master Node
  • Cluster Components
  • Testing SQL Clusters

Ch 60: Always-On

  • Configure Always-On
  • Testing, Using Always-On
  • AOAG Implementation
  • AOAG Monitoring
  • Comparing Paas & IaaS

Ch 61: PowerShell

  • Azure PowerShell
  • Az and get Commands
  • Creating Resources
  • Password Resets
  • Firewall Config
  • Resource Cleanups

Ch 62: Azure Managed Instance

  • Azure MI Implementation
  • Cloud Azure MI Access
  • Azure MI Implementation
  • Azure MI Migrations
  • On-Premises Versus Azure

Ch 63: SQL DBA Exam

  • DP 300 Exam Guidance
  • Exam Prep. Guide
  • Exam Dumps
  • Exam Mocks

Module 4: Real-Time Project For Enterprise SQL Server DBA

Azure Cloud Migrations

  • Azure Cloud Management
  • Troubleshooting
  • Routine SQL DBA Activities
  • Maintenance DBA Activities
  • Performance Tuning
  • Azure Cloud (IaaS) Clusters
  • Always-On, HADR & Tuning

BONUS Module: Career Guidance

  • 1:1 Profile Discussion
  • Resume Guidance
  • Resume Optimization
  • Mock Interviews
  • Placement Assistance

What is the SQL DBA with Azure Training?

This course teaches complete SQL Database Administration including SQL Server Concepts, Core DBA, Azure SQL DBA, CoPilot integrations, High Availability, Disaster Recovery, Tuning, Migrations, and Real-Time Projects.

Who can join this SQL DBA course?

Anyone — freshers, non-IT learners, support engineers, developers, or professionals wanting to switch into Database Administration. The course starts from basics and requires no prior experience.

What is the duration of the course?

The duration is 2 months, including 2 real-time projects, daily assignments, and DP-300 exam guidance.

What modules are included in this SQL DBA Program?

Module 1: Database & SQL Server Concepts
Module 2: Core SQL DBA
Module 3: Azure SQL DBA + CoPilot
Module 4: DP-300 + Resume Preparation

What system requirements are needed for SQL DBA practice?

Windows OS, 6GB RAM, any processor. Installation, configuration, and lab setup are fully guided by the trainer.

What SQL basics are taught in the DBA course?

Database creation, tables, DDL/DML/DQL, imports, schemas, constraints, joins, views, stored procedures, functions, transactions, CTEs, and linked servers.

Will I learn SQL Server Architecture?

Yes. Database engine components, parser, compiler, optimizer, SQL OS, memory manager, I/O manager, protocols, and query processing internals.

Does the course cover Backup and Restore in detail?

Yes. Full, differential, file/filegroup backups, copy-only backups, mirror backups, validations, PITR restores, standby restores, MOVE options, and restore states.

Will I learn SQL Server Agent Jobs and Maintenance Plans?

Yes. Agent configuration, job scheduling, history tracking, maintenance plans, backup jobs, error handling, and alerts.

Are Security & User Management included?

Yes. Logins, users, roles, schema-level security, object-level permissions, encryption, certificates, and auditing logon failures.

Is database migration included?

Yes. Detach/attach, backup-restore migrations, SSIS-based migrations, SMO migrations, CDW packages, fixing orphan users, and migration scheduling.

Does the training cover Performance Tuning?

Yes. Activity Monitor, PerfMon counters, DMVs/DMFs, indexing, statistics, partitions, query store, buffers, execution time, long-running query analysis, and tuning tools.

Will I learn Locking, Isolation Levels & Deadlocks?

Yes. Lock types (S, X, IX, U), blocking, deadlock graphs, events, prevention techniques, read committed snapshot, hints, sp_who2, sysprocesses, and real-time lock monitoring.

Do you teach High Availability & Disaster Recovery (HA/DR)?

Yes. Replication (Snapshot, Transactional, Merge, Peer-to-Peer), Log Shipping, Database Mirroring, Failover processes, Alerts, and Monitoring.

Is troubleshooting and repair part of the syllabus?

Yes. DBCC audits, suspect pages, emergency mode, single-user mode, slow DB fixes, tempdb issues, memory issues, and common DBA problems.

Do you teach Patching & Upgrades?

Yes. Patch planning, edition checks, rollback methods, in-place upgrades, maintenance steps, and version comparisons.

Is Azure SQL DBA included?

Yes. Cloud fundamentals, Azure SQL deployments, firewalls, connections, licensing models (DTU vs VCore), metrics, alerts, tuning, automated indexing, backups, PITR restores, Geo Replication, Failover Groups, RBAC, RLS, and Data Masking.

Does the course cover Azure VM & Clusters?

Yes. Azure VM deployment, security, networking, clustering, Always-On setup, AG monitoring, listeners, and comparing IaaS vs PaaS.

Will I learn PowerShell for SQL DBA?

Yes. Az commands, creating resources, validations, password resets, firewall rules, cleanup operations, and administrative automation.

What training modes are available?

Live Online Training, Self-Paced Videos, Real-Time Projects, Resume Preparation, Mock Interviews, and DP-300 Exam Guidance.

Why SQL SCHOOL?

Training Modes

LIVE Online Training Image
Self Paced Videos
Register Now
Students Reviews

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

Verified by MonsterInsights