Sep 08: SQL in Python

Learning Objectives

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

• Explain the difference between a Connection and a Cursor.
• Execute parameterized queries and explain why string concatenation is unsafe.

Lesson Outline

Discuss Project [15 min]

• System Description

Lecture Slides [20 min]

• Python Database API
• Python Refresher ← review as needed

Lab Activity [40 min]

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

Your To-Do List

• Submit the Week 3 reading ← due Wednesday
• Submit the Team Survey on Canvas ← due Thursday