"The structure, the practice exams, the instructor — all top tier. Passed first try."
Course Outline
What the programme covers, module by module.
Module 1: Introduction to SQL Server Administration
- SQL Server overview
- Database administration responsibilities
- SQL Server ecosystem
- Database environments
- Administration lifecycle
- Common administrative tasks
Module 2: SQL Server Architecture
- Database engine
- SQL Server instances
- System databases
- Database files
- Memory architecture
- SQL Server services
Module 3: Installing SQL Server
- Installation planning
- Hardware considerations
- Software requirements
- SQL Server setup
- Feature selection
- Installation validation
Module 4: SQL Server Configuration
- Instance configuration
- Server properties
- Database settings
- Service configuration
- Network configuration
- Configuration best practices
Module 5: SQL Server Management Studio
- SSMS environment
- Object Explorer
- Query Editor
- Server properties
- Activity monitoring
- Administrative workflows
Module 6: Creating & Managing Databases
- Database creation
- Database properties
- Data files
- Log files
- Filegroups
- Database modification
Module 7: Database Storage Management
- Pages and extents
- Data storage
- File growth
- Autogrowth
- Storage allocation
- Capacity planning
Module 8: SQL Server Security Fundamentals
- Authentication
- Windows authentication
- SQL Server authentication
- Logins
- Users
- Security principles
Module 9: Roles & Permissions
- Server roles
- Database roles
- Object permissions
- GRANT
- DENY
- REVOKE
Module 10: Backup Fundamentals
- Backup strategies
- Full backups
- Differential backups
- Transaction log backups
- Backup destinations
- Backup verification
Module 11: Database Restore & Recovery
- Restore concepts
- Full database restore
- Differential restore
- Transaction log restore
- Recovery options
- Recovery validation
Module 12: Recovery Models
- Simple recovery
- Full recovery
- Bulk-logged recovery
- Transaction logs
- Recovery objectives
- Recovery model selection
Module 13: Database Integrity Management
- Database consistency
- DBCC CHECKDB
- Integrity checks
- Corruption concepts
- Maintenance strategies
- Integrity monitoring
Module 14: Index Administration
- Index fundamentals
- Clustered indexes
- Non-clustered indexes
- Index fragmentation
- Rebuilding indexes
- Reorganizing indexes
Module 15: Statistics & Query Performance
- SQL Server statistics
- Query optimizer
- Execution plans
- Statistics updates
- Slow queries
- Performance fundamentals
Module 16: SQL Server Monitoring
- Activity Monitor
- Dynamic Management Views
- Sessions
- Connections
- Resource utilization
- Performance monitoring
Module 17: SQL Server Agent
- SQL Server Agent
- Jobs
- Job steps
- Schedules
- Job history
- Automated administration
Module 18: Maintenance Plans
- Maintenance planning
- Backup automation
- Integrity checks
- Index maintenance
- Statistics maintenance
- Maintenance scheduling
Module 19: Transactions, Locking & Blocking
- Transactions
- Locks
- Blocking
- Isolation levels
- Long-running transactions
- Blocking analysis
Module 20: High Availability & Disaster Recovery
- Availability concepts
- Failover concepts
- Log shipping
- Database mirroring concepts
- Always On availability concepts
- Disaster recovery planning
Module 21: SQL Server Troubleshooting
- Service failures
- Connectivity problems
- Authentication issues
- Database availability
- Storage problems
- Performance troubleshooting
Module 22: SQL Server Administration Workshop
- Instance configuration
- Database creation
- User and permission management
- Backup and recovery
- Maintenance configuration
- Monitoring and troubleshooting
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device
Course Overview
The Microsoft SQL Server Administration program equips working professionals with practical skills to manage reliable SQL Server environments. Participants learn installation, database architecture, storage, security, backup and recovery, permissions, indexing, monitoring, automation, high availability, performance management, troubleshooting, and routine database maintenance.