Module: Constraints, triggers, view, indexes

Introduction to constraints, triggers, views, and indexes.

Learning Outcomes

Understand constraints, views, triggers, and indexes in Databases

You understand what constraints are for and how to use them.
You understand what views are for and how to use them.
You understand what triggers are for and how to use them.
You understand what indexes are for and how to use them.
You know how to decide what indexes to create for a given workload.

Readings

Chapter 7: Constraints and triggers

Constraints and triggers

20 pages

Chapter 8: Views and indexes

Views and indexes

20 pages

Constraints, triggers, views, indexes

Introduction to handy database constructs

Lecture Notes

Experiential Learning

Exercise 14

Choosing indexes