DB Studio tutorials
Learn database skills step by step with free, browser-based tutorials in DB Studio.
Beginner
Beginner
Explore the DB Studio interfaceExplore the library, tables, queries, forms, reports and document tabs with a fictional practice database.8 min · ▶ Video 2:28Create a database in DB StudioCreate and manage a local database in DB Studio, then learn where your schoolwork is stored.8 minCreate a table in DB StudioDesign a table with an automatic key and useful field types, add three records, and export the database.10 min · ▶ Video 2:29Save and reopen a DB Studio databaseExport a SQLite file, hand it in or move it to another computer, and import it without losing a same-named database.8 minSort, find and filter recordsSort kits by unit cost, filter a price range and find records in DB Studio without changing the stored data.8 min · ▶ Video 2:40Import an Access file into DB StudioImport your Access file locally, review what was preserved, check tables and records, then export and reopen a SQLite copy.12 min · ▶ Video 2:48
Intermediate
Intermediate
Lookup and calculated fields in DB StudioShow area names while storing their IDs, then calculate stock value from quantity and unit cost in the Prototype workshop sample.10 min · ▶ Video 2:34Create and save a query in DB StudioFilter and sort Makerspace records in DB Studio, save the query, and inspect its SQL.12 min · ▶ Video 2:38
Coming soon
Coming soon
More step-by-step guides are on the way:
- Table relationships
- Visual query designer
- Forms
- Reports and printing