Lesson 1
Databases and SQLite
From tables to the first biblioteca.db file: guided DB Browser for SQLite lab.
3 practical exercises
Open lesson →Learning paths · SQL
Start with relational databases and continue with SELECT and WHERE. Each lesson includes explanations, worked examples, guided exercises and hands-on practice with DB Browser for SQLite.
Try queries immediately in the lab. You can then download biblioteca.db, continue in DB Browser for SQLite and reopen the modified database here.
The exercises are for practice: check your result, receive hints and try again until the method is clear.
Official DB Browser for SQLite website ↗From tables to the first biblioteca.db file: guided DB Browser for SQLite lab.
3 practical exercises
Open lesson →Query biblioteca.db, choose columns and filter rows using comparisons and logical operators.
10 practical exercises
Open lesson →Sort books by year and author, choose how many results to display and learn why LIMIT needs an explicit ordering.
8 practical exercises
Open lesson →Search for text fragments, select multiple values, use ranges and distinguish NULL from zero and the empty string.
10 practical exercises
Open lesson →Use COUNT, DISTINCT, MIN, MAX, AVG and SUM to turn many rows into a few meaningful summaries.
8 practical exercises
Open lesson →Get statistics by genre and author, filter books with WHERE and filter groups with HAVING.
10 practical exercises
Open lesson →Guided SQL review on real food data, with hints and no JOINs.
10 practical exercises
Open lesson →Guided SQL review on real food data, with hints and no JOINs.
10 practical exercises
Open lesson →