Complete SQL Server 2025 Administration Masterclass

Name: Complete SQL Server 2025 Administration Masterclass
Rating: 4.5 (2 reviews)

SQL Server 2025 Database Administration Essential Training

Created byEmar Morrison

Last updated 10/2026

English

What you'll learn

Individuals seeking to build a strong foundation in SQL Server 2025 administration and progress into a DBA role.
Existing DBAs who want to update their skills to align with the latest SQL Server
IT professionals responsible for server, storage, or cloud infrastructure who manage or support SQL Server environments.
Professionals supporting SQL Server–backed applications who need to troubleshoot performance, availability, and data issues.
Software developers with SQL experience who want to expand into database administration and operations.

Course content

12 sections • 57 lectures • 5h 33m total length

SQL Server Editions1:28
Deploy SQL Server 20255:59
SQL Server Configuration Manager2:54
Installing Management Studio 222:31
Installing SQL Server Management Studio 180:56
Configuring SQL Server Instance for performace8:59

Reviewing SQL Server Logs2:58
Understanding how Dynamic Management Views Works3:31
Database Console Command for SQL Server2:20
The following DBCC commands operate on an internal read-only database snapshot that the Database Engine creates. The snapshot prevents blocking and concurrency problems when these commands are executed. For more information, see Database Snapshots (SQL Server).
DBCC CHECKALLOC
DBCC CHECKCATALOG
DBCC CHECKDB
DBCC CHECKFILEGROUP
DBCC CHECKTABLE
When you execute one of these DBCC commands, the Database Engine creates a database snapshot and brings it to a transactionally consistent state. The DBCC command then runs the checks against this snapshot. After the DBCC command is completed, this snapshot is dropped.
Monitoring Process SQL Server Activity Monitor2:27
Performance Tuning with Indexes19:26
Performance Monitoring with Query Store8:05
Monitoring and Tracing with Extended Events6:56
This lecture introduces SQL Server Extended Events, a lightweight and powerful framework for monitoring, troubleshooting, and analyzing SQL Server activity. Students will learn how to create and configure Extended Event sessions, capture events such as errors, deadlocks, long-running queries, and performance issues, and analyze the collected data to identify and resolve SQL Server problems.
Managing Resources with the Resource Governor.8:07
SolarWinds Database Performance Analyzer8:32

Requirements

SQL Server Database Administration

Description

This course contains the use of artificial intelligence.

Welcome to the SQL Server 2025 course!

I’m excited to have you join us as we explore the world of Microsoft SQL Server administration, security, performance, backup, recovery, high availability, and modern AI capabilities.

Throughout this course, you will gain practical, hands-on experience working with SQL Server 2025 and develop the skills needed to manage and support modern production database environments.

We will cover topics including:

SQL Server architecture and database administration
Database backup and recovery strategies
Security and encryption
Performance monitoring and optimization
Indexing and database maintenance
Extended Events
High availability and disaster recovery
Database mirroring and other availability technologies
Partitioning and data management
Practical DBA troubleshooting and administration
Introduction to SQL Server AI features and AI-assisted database capabilities

A key part of this course will be our introduction to AI in SQL Server. We will explore how AI can complement traditional DBA skills and support the way we work with data.

My goal is not only for you to understand the concepts, but also to apply them in real-world SQL Server environments.

Come prepared to learn, practice, ask questions, troubleshoot problems, and explore how SQL Server 2025 and AI are shaping the future of database administration.

Welcome to the course, and let’s get started!

Who this course is for:

Basic understanding of: Relational database concepts & SQL fundamentals
Prior SQL Server experience is helpful but not required
Familiarity with: Windows Server environments & Basic networking concepts

Complete SQL Server 2025 Administration Masterclass

What you'll learn

Explore related topics

Course content

Plan and deploy SQL Server solutions6 lectures • 23min

Database Creation & Configuration6 lectures • 28min

Configure database authentication and authorization8 lectures • 43min

Business Data Protection and Recovery7 lectures • 39min

Implement security for data at rest and data in transit3 lectures • 28min

Automation with SQL Server Agent4 lectures • 19min

Performance Tuning & Monitoring9 lectures • 1hr 2min

Migrate and Load Data3 lectures • 8min

Business Continuity4 lectures • 33min

Leveraging AI in SQL Server 2025: Intelligent Data Processing and Generative AI5 lectures • 26min

Requirements

Description

Who this course is for: