Week 1 Topic – Review of Database I

Topic – Review of Database I

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.

Reading

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

Lectures

Lecture – Table Joins Part 1

Lecture – Getting Started with SQL Server Management Studio

Lecture – Foreign Keys Example 1

Lecture – Foreign Keys Example 2

Lecture – Advanced Database Modeling Object Relationships

Assignment

Week 1 Assignment