Sep 02: Running SQL in Python

Learning Objectives

After today's class, you should be able to:

• Explain the difference between a Connection and a Cursor.
• Write a Python program that executes SQL queries and updates.

Lesson Outline

Lecture Slides [20 min]

• Python Database API
• Q&A and hints on HW1

Lab Activity [45 min]

• Python DB-API (K-12 data)
• Submit on Gradescope today

Discussion [10 min]

• Solution and lessons learned

Your To-Do List

• Python Refresher – review as needed
• Finish reading Read02: sections 1.2, 1.3, 1.4
• Start reading Read03: sections 1.5, 1.6, 1.7
• Finish working on HW1 (due tonight)