Get the Course Material

This course uses two small demo SQL Server databases as the source of the data warehouse you will create. The databases are:

• Service. The service database represents a service business where staff perform tasks for clients and record their time in timesheets.
• Human Resources. A typical human resources system which records information about employees, their positions and tenure.

To complete the course you need to obtain these databases (from the link below) and create them on any accessible SQL Server 2012 (or above) instance.

1. Download the Database Scripts ( Databases.zip – approx 500kb).
2. Unzip Databases.zip file. The file contains 2 .sql files – HumanResourcesDatabase.sql and ServiceDatabase.sql.
3. Open and run the scripts using SSMS. Each script will create a database, tables and views in the database and some data.

Below are links to two transaction files. The course also uses these two files in the multi-file extract topic. Download these two files and place them in a broadly accessible directory (e.g. “C:\Dimodelo”)

1. Transactions_20160102
2. Transactions_20160101