Setting up your Database

What do you need for this workshop?

  • Computer (Windows/Mac/Linux)
  • DBeaver SQL IDE
  • Copy of the wera-db DuckDB Database file

Experience

  • We assume you know, generally speaking, what a computer and a database are
  • No prior knowledge of SQL is required

Before the Workshop Starts

  • Please download and set up your copy of DBeaver Community version, then connect it to the DuckDB database file
  • You can download DBeaver for your own system off of the DBeaver website. (Admin access is not required to do the installation)
  • Download the wera-db.duckdb database file
  • Connect DBeaver
    • Open DBeaver, if there is a prompt for a Windows Defender exclusion to speed things up, that is up to you. Your faithful workshop presenters did not use that option.
      Screenshot showing the button to add a new database connection
    • Search for DuckDB, select that option and click next.
      Image showing how to search for and select DuckDB database type
    • Click the ‘Host’ option, and open a path the wera-db.duckdb file you downloaded
      Finish the DuckDB connection setup by browsing for and selecting the database file
    • Click ‘Finish’. If prompted, download the JDBC driver it requests

Thank you for coming to our SQL Workshop!