Learning resource · Dataset
SQL Server practice dataset v1.0.0
Eight tables plus a reset script, ready to run on SQL Server.
Get the practice file
DDI SQL Server practice dataset v1.0.0.sql · 11 KB
Before you download
Inside the practice dataset
The v1.0.0 script creates and resets eight related tables in DDI_SQL_Training. These are the row counts the script verifies after seeding.
- Departments
- 4 rows
- Employees
- 12 rows
- Categories
- 5 rows
- Products
- 15 rows
- Customers
- 20 rows
- Orders
- 5,000 rows
- OrderItems
- 10,000 rows
- Payments
- 2,500 rows
What you need
SQL Server 2019 or later, a disposable practice instance, and an editor that supports SQL Server batches. Do not run the reset script against a valuable database.
Read the setup lesson →Version 1.0.0 · Initial shared teaching baseline.