Intermediate SQL for Microsoft SQL Server: Teaching Tips
Approximate Timings:
- 9:00-10:00 – slides 1-31
- 10:15-11:30 – 32-51
- 12:30-1:30 – 52-71
- 1:45-3:00 – 72-99
- 3:00-4:00 – 100-end
Download Data:
There are 2 data sources, Adventureworks2019 and OGCBooks. Adventureworks can be downloaded from this link on the Microsoft website:https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
OGCBooks can be added using the instructions in this document: