| 
  • 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 - Creating and Using Views

Page history last edited by Dr. Ron Eaglin 11 years 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.