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

Assignments

COP4709 Spring 2013 Assignments