Teach databases with DB Studio

A free, browser-based database workspace for introductory lessons—no account or installation needed.

Use it in a browser on school computers and Chromebooks. After the first online visit, DB Studio also works offline.

An adaptable lesson sequence

An adaptable lesson sequence

Adapt the order and pace to your class. This sequence moves from exploring a database to building and handing in a small project.

Nine adaptable database lessons
#LessonWhat students doTutorial / start
1What is a database?Explore a lesson database from the catalogue.Explore lesson databases
2Create a database and a tableCreate a database, add a table and choose field types.Create a databaseCreate a table
3Keys and field rulesSet a primary key, edit field properties and try validation rules.Open DB StudioCreate a table
4Work with recordsEnter, sort, filter and find data in a datasheet.Open a lesson database
5Lookups and relationshipsConnect tables with lookup fields and relationships on a computer.Open DB StudioCreate a table
6Queries: criteria and sortingDesign a query with criteria and sorting, then save it.Create and save queries
7Forms for data entryDesign a form on a desktop; students can also enter data on phones.Open DB Studio
8Reports: groups and totalsGroup records, add totals and print with the browser or save as PDF.Open DB Studio
9Project: build a small databaseBuild a project such as a school library, then export it to hand in.Save and reopen a database

1. What is a database?

What students do
Explore a lesson database from the catalogue.
Tutorial / start
Explore lesson databases

3. Keys and field rules

What students do
Set a primary key, edit field properties and try validation rules.
Tutorial / start
Open DB StudioCreate a table

4. Work with records

What students do
Enter, sort, filter and find data in a datasheet.
Tutorial / start
Open a lesson database

5. Lookups and relationships

What students do
Connect tables with lookup fields and relationships on a computer.
Tutorial / start
Open DB StudioCreate a table

6. Queries: criteria and sorting

What students do
Design a query with criteria and sorting, then save it.
Tutorial / start
Create and save queries

7. Forms for data entry

What students do
Design a form on a desktop; students can also enter data on phones.
Tutorial / start
Open DB Studio

8. Reports: groups and totals

What students do
Group records, add totals and print with the browser or save as PDF.
Tutorial / start
Open DB Studio

9. Project: build a small database

What students do
Build a project such as a school library, then export it to hand in.
Saving and handing in work

Saving and handing in work

  1. Work is saved locally and automatically in this browser.
  2. At the end of the lesson, export a .sqlite file and save it to a USB drive, school folder or cloud drive of your choice.
  3. Hand in the .sqlite file through the channel your class already uses, such as an assignment upload or email; DB Studio does not collect submissions.
  4. To check the work, open the student's file in DB Studio and choose “Keep both databases” so your own databases are not replaced.
Browser storage is not a backup. Clearing browser data, using a private window, or resetting a shared-computer profile can delete databases. The single safety copy is kept in the same browser, not in a separate location, so ask students to export at the end of every lesson. Links with ?db= work only in the same browser.
Device notes

Device notes

Designing tables, relationships, queries, forms and reports requires a desktop computer. Phones and tablets can view and enter data, run SQL and run saved queries.

Lesson databases

Lesson databases

The catalogue contains three CC BY 4.0 lesson databases. Each opens as an independent copy, and a database works offline once downloaded.

Open the lesson catalogue
Frequently asked questions

Frequently asked questions

Do students need accounts?
No. DB Studio is free to use and students do not need accounts.
Can I use DB Studio without internet?
Yes, after the first online visit. Lesson databases also work offline once downloaded.
Can students open Access files from older lessons?
Only tables and data are imported from Access files. Other objects, such as queries, forms and reports, are not imported.
How do I check student work?
Ask students to export a .sqlite file. Open it in DB Studio and choose “Keep both databases” to leave your own databases in place.
Is there a classroom-management integration?
No. Use your usual tools and channel to collect the exported files.