SQLite course online

SQLite is the most widely deployed database in the world - it sits in every Android and iOS phone, in browsers and in countless applications. Instead of a server, it is simply a file inside the app. On BitWizards you learn it entirely in the browser: write a query, click “Run” and see the result in a table - no account, no installation.

Open the SQLite course without signing in

What you will learn

• SELECT, WHERE, sorting, LIKE/IN/BETWEEN and functions.
• Aggregations (GROUP BY, HAVING) and joining tables (JOIN, LEFT JOIN).
• Modifying data: INSERT, UPDATE, DELETE and UPSERT (ON CONFLICT).
• Creating tables, foreign keys, CHECK/UNIQUE constraints, indexes and transactions.

Differences from MySQL and PostgreSQL - on live examples

This is what makes the course special: you see every dialect trap in action.

• Flexible types (type affinity) - SQLite will accept text in an INTEGER column; MySQL and PostgreSQL would refuse.
• Auto-numbering: INTEGER PRIMARY KEY instead of AUTO_INCREMENT (MySQL) or SERIAL (PostgreSQL).
• No DATE type - dates are stored as text, handled with date() and strftime().
• Foreign keys are off by default (PRAGMA foreign_keys) - a classic trap.
• UPSERT via ON CONFLICT (like PostgreSQL), not ON DUPLICATE KEY (MySQL).

SQLite, mobile apps and the INF.04 qualification

A software development student (INF.04, the Polish vocational programming qualification) sooner or later writes a mobile app - and data on a phone means SQLite (on Android also via the Room library). You will meet this dialect in real projects sooner than many textbook topics.

Related technologies

SQL and MySQL - Python - Java

Start the SQLite course