Intermediate

SQL Server Administration

Learn everything you need to install, configure, secure, and maintain SQL Server instances in production. This comprehensive DBA course covers backups, monitoring, jobs, and high availability.

🕒 12 Hours 📜 64 Lessons ★ 4.9/5 (1,520 reviews) 🎓 Certificate

$49

One-time payment • Lifetime access

12 hours of in-depth content
64 practical lessons
DBA scripts and checklists
Maintenance plan templates
Certificate of completion
Community forum access

Enroll Now

30-day money-back guarantee

What You Will Learn

Install and configure SQL Server for production use
Design and implement backup and restore strategies
Manage SQL Server security and permissions
Automate tasks with SQL Server Agent jobs
Monitor server health and resource usage

Implement database maintenance plans
Configure database mail and alerts
Set up log shipping and replication
Understand Always On Availability Groups
Troubleshoot common DBA issues

Course Curriculum

Module 1: Installation & Configuration 8 lessons

Planning your SQL Server installation
Edition comparison and licensing
Step-by-step installation walkthrough
Post-installation configuration checklist
Configuring memory, CPU, and tempdb
Instance vs database settings
SQL Server on Linux basics
Lab: Setting up a production-ready instance

Module 2: Backup & Recovery 10 lessons

Recovery models explained (Full, Simple, Bulk-Logged)
Full, differential, and log backups
Backup compression and encryption
Restore scenarios and point-in-time recovery
Backup to URL (Azure Blob Storage)
Automating backups with maintenance plans
Backup verification and DBCC CHECKDB
Disaster recovery planning
Backup retention and cleanup
Lab: Complete backup and restore drill

Module 3: Security Management 8 lessons

Authentication modes (Windows vs Mixed)
Logins, users, and schemas
Server and database roles
GRANT, DENY, REVOKE permissions
Contained databases
Transparent data encryption (TDE)
SQL Server Audit
Lab: Implementing a security model

Module 4: Automation & SQL Agent 8 lessons

SQL Server Agent overview
Creating and scheduling jobs
Job steps, notifications, and alerts
Database Mail configuration
Maintenance plans with the wizard
Custom maintenance with T-SQL
Monitoring job history and failures
Lab: Automating daily DBA tasks

Module 5: Monitoring & Troubleshooting 8 lessons

Dynamic management views (DMVs) for DBAs
Activity Monitor and built-in reports
Tracking blocking and deadlocks
Reading the SQL Server error log
Performance Dashboard reports
Extended Events for monitoring
Common DBA troubleshooting scenarios
Lab: Diagnosing a slow server

Module 6: High Availability 6 lessons

High availability options overview
Log shipping setup and failover
Transactional replication basics
Always On Availability Groups concepts
Failover clustering fundamentals
Final project: Production-ready DBA playbook

SQL Server Administration

What You Will Learn

Course Curriculum

Become a Confident SQL Server DBA