Safe training environment onlyThe downloadable database contains synthetic records. Never run its recreation script on a production server or place real patient data in this lab.
- Download SQL Server Developer.
Use Microsoft's SQL Server downloads page and choose the free Developer edition for training.
Open Microsoft SQL Server downloads - Install the database engine.
Run the installer, choose a local development installation, and keep the instance name you will use when connecting.
- Install SSMS.
Download the current SQL Server Management Studio installer, complete the installation, and restart if prompted.
Open Microsoft SSMS installation guide - Connect locally.
Open SSMS, connect to the installed Database Engine, and verify the connection with SELECT @@VERSION;
- Download and run the Healthcare Database.
Open the supplied SQL file in SSMS, confirm this is your isolated training instance, then execute the script.
Download Healthcare Database
- Check your Mac architecture.
From Apple menu → About This Mac, note whether the Mac uses Apple silicon or Intel. The Windows installer must match the virtual machine architecture.
- Download VMware Fusion.
Use Broadcom's official instructions. A Broadcom account may be required to reach the download.
Open VMware Fusion instructions - Create a Windows virtual machine.
Install a compatible Windows 11 image in Fusion. Apple silicon Macs require an Arm-compatible guest; Intel Macs require an x64-compatible guest.
Open Microsoft Windows 11 downloads - Install SQL Server and SSMS inside Windows.
Inside the virtual machine, follow the Windows path on this page. SSMS runs in Windows, not directly in macOS.
- Download and run the Healthcare Database.
Download the SQL file inside Windows, open it in SSMS, verify the local training connection, and execute it.
Download Healthcare Database
FINAL CHECK
Verify the lab before lesson 01.
USE HealtchareDatabse;
GO
SELECT DB_NAME() AS CurrentDatabase;
SELECT COUNT(*) AS TotalPatients
FROM dbo.Patient;
The expected database name is HealtchareDatabse and the synthetic patient count is 1000. If either result differs, stop and repeat the database download/import step.
