log inhelp

 | 

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

  • Whenever you search in PBworks or on the Web, Dokkio Sidebar (from the makers of PBworks) will run the same search in your Drive, Dropbox, OneDrive, Gmail, Slack, and browsed web pages. Now you can find what you're looking for wherever it lives. Try Dokkio Sidebar for free.

View
 

Topic - Review of Database I

Page history last edited by Dr. Ron Eaglin 10 years, 2 months 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.

Printable version