Introduction
  • Introduction
  • Is this your first session?
  • Resources
  • Objectives
  • Summary of and problems with our existing database
Objective 4 - Create and modify constraints (simple statements)
  • What are constraints?
  • Unique constraints - what are they?
  • Unique constraints in action
  • Unique constraints
  • Default constraints - what are they?
  • Default constraints in action
  • Default constraints
  • Check constraint - what are they?
  • Check constraints - in practice
  • Check constraints
  • Primary key
  • Primary key - in practice
  • Primary Keys
  • Foreign key - what is it?
  • Foreign key - in practice
  • Foreign Keys
  • Summary
Objectives 2 and 3: Views
  • Creating views
  • Altering and dropping views
  • Creating views
  • Securing views
  • Security
  • Security
  • Adding new rows to views
  • Deleting rows in views
  • Adding and deleting rows in views
  • What is an index?
  • Creating an indexed view
  • Creating an indexed view
Objective 5: Create and alter DML triggers
  • What are triggers?
  • Creating an AFTER trigger
  • Creating an INSTEAD OF trigger
  • Triggers
  • Nested triggers
  • Update functions
  • Nested triggers and update functions
  • Handling multiple rows in a session
  • Summary
End of Session 3
  • BONUS - Recap, Look ahead and Voucher Code
  • Well done!