SQL Server Administration
The day-to-day work of a DBA: install and configure SQL Server, secure it, back it up and restore it, tune indexes and queries, and automate jobs.
1 lesson available now
Module 1 · Getting started
📖
Welcome to the course
Free preview
▶️
The DBA role and SQL Server architecture
Coming soon
Module 2 · Installation and configuration
🧪
Installing SQL Server
Coming soon
▶️
Instance and database settings
Coming soon
Module 3 · Security
▶️
Logins, users and roles
Coming soon
🧪
Lab: least-privilege access
Coming soon
Module 4 · Backup and restore
▶️
Recovery models
Coming soon
▶️
Backup strategies
Coming soon
🧪
Lab: restore to a point in time
Coming soon
✅
Check your understanding
Coming soon
Module 5 · Indexing and performance
▶️
How indexes work
Coming soon
🧪
Reading execution plans
Coming soon
🧪
Finding slow queries
Coming soon
Module 6 · Automation and monitoring
🧪
SQL Server Agent jobs and alerts
Coming soon
▶️
Maintenance plans
Coming soon
Module 7 · High availability
▶️
Log shipping and Always On overview
Coming soon