Databases
Microsoft SQL Server DBA
Administer, secure, and optimise Microsoft SQL Server for enterprise environments.
5 DaysIntermediateTensorNova Certificate of Completion
Course Curriculum
Module 1Installation & Configuration
- SQL Server editions and licensing
- Installation and post-install configuration
- SQL Server services and network protocols
- TempDB and memory configuration
Module 2Security & Governance
- Logins, users, and roles
- Row-Level Security and Dynamic Data Masking
- Transparent Data Encryption (TDE)
- Auditing and compliance
Module 3Backup & Recovery
- Recovery models: Full, Bulk-Logged, Simple
- Full, differential, and transaction log backups
- Point-in-time recovery
- Backup automation with Maintenance Plans
Module 4High Availability
- Always On Availability Groups
- Failover Cluster Instances (FCI)
- Log shipping
- Database mirroring migration paths
Module 5Performance Tuning
- Execution plans and query optimiser
- Index design: clustered, non-clustered, columnstore
- Wait statistics analysis
- Query Store for regression detection
Prerequisites
- Basic SQL (SELECT, INSERT, UPDATE, DELETE)
- Windows Server administration fundamentals
- No prior DBA experience required
Who Should Attend
- Junior DBAs formalising their skills
- System administrators managing SQL Server
- Developers taking on database responsibilities
Get Started
Interested in Microsoft SQL Server DBA?
Our training advisors will help you choose the right batch format, dates, and pricing for your team or individual goals.