Aug 29: 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)

Discussion [10 min]

• Solution and lessons learned

Your To-Do List

• Finish reading zyBook sections 2.1 – 2.6
• Finish working on HW1 (due Monday)