Skip to content
Back to catalog
Beginner1 day / 4 to 6 guided hourspublished

SQL Server Database: Beginner

Install, connect to, and protect a SQL Server instance with guided database administration labs.

Audience

  • Self-paced technical learners
  • Instructor-led cohorts
  • Enterprise teams preparing staff for hands-on operations

Prerequisites

  • Basic computer literacy
  • Ability to follow browser-based lab instructions

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.
Course plan

Modules and labs

Each module maps to provisioned lab work, validation evidence, reset/rollback policy, and instructor visibility.

Module 3

Validation and reflection

Required templates

Windows Server 2022 base

defined

Windows Server 2022 evaluation or licensed ISO

TODO: Build golden image from valid Microsoft evaluation or customer-licensed media.

SQL Server template

defined

Windows Server 2022 plus SQL Server Developer/Evaluation media

TODO: Attach approved SQL Server media and create sysprepped image.

Windows Admin Center template

defined

Windows Server 2022 base plus Windows Admin Center installer

TODO: Create gateway certificate automation and student-friendly URL handoff.

Validation checks

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.