Aug 27: Relational Model, DML
Learning Objectives
After today's class, you should be able to:
- Explain the relational model structure and relational operations.
- Write
SELECT
,INSERT
,UPDATE
, andDELETE
statements in SQL.
Lesson Outline¶
Lecture Slides [20 min]
- Introduction to HW 1
- Python Refresher
Lecture Slides [20 min]
- Relational Model and DML
- Based on Chapter 2 from the zyBook
Lab Activity [35 min]
- SQLite (DB Browser)
- Parts 1–3 last week, Parts 4–7 today