Introduction
Get oriented with databases, SQL, and what makes SQLite unique so you can confidently follow the rest of the course.
What Is a Database?
Learn what a database is, what problems it solves, and how it differs from files and spreadsheets.
Relational Database Concepts
Understand tables, rows, columns, keys, and relationships so you can model real-world data the relational way.
What Is SQL?
Learn what SQL is, why it is declarative, and how it describes the data you want instead of step-by-step instructions.
What Is SQLite?
Learn what SQLite is, how it runs inside your application, and what makes it different from server databases.
SQLite vs Other Databases
Compare SQLite to common server databases and learn the tradeoffs around deployment, concurrency, and scaling.
When to Use SQLite
Use a practical checklist to decide when SQLite is the right fit and when you should reach for a server database instead.