Learn SQLite

Learn SQLite, a lightweight, self-contained, and serverless SQL database engine. This learning path offers comprehensive SQLite courses designed for beginners and embedded application developers. It provides a structured roadmap to master SQL queries, data modeling, and local database management. Through a series of hands-on, non-video SQLite courses and practical exercises in an interactive SQL playground, learners gain real-world experience in building and querying embedded databases.

32 Skills|4 Courses

SQLite for Beginners

DatabaseSQLite

In this course, you'll learn the fundamentals of SQLite, from setting it up on Linux to creating databases, building tables, and querying data. Perfect for beginners!

Completed 0 of 10 Labs

Setting Up SQLite in Linux

Install and Verify SQLite on Linux

Creating and Managing SQLite Databases

Insert User Data into SQLite

Building Tables in SQLite

Build SQLite Database For Contacts

Working with Data in SQLite

Query Specific Data in SQLite

Querying and Filtering Data

Filter SQLite Data for IT Department

SQLite Intermediate to Advanced

DatabaseSQLite

In this course, delve into advanced SQLite techniques. Master constraints, indexing, joins, subqueries, transactions, triggers, views, full-text search, JSON, backups, PRAGMA tuning, CTEs, window functions, and more!

Completed 0 of 17 Labs

Updating a Supplier Catalog

ProjectSQLiteDatabase

Receive supplier CSV updates in SQLite, reject invalid or contradictory records, and advance stock revisions while preserving local shelf notes.

Completed 0 of 3 Labs

Reconciling a Day’s Sales

ProjectSQLiteDatabase

Reconcile SQLite orders, payments and refunds without duplicated totals, then deliver complete order and stall CSV files.

Completed 0 of 3 Labs