Database Fundamentals/Views

From Wikiversity
Jump to navigation Jump to search

This lesson introduces views.

Objectives and Skills[edit]

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[edit]

  1. Wikipedia: View (SQL)

Multimedia[edit]

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

Activities[edit]

  1. Use SQL Server to create views from the Student and Course tables in your College database.
  2. Create the following views:

Lesson Summary[edit]

  • 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[edit]

view

See Also[edit]

References[edit]

Nuvola apps edu miscellaneous.svg Type classification: this is a lesson resource.