Database Fundamentals/Views

This lesson introduces views.

Objectives and Skills
Objectives and skills for the views portion of Microsoft Exam 98-364 Database Fundamentals include:
 * Create database objects
 * Create views
 * Understand when to use views and how to create a view by using T-SQL or a graphical designer

Readings

 * 1)  View (SQL)

Multimedia

 * 1) Microsoft Virtual Academy: Creating Databases and Database Objects
 * 2) YouTube: SQL Views

Activities

 * 1) Use SQL Server to create views from the Student and Course tables in your College database.
 * 2) Create the following views:
 * 3) * Watch YouTube: How to create a view using Microsoft SQL Server Studio Management.
 * 4) * Watch YouTube: SQL Views.
 * 5) * Read Microsoft: Create Views.
 * 6) * Read W3Schools.com: SQL Views.
 * 7) * Create a view that displays all of the columns and all of the rows from the Course table to display the CourseID, Description, CreditHours fields.
 * 8) * Create a view that will display the name of all students from the Student table.
 * 9) * Modify the previous view to display only students with your last name.
 * 10) * Create a view that will return one column name CourseID, Description and contains the last name of the instructor.
 * 11) * Practice creating simple views using the College database you created.

Lesson Summary

 * A view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

Key Terms

 * view