DatabaseAdvancedSQL Server Database Administration
5 Days (40 Hours)Face to Face / Online
Keep mission-critical SQL Server environments running at peak performance. Develop expertise in installation, configuration, backup and recovery, security hardening, performance monitoring, and proactive maintenance planning.
| Duration | 5 Days (40 Hours) |
|---|---|
| Level | Advanced |
| Category | Database |
| Training Method | Face to Face / Online |
Course Outline
- Installation and configuration best practices
- Security hardening and permissions
- Backup and recovery strategies
- Performance monitoring and tuning
- Index and maintenance planning
- High availability overview
- Automation with SQL Server Agent
- Troubleshooting common issues
Frequently Asked Questions
What prerequisites are needed?
T-SQL knowledge and general SQL Server familiarity are recommended.
Does this cover HA/DR in depth?
It's covered at an overview level; deep configuration is covered in the dedicated High Availability and Disaster Recovery course.
Is this hands-on?
Yes, extensive server administration labs are included.
Is this tied to a specific certification?
It's aligned with real-world DBA responsibilities rather than a specific exam.
Notes
Advanced level, 5 days (40 hours), delivered face-to-face or online with hands-on server administration labs. Solid T-SQL and SQL Server fundamentals are required beforehand.