Skip to main content

#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..

✅ 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
✅ End-to-End Real-Time DBA Project
✅ 1:1 Mentorship, Interview Guidance

SQL DBA Training With Azure, AI Contents:

Module 1 : Core SQL DBA

Ch 1: Database Intro & Job Roles

  • Database Introduction
  • Database Types: OLTP, DWH
  • DBMS & Realtime Us
  • DBMS Software & Purpose
  • SQL: Purpose & Use
  • SQL Server Versions, Editions
  • SQL DBA Job Roles

Ch 2: SQL Server Installations

  • SQL Server 2022 Installations
  • SQL Server 2019 Installations
  • SSMS Tool Installation
  • Server Connections, Properties
  • Instance & Instance Types
  • Authentication Types
  • System Databases & Purpose

Ch 3: SQL Basics V1 (Commands)

  • Database, Tables & Columns
  • SQL Basics: Purpose
  • DDL Statements
  • DML Statements
  • DQL Statements
  • Verifications @ GUI
  • Basic SELECT Queries

Ch 4: SQL Basics V2 (Operators)

  • DDL Variants in MSSQL
  • DML Variants in MSSQL
  • INSERT & INSERT INTO
  • SELECT & SELECT INTO
  • Basic Operators in SQL
  • Special Operators in MSSQL
  • ALTER, ADD, TRUNCATE, DROP

Ch 5: Excel Data Imports

  • Data Imports with Excel
  • SQL Native Client
  • Order By: Asc, Desc
  • Order By with WHERE
  • TOP & OFFSET
  • UNION ALL
  • UNION, Data Appends

Ch 6 : Schemas & Security

  • Schemas: Creation, Usage
  • Schemas & Table Grouping
  • Using Default Schema
  • Real-world Banking Database
  • Table Migrations @ Schemas
  • 2 Part, 3 Part & 4 Part Naming
  • Verifying Schemas in UI

Ch 7: Constraints & Keys Basics

  • Need for Constraints, Keys
  • Null, Not Null Constraints
  • Unique Key Constraint
  • Primary Key Constraint
  • Foreign Key & References
  • Default Constraint & Usage
  • DB Diagrams & ER Models

Ch 8: Indexes Basics, Tuning

  • Indexes & Tuning
  • Clustered Index, Primary Key
  • Non Clustered Index & Unique
  • Creating Indexes Manually
  • Verifying Indexes
  • Composite Keys, Query Optimizer
  • Composite Indexes & Usage

Ch 9: Joins & Audits

  • Joins: Table Comaparisons
  • Inner Joins & Matching Data
  • Outer Joins: LEFT, RIGHT
  • Full Outer Joins & Audits
  • Cross Join & Table Combination
  • Joining more than 2 tables
  • Joining Tables with Aliases

Ch 10: Views & RLS

  • Views: Realtime Usage
  • Storing SELECT in Views
  • DML, SELECT with Views
  • RLS: Row Level Security
  • WITH CHECK OPTION
  • Database Audits & Metadata
  • Important System Views

Ch 11: Stored Procedures

  • Stored Procedures: Realtime Use
  • Parameters Concept with SPs
  • Procedures with SELECT
  • System Stored Procedures
  • Metadata Access with SPs
  • SP Recompilations
  • Stored Procedures, Tuning

Ch 12 : User Defined Functions

  • Using Functions in MSSQL
  • Scalar Value Functions
  • Inline & Multiline Functions
  • Parameterized Queries
  • Date & Time Functions
  • String Functions & Queries
  • Aggregated Functions & Usage

Ch 13: Triggers & Automations

  • Need for Triggers
  • DDL & DML Triggers
  • For / After Triggers
  • Instead Of Triggers
  • Memory Tables with Triggers
  • Data Replication, Automation
  • Disabling DMLs & Triggers

Ch 14: Transactions & ACID

  • Transaction Concepts in OLTP
  • Transaction Types in Realtime
  • Auto Commit, Explicit Transaction
  • COMMIT, ROLLBACK
  • Checkpoint & Logging
  • Lock Hints & Query Blocking
  • READPAST, LOCKHINT

Ch 15: Cursors & Fetch

  • Cursors: Realtime Usage
  • Cursor Declaration Types
  • Open Cursor, Close Cursor
  • Local & Global Cursors
  • Scroll & Forward Only Cursors
  • Static & Dynamic Cursors
  • Fetch, Absolute Cursors

Ch 16: CTEs & Tuning

  • Common Table Expression
  • Creating and Using CTEs
  • CTEs, In-Memory Processing
  • Using CTEs for DML Operations
  • Using CTEs for Data Retrieval
  • Using CTEs for Tuning
  • CTEs: Duplicate Row Deletion

Ch 17: DB Architecture, Locks

  • Planning VLDBs : Files, Sizing
  • Filegroups, Extents & Types
  • Log Files : VLF, Mini LSN
  •  Table Location
  • Performance Advantages
  • Transactions Types, Lock Hint
  •  Query Blocking Scenarios

Ch 18: Server Architecture

  • Protocols: TCP IP, Named Pipes
  • Database Engine Components
  • Storage Engine Components
  • SQL OS Components
  • Checkpoints, WAL
  • Processor, Memory & IO
  • MDAC, Client Components

Ch 19: Backups

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

Ch 20: 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 21: Jobs, Maintenance

  • SQL Server Agent Service
  • Job Steps & Schedules
  • MSDB: Job History
  • DB Maintenance Plans
  • Backup Maintenance
  • Job Verifications, Scripts
  • Common Errors, Solutions

Ch 22: Database Mail

  • SMTP Concepts
  • Creating Email Profile
  • Default, Public Profiles
  • Creating SMTP Accounts
  • Alert System : Agent Settings
  • Creating Operators
  • Job Failures & Notifications

Ch 23: Security Management

  • Security Objects Usage
  • Creating Logins & Users
  • Creating Roles, Add Principals
  • Schema Level Security
  • Object, Column Level Security
  • Security Management Scripts
  • Security Audit, Logon Failures

Ch 24: DB Migrations

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

Ch 25: Linked Servers, Recovery

  • Multi Server Installations
  • Configure Instances
  • Create & Test Linked Server
  • RPC & RPC OUT
  • Recovery Models
  • Full, Simple, Bulk Logged
  • Recommended Models For OLTP

Ch 26: Tuning: Audits, AM Tool

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

Ch 27: 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 28: Tuning: Partitions

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

Ch 29: Tuning: Statistics, Updates

  • Statistics: Realtime Use
  • Automated Statistics
  • Index Level Statistics
  • Column Level Statistics
  • Conditional Statistics
  • Manual Stats Update
  • Indexes Versus Statistics

Ch 30: Tuning: Index Management

  • Index Management Options
  • Index Rebuilds, Re-Organize
  • Database Maintenance Plans
  • Page Count and Index Conditions
  • Degree Of Parallelism Settings
  • Resumable & Online Indexes
  • PAUSE, RESUME in Rebuilds

Ch 31: Tuning Tools

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

Ch 32: Tuning: Execution Plans

  • Execution Plan Analysis
  • IO Cost and CPU Cost
  • SubTree & Operator Cost
  • NUMA Nodes, CPU Affinity
  • Thread Count, DOP
  • Table & Index Scan, Index Seek
  • Index Selectivity & Tuning

Ch 33: 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 34: 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 35: 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 36: DB Health Checks, Repairs

  • DBCC Commands in Realtime
  • DBCC for Audits, Repairs
  • MSDB Suspect Pages
  • User Database Repairs
  • Log Space Issues, Solutions
  • TempDB Issues, Solutions
  • Memory Issues, Solutions

Ch 37: HA DR @ Replication – 1

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

Ch 38: 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 39: HA DR @ Log Shipping

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

Ch 40: HA DR @ DB Mirroring

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

Ch 41: Updates (Patches)

  • Planning for Updates
  • Pre-Maintenance Checklist
  • Edition Checks
  • Updates Process
  • Edition Comparisons
  • History Tracking
  • Updates Rollback

Ch 42: Upgrades, Licensing

  • Planning for Upgrades
  • Pre-Maintenance Checklist
  • Upgrades Process (In-Place)
  • Cautions & Maintenance
  • Version Comparisons
  • History Tracking
  • Upgrades Rollbacks

Ch 43: 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 44: SQL DBA Project

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

Module 2: Azure SQL DBA

Ch 45: 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 46: 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 47: 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
  • Linking SSMS with Azure

Ch 48: 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 49: 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

50: Azure SQL DB Tuning, AI

  • Automated Tuning Options
  • Manual Tuning Options
  • Server Level Tuning
  • Database Level Tuning
  • Create Index Option
  • Drop Index, Seek Options
  • Built-In Intelligence

Ch 51: Azure AI Search

  • AI Search Service, Tuning
  • AI Indexes, Practical Use
  • Watermark Columns
  • Triggers & Timestamp
  • Filterable, Searchable
  • Sortable, Facetable
  • Indexer & Data Refresh

Ch 52: Azure Backups, Restores

  • Azure Backups & Restores
  • Automated Backups
  • Backup Retention Options
  • LTR, PITR & Differential
  • Backup Audits from Portal
  • Restores from SQL Server
  • Restores from Azure Portal

Ch 53: HA DR @ Replication

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

Ch 54: HA DR @ Server Failover

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

Ch 55: HA DR @ DB Sync

  • Data Sync Concept
  • Hub, Member
  • Sync Database Config
  • Sync Agent Installation
  • Registering Sync Servers
  • Azure HA DR Mechanism
  • Data Sync with Hub, Agent

Ch 56: Azure Security – 1

  • Azure SQL DB Security
  • Logins & Users in master
  • Logins & Users in SQL DB
  • Grant, With Grant
  • Deny & Revoke
  • Role Based Security
  • Role & Schema Security

Ch 57: Azure Security – 2

  • RLS & Users without Logins
  • Dynamic RLS
  • Dynamic Data Masking
  • Creating AD Users & IAM
  • Implementing RBAC
  • Azure SQL Admin
  • MFA Authentication

Ch 58: Azure VM

  • Azure IaaS Implementation
  • Configure Disk, Network
  • Configure SQL Security
  • CPU, Processor & IO
  • IP & RDP Connections
  • Testing SSMS Connections
  • Migrating SQL DB to VM

Ch 59: Azure Clusters

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

Ch 60: SQL Clusters, Always-On

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

Ch 61: PowerShell

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

Ch 62: Azure Managed Instance 1

  • Azure MI Implementation
  • Choosing Region: Cautions
  • Network Entities for MI
  • Capacity Entities
  • Processor & Memory
  • Cloud Azure MI Access
  • On-Premises MI Access

Ch 63: Azure Managed Instance 2

  • Azure MI Implementation
  • Azure MI : SQL Server
  • Azure MI : SQL DB Access
  • Azure MI : Migrations
  • Azure MI : DBA Concepts
  • Azure MI : Backups, Restores
  • Azure MI : HA DR, Security

Ch 64: : DP 300 Exam Guidance 1

Ch 65: : DP 300 Exam Guidance 2

Ch 66: : SQL DBA Project & Resume

SQL SCHOOL

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

SQL DBA Training FAQ's

What is SQL DBA Job Role?

A Snowflake BI  leverages Snowflake’s cloud data platform to build scalable, secure, and high-performance data models for business intelligence and reporting.

🔑 Key Responsibilities:

  • Design and optimize data models in Snowflake

  • Integrate Snowflake with BI tools like Power BI, Tableau, or Looker

  • Write and manage SQL queries for data analysis

  • Develop ETL/ELT pipelines for data transformation

  • Ensure data quality, security, and performance

  • Collaborate with analysts and business teams

  • Automate reports and dashboards for insights

  • Monitor warehouse usage and cost optimization

What are the Job Roles of an SQL DBA ?

💼 Top Job Roles:

  1. BI Developer – Build reports and dashboards using data from Snowflake

  2. Data Analyst – Analyze and interpret Snowflake data for business insights

  3. Data Engineer – Design and maintain Snowflake-based data pipelines

  4. ETL Developer – Load, transform, and manage data within Snowflake

  5. Data Modeler – Create optimized data models in Snowflake

  6. SQL Developer – Write complex queries and procedures in Snowflake SQL

  7. Reporting Analyst – Deliver KPIs and visualizations using BI tools

  8. Cloud Data Specialist – Manage Snowflake performance, scaling, and storage

  9. Data Quality Analyst – Ensure accuracy and consistency of Snowflake datasets

  10. Analytics Consultant – Provide strategic insights using Snowflake and BI platforms and more..!

What does our SQL DBA Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: MSSQL & TSQL Queries
👉🏻Module 2: Snowflake
👉🏻Module 3: Power BI

Who can join this course?

  • Freshers looking to start a career in data or analytics

  • Working professionals wanting to shift to Python, Data Science, or ETL roles

  • Students from any background interested in tech and data

  • IT and Non-IT professionals aiming to upskill

  • Anyone with basic computer knowledge and a passion for learning

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1:        LIVE Online Training  (100% Interactive, step by step, assignments)

Option 2:        Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for SQL DBA training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice.  Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

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
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance