| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Topic - Review of Database I

Page history last edited by Dr. Ron Eaglin 11 years ago

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

Comments (0)

You don't have permission to comment on this page.