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

  • Buried in cloud files? We can help with Spring cleaning!

    Whether you use Dropbox, Drive, G-Suite, OneDrive, Gmail, Slack, Notion, or all of the above, Dokkio will organize your files for you. Try Dokkio (from the makers of PBworks) for free today.

  • Dokkio (from the makers of PBworks) was #2 on Product Hunt! Check out what people are saying by clicking here.

View
 

Topic - Creating and Using Views

Page history last edited by Dr. Ron Eaglin 9 years, 3 months ago

 Topic -Creating and Using Views

 

Reading

 

Required

 

http://www.w3schools.com/sql/sql_view.asp - The basics of understanding how to create views is available at w3 schools, and this will get you through most of view creation.

http://msdn.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx - Materialized or indexed views are a crucial component to being able to improve performance.

 

Reference

 

http://msdn.microsoft.com/en-us/library/ms187956.aspx - Documentation for SQL Server CREATE VIEW

Lectures

 

Views Example using Registration System - Demonstrates how to create a view from multiple joined tables.

 

Assignments

 

 

COP4709 Course Lectures By Week

Comments (0)

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