10. Security & Administration

Overview

This module covers the operational aspects of managing a SQL Server instance.

Topics Covered

• Authentication & Authorization: Logins, Database Users, and Roles.
• Permissions: Using GRANT, REVOKE, and DENY.
• Backup & Restore: Recovery models and fundamental maintenance tasks.
• Maintenance Plans: Automating index rebuilding and integrity checks.