praxis.ibLog in
A3.3 Database programmingA3.3.5

Different database views

Describe different database views

AHL≈ 50 minCommand term: DescribePremium

In this lesson

  • Describing virtual views and materialised (snapshot) views, and how they differ
  • Creating and querying views in SQL, and refreshing a materialised view
  • Describing why views are used: hiding complexity, consistency, independence, performance, simpler queries, read-only or updatable data, and security

This lesson is part of Premium

Every topic has one free lesson. Premium unlocks every interactive lesson, the exam-style questions at the end of each one, and the rest of Praxis IB.

Log in or sign upTry the free lesson: A3.3.1 Data language types within SQL

What's inside

  1. LearnVirtual views
  2. LearnMaterialised (snapshot) views
  3. CheckQuick check
  4. LearnWhy databases use views
  5. LabViews in the print shop
  6. Try itA view that cannot be updated
  7. ExamWorked exam answer
  8. ReviewMistakes examiners see
  9. Exam practiceExam-style questions

Ends with 5 exam-style questions worth 13 marks, with a self-marking markscheme.