Getting Started

📄️ Introduction

Get oriented with databases, SQL, and what makes SQLite unique so you can confidently follow the rest of the course.

Learn what a database is, what problems it solves, and how it differs from files and spreadsheets.

Understand tables, rows, columns, keys, and relationships so you can model real-world data the relational way.

Learn what SQL is, why it is declarative, and how it describes the data you want instead of step-by-step instructions.

Learn what SQLite is, how it runs inside your application, and what makes it different from server databases.

Compare SQLite to common server databases and learn the tradeoffs around deployment, concurrency, and scaling.

Use a practical checklist to decide when SQLite is the right fit and when you should reach for a server database instead.