SQL Server Database: Intermediate
Operate a multi-database SQL environment with backup, restore, security, and troubleshooting scenarios.
Audience
- Self-paced technical learners
- Instructor-led cohorts
- Enterprise teams preparing staff for hands-on operations
Prerequisites
- Beginner course or equivalent experience
- Comfort with command-line or admin consoles
Outcomes
- Provision an isolated sql server database lab from template metadata.
- Use snapshots, rollback, validation checks, and teardown safely.
- Explain how Microsoft, SQL Server fit into an enterprise training environment.
- Produce evidence that an instructor or admin can review.
Modules and labs
Each module maps to provisioned lab work, validation evidence, reset/rollback policy, and instructor visibility.
Windows Server 2022 base
definedWindows Server 2022 evaluation or licensed ISO
TODO: Build golden image from valid Microsoft evaluation or customer-licensed media.
SQL Server template
definedWindows Server 2022 plus SQL Server Developer/Evaluation media
TODO: Attach approved SQL Server media and create sysprepped image.
Windows Admin Center template
definedWindows Server 2022 base plus Windows Admin Center installer
TODO: Create gateway certificate automation and student-friendly URL handoff.
VM reachable
The VM reports boot complete and responds through the tenant bastion path.
SQL reachable
The SQL endpoint accepts a least-privilege validation login.
Snapshot created
A named checkpoint exists before the exercise stage.
Rollback tested
The instance returns to the expected baseline state.