Making and Querying Databases in SQL with DuckDB

Want to work with structured data more efficiently? SQL (Structured Query Language) is a powerful tool for managing and analyzing data and it’s easier to get started than you might think.

This beginner-friendly workshop introduces SQL using DuckDB, a lightweight, cross-platform database that runs locally and requires no setup. Through hands-on practice, you’ll learn how to create a database, add data to it, and write queries to find the information you need.

By the end of this session, participants will be able to:

• Understand the basic structure and purpose of SQL
• Create and populate a DuckDB database
• Write and run basic SQL queries to explore and extract data

This session is ideal for beginners in data analysis, researchers, and students who want a gentle introduction to databases using a simple and powerful tool. No prior experience required!

Details: Any preparatory work for the session can be found on its information page. This virtual workshop will be recorded and shared on the same page, and discoverable via the Sherman Centre's Online Learning Catalogue.

Facilitator Bio: 

John Fink is the Digital Scholarship Librarian in the Sherman Centre.