SQL Server Burton’s Database


There exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse is divided into six sessions. The first session is called 70-461 Session 1: Querying Microsoft SQL Server (T-SQL). Throughout the course Philip Burton (the instructor) refers to a database that you can download. Below is a SQL Server database diagram of that database. I added the red arrows to show relationships.

Employee

The Employee table’s data may not be what you would expect. Notice that there are gaps and duplicates in the Employee Number. This was done on purpose by Philip Burton for illustration purposes.