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 - 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.