Databases · Beginner → Expert
🪶 SQLite and Embedded Database Engineering
Use SQLite effectively in desktop, mobile, edge, and embedded applications with schema design, transactions, indexing, concurrency, pragmas, backup, security, and performance tuning.
Course roadmap
Pass each module exam to unlock the next module.
Module 1 · Beginner
SQLite Architecture, File Format and Embedded Design
Locked
Module 2 · Beginner
Database Creation, Types and Manifest Typing
Locked
Module 3 · Beginner
SELECT, Filtering, Sorting and Expressions
Locked
Module 4 · Beginner
Joins, Aggregates, Subqueries and CTEs
Locked
Module 5 · Intermediate
Schema Design, Keys, Constraints and Normalization
Locked
Module 6 · Intermediate
INSERT, UPDATE, DELETE and Transaction Boundaries
Locked
Module 7 · Intermediate
Journaling, WAL and Crash Consistency
Locked
Module 8 · Intermediate
Locking, Concurrency and Busy Handling
Locked
Module 9 · Advanced
Indexes, Query Planner and EXPLAIN QUERY PLAN
Locked
Module 10 · Advanced
Pragmas, Configuration and Database Maintenance
Locked
Module 11 · Advanced
Foreign Keys, Triggers, Views and Generated Columns
Locked
Module 12 · Advanced
Full-Text Search and Extension Concepts
Locked
Module 13 · Advanced
Backup API Concepts, Export and Recovery
Locked
Module 14 · Expert
Security Boundaries, Encryption Options and Sensitive Data
Locked
Module 15 · Expert
Application Integration and Connection Lifecycle
Locked
Module 16 · Expert
Performance, Vacuum, Analyze and File Growth
Locked
Module 17 · Expert
Expert Capstone: Reliable Embedded Data Layer
Locked
Certification gate
Final course exam
Pass mark: 80%. Time limit: 360 minutes. All module exams must be passed first.
Locked until modules are passed