SQL Server Database Administration

This course turns a careful beginner into someone who can safely take responsibility for a small SQL Server instance. You work with **SQL Server 2022 Developer Edition**, connect with **SQL Server Management Studio (SSMS)**, and practise on Microsoft's **AdventureWorks2022** sample database on a Windows Server 2022 lab machine called `win01`. You start with what a database administrator actually does and how the engine is put together — editions, the instance, system databases, data and log files, and the services that run it. From there you install and connect, restore a real database and read its internals, and work through the daily craft of the role: logins and least privilege, backup and restore with a proven point-in-time recovery, integrity checks and index maintenance, monitoring with wait statistics and dynamic management views, and calm troubleshooting of blocking, deadlocks, full transaction logs, and failed jobs. You finish by automating routine work with T-SQL and PowerShell and by surveying the high-availability and disaster-recovery options so you can say what to choose when. Every T-SQL statement in the course was executed against SQL Server 2022 and the output you see is real. SSMS and Windows dialog steps are written out precisely with a screenshot placeholder, so the concepts and queries stand on their own even before the hosted lab is available. The course ends with a project: take over a neglected instance, assess it, secure it, back it up, schedule its maintenance, prove a restore, and write the runbook.