Curated by industry experts, this comprehensive SQL DBA course equips learners with essential skills in SQL Server management, database installation, performance tuning, and advanced HA/DR solutions, preparing them for real-world database challenges.

Basic knowledge of SQL and any programming language is beneficial for the SQL DBA Course.

DBA Roadmap and Career Path

Module 1: Overview of SQL Server

• What is Data | Information | RDMS
• History of MS SQL Server
• Versions & Editions of SQL Server
• Hardware & Software and Requirements

Module 2: Installation and Configuring SQL Server

• Installation of SQL Server
• Verify installation and folders and services
• Configuring data and Transaction log files
• Configuring default Backup folder
• Configuring Temp DB and Min & Max Memory
• Configuring Error Logs
• SSMS Tool Installation, Connections
• SQL Server Management Studio

Module 3: Working with Databases

• Introduction of databases
• System Defined databases
• Data Files
• Log Files
• Filegroups
• SQL and T-SQL : Basic Differences
• DDL, DML, SELECT Statements
• Creating Tables and Data Storage
• Data Inserts and SELECT Statement
• WHERE Conditions and Keywords
• IN Operator and NOT IN Operator
• Between, Not Between Operators
• LIKE and NOT LIKE Operators
• UPDATE Statement & Conditions
• DELETE & TRUNCATE Statements
• Logged and Non-Logged Operations
• Table Structure Modifications
• ADD, ALTER and DROP Columns

Module 4: Constraints, Index Basics

• Constraints and Keys – Data Integrity
• NULL, NOT NULL Property on Tables
• UNIQUE KEY Constraints: Importance
• PRIMARY KEY Constraint: Importance
• FOREIGN KEY Constraint: Importance
• REFERENCES, CHECK and DEFAULT
• Candidate Keys and Identity Property
• Indexes: Basic Types and Creation
• Index Sort Options, Search Advantages
• Clustered and Non-Clustered Indexes
• Primary Key and Unique Key Indexes
• Need for Indexes – Working with Keys

Module 5: Backup and Restore

• Backup:
  • Recovery Models
  • Full
  • Bulk Logged
  • Simple
  • Summary of Recovery Models
• Backup Types:
  • Full
  • Differential
  • Transaction Log
  • Copy-only, Mirrored, and Split Backups
• Restore:
  • Restore from Full, Diff, T Log Backups
  • RECOVERY, NORECOVERY Options
  • VERIFYONLY: Backup Verification
  • Tail Log Backup and Restore
  • Common Errors and Solutions

Module 6: Implementing Security

• Setting Authentication Mode
• Understanding of Login and User
• Understanding Server Roles
• Working with Users
• Resolving Orphan Users
• Understanding Server Level Roles and Database Level Roles
• Implementing Object and Column Level Security

Module 7: Jobs and Maintenance Plans

• SQL Server Agent Service & Agent XPs
• SQL Agent Jobs – GUI, Script Creations
• Job Steps – Creation, Edits, and Parse
• Job Executions, Disable/Enable Options
• Job History Purge and Job Activity Monitor
• Database Maintenance – Backup Jobs
• Scheduling Database Maintenance Plans
• Mail Architecture
• Step-by-Step Configuration
• Sending Test Mail
• Implementing Automation
• Creating Operators
• Creating Alerts
• Performance Condition Alerts

Module 8: Performance Tuning

• Troubleshooting High CPU, Memory & IO
• Wait Types in SQL Server and Identifying Waiting Tasks
• Index Tuning
• Monitoring Using Profiler and Extended Events
• Dynamic Management Views
• SQL Server and Windows Error Logs
• Locks & Deadlocks
• Transaction Isolation Levels
• Understanding Blocking
• Understanding Index Fragmentation
• Understanding Statistics
• Using DBCC Commands
• Trace Flags
• Execution Plan Analysis and Internals

Module 9: HA-DR: Working with Log Shipping

• Architecture
• Prerequisites for Log Shipping
• Configuring Log Shipping through GUI and T-SQL
• Configuring Standby Mode
• Monitoring Log Shipping
• Manually Performing Failover
• Log Shipping Scenarios Discussion

Module 10: HA-DR: Replication

• Architecture
• Prerequisites for Replication
• Replication Agents
• Types of Replications
  • Snapshot Replication
  • Transactional Replication
  • Merge Replication
  • Peer-to-Peer Replication
• Monitoring Replication

Module 11: HA-DR: Clustering and Always On

• Overview of Clustering
• Prerequisites for Clustering
• Installing SQL Server Failover Cluster Instances [FCI]
• Active and Active Cluster
• Overview of Always On
• Prerequisites for Always On
• Adding Replicas on Availability Groups
• Troubleshooting Always On Issues
• Patching Always On Instances
• Configure AG Listener

Module 12: Cloud Computing Fundamentals

• Introduction to Cloud Computing
• Defining Cloud Computing
• Key Characteristics of Cloud Computing
• Cloud Computing and Virtualization
• Understanding Virtualization in the Cloud
• Benefits of Virtualization
• Cloud Computing Deployment Models
  • Public Cloud
  • Private Cloud
  • Hybrid Cloud
• Choosing the Right Deployment Model
• Cloud Computing Delivery Models
  • Infrastructure as a Service (IaaS)
  • Platform as a Service (PaaS)
  • Software as a Service (SaaS)

Module 13: Azure SQL: Connectivity, Deployment, Security, and the Latest Cloud Innovations

• Master Azure SQL Connectivity and Deployment:
  • Deploy Azure SQL VMs with ARM Templates
  • Configure Prerequisites for Azure SQL Database Creation
  • Deploy Azure SQL Databases
  • Register and Validate Connectivity in Azure Data Studio
• Explore Firewalls & Authentication:
  • Configure Firewall Rules for Azure SQL Connectivity
  • Understand Azure SQL Database vs. Azure SQL Server Distinctions