SQLite Python

This tutorial series guides you step-by-step on how to work with the SQLite database using the Python sqlite3 module.

Prerequisites #

SQLite knowledge.
Familiar with Python programming.

Section 1. Getting started #

In this section, you’ll learn how to create a new SQLite database and open a database connection from a Python program. Additionally, you’ll learn how to create new tables in the SQLite database in Python.

Creating an SQLite database from a Python program – Create a new SQLite database and open a database connection from a Python program.
Create tables in SQLite databases in Python – Create tables in an SQLite database from a Python program.

Section 2. Performing Database Operations #

In this section, you’ll learn how to insert, update, delete, and select data from tables in Python.

Inserting data into a table in Python – Walk you through the steps of inserting data into a table in SQLite database using Python.
Updating data using Python – Update data in tables of an SQLite database in Python.
Selecting data – Retrieve data from tables in an SQLite database in a Python program.
Deleting data – Delete rows from a table in SQLite database from Python.

Was this tutorial helpful?