SQLite
Welcome, champion! 🔥
You've mastered 0 of 76 lessons. Start your first lesson free — no signup needed.
About this course
SQLite is the database inside phones, browsers, desktop apps and countless small tools, and it is often the first database a developer uses. It is also easy to misuse, because it does not behave like a client-server database: a string can sit in an INTEGER column, foreign keys are not enforced until you switch them on, and only one connection can write at a time. This online SQLite course on Abekus teaches SQLite from the sqlite3 command-line shell and from Python, in short reading-card lessons each followed by an MCQ quiz.
Who this SQLite course is for
It is written for students, Python developers and mobile or desktop app developers who need a small embedded database. Basic SQL helps but is not required, since core SELECT, join and GROUP BY queries are covered; some Python is needed for the Python lessons. By the end you can create and query a database file from the CLI and from Python, predict how SQLite stores a value, choose STRICT tables when you need rigid types, enforce keys and foreign keys, read a query plan and add the right index, pick a journal mode, handle database is locked errors, and use parameter binding and transactions correctly in Python.
Examples follow one setup: a current SQLite release through the sqlite3 command-line shell, and Python 3.14 or later with the standard-library sqlite3 module. One running example is used throughout, a bookshop.db file with authors, books and orders tables, prices in whole rupees, and a bookshop.py script. The course leaves out the C API and building SQLite from source, virtual-table and extension authoring, ORMs beyond a mention, graphical tools and replication products apart from a single comparison mention.
How the lessons work
Each lesson is a short set of reading cards on one feature or rule, usually with a few lines of SQL or Python and the output they produce, followed by a quiz of multiple-choice questions that often ask what a statement will store, return or report. Lessons start with a first database and where SQLite fits, then move through the sqlite3 CLI, tables and types, keys and constraints, querying data, changing schemas, indexes and query plans, transactions and concurrency, and SQLite from Python, and end with comparisons, choices and worked cases. You go at your own pace.
MCQ practice vs video courses for SQLite
Video courses on Udemy, Coursera or YouTube are a good choice if you want to watch someone build an app on top of a database. This course is built for a different job: a short explanation followed straight away by questions about real statements, such as what typeof() returns after inserting '500' into an INTEGER column, whether a delete cascades when the foreign_keys pragma is off, or whether a plan shows SCAN or SEARCH. SQLite's flexible rules are where bugs hide, and predicting them question by question builds the habits that prevent those bugs. Many learners use both: a video for a first walkthrough, and questions to make the rules stick.
Common SQLite mistakes
The course corrects these directly:
- Assuming SQLite rejects a string in an INTEGER column. Only STRICT tables reject it.
- Declaring foreign keys and expecting them to be enforced. Enforcement needs PRAGMA foreign_keys = ON on every connection.
- Trusting VARCHAR(50) to limit length. SQLite ignores the number.
- Expecting WAL mode to allow several writers at once. There is still one writer; readers simply stop blocking it.
- Believing SQLite cannot drop a column. ALTER TABLE DROP COLUMN exists, though some changes still need a table rebuild.
- Thinking a with block closes a Python connection. It only commits or rolls back.
- Building SQL with string formatting. Placeholders and parameter binding prevent SQL injection.
- Storing money as REAL. Whole rupees in an INTEGER column avoid floating-point errors.
Best way to learn SQLite
Work with one small database file and keep poking at it. Create the tables, insert awkward values and check what typeof() reports, switch on foreign keys, then run EXPLAIN QUERY PLAN before and after adding an index, and repeat the same steps from Python. The last part of the course works this way: it compares SQLite with PostgreSQL and with JSON files for app data, and strict with flexible typing, asks when SQLite fits a web app, when to move off it and when to use an in-memory database, and applies everything to SQLite in Android and iOS apps, as a test database, for CSV data analysis and on edge and embedded devices.