← All courses
SQL Server Administration
A complete, hands-on SQL Server Administration course: setup, backups & restores, indexes, statistics, memory, security, monitoring, agent jobs, and running SQL Server on VMware, AWS, plus licensing.
Sign in to start this course.
Sign in
Hands-on SQL Server DBA training by Mike Bennyhoff. Build a lab from scratch, then work through backups and restores, disaster recovery, index and statistics maintenance, memory and parallelism tuning, user administration, performance monitoring, SQL Agent, and deploying SQL Server on VMware and AWS - finishing with licensing. Includes T-SQL scripts and guided examples.
Introduction
-
○
Intro To SQL Server
Video
-
○
Quick Walk-Around
Video
-
○
Intro Project
Video
-
○
Knowledge Check
Quiz
Setting Up
-
○
Install VMware
Video
-
○
Configure VM (Windows)
Video
-
○
Install SQL Server 2022
Video
-
○
Connection Manager
Video
-
○
Sample Database
Video
Backups
-
○
Backups
Video
-
○
Backup Logs
Video
-
○
Guided Example - Full Backups
Video
-
○
Backup Review
Video
Restores
-
○
Restore - Part 1
Video
-
○
Restore - Part 2
Video
Indexes
-
○
Index Overview
Video
-
○
Types of Indexes
Video
-
○
Index Fragmentation
Video
-
○
Index Management
Video
-
○
Index Review
Video
-
○
Guided Example
Video
Statistics
-
○
Statistics Overview
Video
-
○
Test DB Statistics
Video
-
○
Statistics Query
Video
-
○
Statistics Review
Video
Memory (RAM)
-
○
SQL Server Memory
Video
-
○
Knowledge Check
Quiz
User Administration
-
○
Users, SA & DBO
Video
-
○
User Admin Review
Video
Performance Dashboard
-
○
Performance Dashboard
Video
SQL Mail & Alerts
-
○
Database Mail, Operators & Alerts
Video
SQL Agent
-
○
SQL Agent - Part 1
Video
-
○
SQL Agent - Part 2
Video
SQL on VMware
-
○
SQL Server on VMware
Video
-
○
VM Configuration
Video
SQL on AWS
-
○
SQL Server on AWS
Video
-
○
AWS Deep Dive
Video
Licensing
-
○
Licensing Overview
Video
-
○
SQL Server Licensing
Video