Week 1 will be a review of the basic concepts from your previous database course. During week 1 you will need to download and install Microsoft SQL Server and SQL Server management studio from https://www.dreamspark.com/ . You will need to have access to and be able to use SQL Server by the end of the week.
Reference - Installing SQL Server - http://msdn.microsoft.com/en-us/library/ms143219.aspx
Required - Data Types in SQL Server - http://msdn.microsoft.com/en-us/library/aa258271%28v=sql.80%29.aspx
Lecture - Getting Started with SQL Server Management Studio
Lecture - Foreign Keys Example 1
Lecture - Foreign Keys Example 2
Lecture - Advanced Database Modeling Object Relationships