COMP3311 Week 06 Lecture
More SQL Exercises
Exercise: SQL Queries on MyMyUNSW
SQL: View Updates
SQL Views and Updates
Extending SQL
Limitations of Basic SQL
Extending SQL
SQL Data Types
Database Programming
Stored Procedures
PostgreSQL Stored Procedures
Function Return Types
SQL Functions
SQL Functions
Exercise: SQL Function on MyMyUNSW
PLpgSQL Functions
PLpgSQL
Defining PLpgSQL Functions
PLpgSQL Function Parameters
Exercise: functions on (sets of) integers
Exercise: Constructing Names
Exercise: Traversing Hierarchies
Exercise: Student Transcripts
Constraints
Constraints
Assertions
Triggers
Triggers
Trigger Semantics
Triggers in PostgreSQL
Example Trigger #1
Example Trigger #2
Exercise: Triggers (1)
Exercise: Triggers (2)
Produced: 29 Apr 2009
![[index]](icon/up.gif){kind=icon}