Aug 29: Running SQL in Python
Learning Objectives
After today's class, you should be able to:
- Explain the difference between a
Connection
and aCursor
. - Write a Python program that executes SQL queries and updates.
Lesson Outline¶
Lecture Slides [20 min]
- Python Database API
- Q&A and hints on HW 1
Lab Activity [45 min]
- Python DB-API (K-12 data)
Discussion [10 min]
- Solution and lessons learned