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 ?