Week 05: Advanced SQL & Integrity Constraints (under construction)

SLOs for Week 05

By the end of this unit, students will be able to…

Write and execute triggers for database automation using CREATE TRIGGER, BEFORE, AFTER and INSTEAD OF.
Understand that SQLite is a transactional database where all changes and queries are atomic, consistent, isolated, and durable (ACID) and what it means.
Manage transactions using COMMIT and ROLLBACK.
How to perform SQL full-text search using MATCH.
Use SQLite CLI commands, such as .schema, .table, .headers on/off, .mode column.
Normalize database schemas using BCNF and 4NF.

Slides, videos, and application exercises

Week 05: Slides

Slides

No readings for Week 05.

Homework 05: No homework for Week 05

Project 05: No Project for Week 05

---
title: "Week 05: Advanced SQL & Integrity Constraints (under construction)"
format: 
  html:
    css: /styles.css
# draft: true
# draft-mode: visible
---

## SLOs for Week 05

By the end of this unit, students will be able to...

1.  Write and execute triggers for database automation using `CREATE TRIGGER`, `BEFORE`, `AFTER` and `INSTEAD OF`.
2.  Understand that SQLite is a transactional database where all changes and queries are atomic, consistent, isolated, and durable (ACID) and what it means.
3.  Manage transactions using `COMMIT` and `ROLLBACK`.
4.  How to perform SQL full-text search using `MATCH`.
5.  Use SQLite CLI commands, such as `.schema`, `.table`, `.headers on/off`, `.mode column`.
6.  Normalize database schemas using BCNF and 4NF.




## Slides, videos, and application exercises

::::: slide-deck
**Week 05: Slides**

::: slides
[Slides]()
:::

::: reading
No readings for Week 05.
:::
:::::

<!-- ## Homework assignments -->

::: homework
**Homework 05: No homework for Week 05**
:::

<!-- ## Lab -->

::: lab
**Project 05: No Project for Week 05**
:::