Mathew K Analytics

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

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.