Sumários

Complex Integrity Constraints in SQLSchema

26 Novembro 2019, 16:00 Ana Paula Pereira Afonso

Complex integrity constraints in SQL. Constraints over a single table. Domain constraints and distinct types. Assertions: ICs over several tables. Triggers and active databases.  Examples of triggers in SQL. Designing active databases. Why triggers can be hard to understand. Constraints versus triggers. Other uses of triggers.


SQL: queries

26 Novembro 2019, 13:30 Ana Paula Pereira Afonso

Laboratory class: SQL/DML


SQL: queries

19 Novembro 2019, 18:00 Ana Paula Pereira Afonso

Laboratory class: SQL/DML


SQL: QUERIES - IV

19 Novembro 2019, 16:00 Ana Paula Pereira Afonso

Null values. Comparisons using null values. Logical connectives AND, OR, and NOT. Impact on SQL constructs. Outer joins. 


SQL: queries

19 Novembro 2019, 13:30 Ana Paula Pereira Afonso

Laboratory class: SQL/DML