Learn SQLite with free notebooks
9 free video lessons that use SQLite, each with a downloadable Jupyter notebook and, where needed, the dataset. Learn SQLite by working through real examples.
About these SQLite lessons
These 9 lessons come from 7 different courses, so you see SQLite used in several settings. The course with the most SQLite lessons is Data analytics zero to hero (3 lessons). 3 of the lessons include a real dataset to practise on.
SQLite is most often used here together with pandas, JSON, NumPy and pathlib.
Watch the video, then run the notebook yourself: changing the code and re-running it is the fastest way to learn.
Courses that use SQLite
- Data analytics zero to hero – 3 lessons
- Python Beginner Course – 1 lesson
- Python for Data Analysts – 1 lesson
- Pandas Full Course – 1 lesson
- Mastering Pandas – 1 lesson
- Supply Chain Operations Analytics – 1 lesson
- Python for Banking and Finance – 1 lesson
55 minSQLite with Python for Beginners: SQL Databases in 1 Hour (Beginner Python Course, Part 9)
12 minSQL Fundamentals for Data Analysts | Data Analytics #16
12 minSQL Joins & Aggregations Explained | Data Analytics #17
12 minPython + SQL: Real Analyst Queries | Data Analytics #18
26 minSQL for Python Users with sqlite3

Read and Write CSV, Excel, JSON and SQL in Pandas (No More File Errors) | Pandas Course #7
17 minHow to Import and Export Data in Pandas: CSV, Excel, JSON, and SQL Explained
23 minIntroduction to SQL for Supply Chain Analysts
31 minComparing SQL and Pandas for Effective Financial Reporting and Data Analysis
Frequently asked questions
Where should I start learning SQLite?
Start with “SQLite with Python for Beginners: SQL Databases in 1 Hour (Beginner Python Course, Part 9)”, then work through the Data analytics zero to hero course.
Are these SQLite lessons free?
Yes. Every video, notebook and dataset on this site is free to use for learning.
Can I run the SQLite notebooks without installing Python?
Yes. Open them in Google Colab, or use the Run in browser button where a lesson has one.