Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Working with Views

Your first view
How to use views
Summary
11. Summary

Instruction

Great job! It's time to wrap things up. First, a summary:

  1. Views are "virtual tables" – they don't contain any data themselves, but you can query them like any other table.
  2. To create a view, use: 
    CREATE VIEW textbooks_stats AS
SELECT ...
FROM ...
...
  3. Views can include clauses such as GROUP BY, JOIN, and HAVING.
  4. A view can be based on another view.

How about a review exercise?

Exercise

Click Next exercise to continue.