Jump to content

Database Fundamentals/Views

From Wikiversity

This lesson introduces views.

Objectives and Skills

[edit | edit source]

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 | edit source]
  1. Wikipedia: View (SQL)

Multimedia

[edit | edit source]
  1. Microsoft Virtual Academy: Creating Databases and Database Objects
  2. YouTube: SQL Views

Activities

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

See Also

[edit | edit source]

References

[edit | edit source]
Type classification: this is a lesson resource.