Module 21

Python Database Communication

Learn how Python communicates with databases and how database queries are organized.

Advanced2 hours 5 min5 lessons

Learn why a Python program uses a database table, and the six steps from import and connect through the cursor, the query, and close.

Create a Python SQLite table, add a column with ALTER TABLE, and remove the table with DROP TABLE. These are the data definition queries.

Insert, update, and delete SQLite rows from Python, then commit the change or roll it back. Values stay outside the SQL text.

Read SQLite rows with SELECT, then take one row, a limited batch, or every remaining row using fetchone, fetchmany, and fetchall.

Read SQLite column names from cursor.description after SELECT, then print each row under those names without hard-coding the header.