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:^[1]

• 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. Read Wikipedia: View (SQL).

Multimedia

1. Watch Microsoft Virtual Academy: Creating Databases and Database Objects.
2. Watch 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:
   • Watch YouTube: How to create a view using Microsoft SQL Server Studio Management.
   • Watch YouTube: SQL Views.
   • Read Microsoft: Create Views.
   • Read W3Schools.com: SQL Views.
   • 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.
   • Create a view that will display the name of all students from the Student table.
   • Modify the previous view to display only students with your last name.
   • Create a view that will return one column name CourseID, Description and contains the last name of the instructor.
   • 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.^[2]

Key Terms

view

See Also

• Microsoft: How to: Create Views (Visual Database Tools)

References

Resource type: this resource is a lesson.