SQL/DML

5 Dezembro 2023, 13:30 • Ana Paula Pereira Afonso

---

Laboratory class: Exercises SQL/Data Manipulation Language(DML)

SQL/DML

28 Novembro 2023, 18:00 • Ana Paula Pereira Afonso

---

Laboratory class: Exercises SQL/Data Manipulation Language(DML)

SQL/DML IV and Relational Model - II (2nd part)

28 Novembro 2023, 16:00 • Ana Paula Pereira Afonso

---

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

Relational Model - II (2nd part): 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/DML

28 Novembro 2023, 13:30 • Ana Paula Pereira Afonso

---

Laboratory class: Exercises SQL/Data Manipulation Language(DML)

SQL/DML

21 Novembro 2023, 18:00 • Ana Paula Pereira Afonso

---

Laboratory class: Exercises SQL/Data Manipulation Language(DML)