Connect to your database

For this workshop, we will use the DuckDB database engine. It's small enough that it can run in your browser. This avoids the need to do a lot of setup.

First, you need a copy of the database we will use. Use the following download link and save the file somewhere you can find it back. It is about 10Mb.

Download

Next, open shell.duckdb.org, DuckDB's own browser-based SQL shell, and open the file you just downloaded there. Here you will be able to browse the database, run queries through the SQL editor and see the results. We will use shell.duckdb.org throughout this workshop.

Check your work:

In the shell, you can look at the list of tables and browse their contents.

You can also write queries. Enter a query like:

SELECT COUNT(*) as count FROM person

And run it. This should give you a number as result (164 for dbadetective-v4).