{"id":3402,"date":"2025-08-26T09:33:24","date_gmt":"2025-08-26T12:33:24","guid":{"rendered":"https:\/\/ccdhhn.ca\/?post_type=tribe_events&#038;p=3402"},"modified":"2025-08-26T09:33:45","modified_gmt":"2025-08-26T12:33:45","slug":"making-and-querying-databases-in-sql-with-duckdb","status":"publish","type":"tribe_events","link":"https:\/\/ccdhhn.ca\/fr\/workshop\/making-and-querying-databases-in-sql-with-duckdb\/","title":{"rendered":"Making and Querying Databases in SQL with DuckDB"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/09\/SCDS-logo-1024x576.png\" alt=\"\" class=\"wp-image-2621\" srcset=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/09\/SCDS-logo-1024x576.png 1024w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/09\/SCDS-logo-300x169.png 300w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/09\/SCDS-logo-768x432.png 768w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/09\/SCDS-logo-1536x864.png 1536w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2024\/09\/SCDS-logo.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div  class=\"tribe-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Event Language<\/h3>\n\tEnglish<\/div>\n\n\n<div  class=\"tribe-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Format <\/h3>\n\tvirtual\/virtuel<\/div>\n\n\n<div  class=\"tribe-events-single-section tribe-events-section-category tribe-clearfix\" >\n\t<dt class=\"tribe-events-event-categories-label\">Cat\u00e9gorie d\u2019\u00c9v\u00e8nement:<\/dt> <dd class=\"tribe-events-event-categories\"><a href=\"https:\/\/ccdhhn.ca\/workshops\/category\/1-4-hour-workshop\/\" rel=\"tag\">1-4 hour workshop<\/a><\/dd><\/div>\n\n\n\n<p>Date: November 26 2025<\/p>\n\n\n\n<p>Want to work with structured data more efficiently? SQL (Structured Query Language) is a powerful tool for managing and analyzing data and it\u2019s easier to get started than you might think.<\/p>\n\n\n\n<p>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\u2019ll learn how to create a database, add data to it, and write queries to find the information you need.<\/p>\n\n\n\n<p>By the end of this session, participants will be able to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Understand the basic structure and purpose of SQL<\/li>\n\n\n\n<li>Create and populate a DuckDB database<\/li>\n\n\n\n<li>Write and run basic SQL queries to explore and extract data<\/li>\n<\/ul>\n\n\n\n<p>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!<\/p>\n\n\n\n<p><strong>Details:<\/strong>&nbsp;Any preparatory work for the session can be found on its&nbsp;<a href=\"https:\/\/learn.scds.ca\/dmds25-26\/sql-duckdb.html\">information page<\/a>.&nbsp;This virtual workshop will be recorded and shared on the same page, and discoverable via the Sherman Centre&rsquo;s&nbsp;<a href=\"https:\/\/scds.ca\/searchable-online-learning\/\">Online Learning Catalogue.<\/a><\/p>\n\n\n\n<p><strong>Facilitator Bio:<\/strong>&nbsp;John Fink is the Digital Scholarship Librarian in the Sherman Centre.<\/p>\n\n\n\n<p><strong>Certificate Eligibility:<\/strong>&nbsp;This workshop is eligible for the Sherman Centre&rsquo;s certificate program. For more information, visit&nbsp;<a href=\"http:\/\/scds.ca\/certificate-program\">scds.ca\/certificate-program<\/a>. It is also eligible for the Canadian Certificate for Digital Humanities. To learn more, visit&nbsp;<a href=\"http:\/\/ccdhhn.ca\/\">ccdhhn.ca<\/a>&nbsp;or contact&nbsp;<a href=\"mailto:scds@mcmaster.ca\">scds@mcmaster.ca<\/a>.<\/p>\n\n\n\n<p><strong>Credit Eligibility:&nbsp;<\/strong>This workshop counts toward credit for students in the Faculty of Science who are enrolled in SCIENCE 2SF1: Digital Skills Workshop. For any questions, please contact&nbsp;<a href=\"mailto:oursci@mcmaster.ca\">oursci@mcmaster.ca<\/a>.<\/p>\n\n\n<div  class=\"tribe-block tribe-block__event-website\" >\n\t<a\n\t\thref=\"https:\/\/libcal.mcmaster.ca\/event\/3920907\"\n\t\ttarget=\"_self\"\n\t\t\t>\n\t\tLink to event\t<\/a>\n<\/div>\n\n\n<div  class=\"tribe-block tribe-block__organizer__details tribe-clearfix\" >\n\t<div class=\"tribe-block__organizer__title\">\n\t\t<h3><a href=\"https:\/\/ccdhhn.ca\/fr\/organisateur\/sherman-centre-for-digital-scholarship\/\" title=\"Sherman Centre for Digital Scholarship\" target=\"_self\" rel=\"\">Sherman Centre for Digital Scholarship<\/a><\/h3>\n\t<\/div>\n\t\t\t\t<p class=\"tribe-block__organizer__website\"><a href=\"https:\/\/scds.ca\/\" target=\"_blank\" rel=\"noopener noreferrer\">View Organisateur Website<\/a><\/p>\n\t\t<\/div>\n\n\n<div  class=\"tribe-block tribe-block__venue tribe-clearfix\" >\n\t\n\t\t\n\t<\/div>\n\n\n\t<div  class=\"tribe-block tribe-block__events-link\" >\n\t\t<div class=\"tribe-events tribe-common\">\n\t\t\t<div class=\"tribe-events-c-subscribe-dropdown__container\">\n\t\t\t\t<div class=\"tribe-events-c-subscribe-dropdown\">\n\t\t\t\t\t<div class=\"tribe-common-c-btn-border tribe-events-c-subscribe-dropdown__button\">\n\t\t\t\t\t\t<svg\n\t class=\"tribe-common-c-svgicon tribe-common-c-svgicon--cal-export tribe-events-c-subscribe-dropdown__export-icon\" \taria-hidden=\"true\"\n\tviewBox=\"0 0 23 17\"\n\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n>\n\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M.128.896V16.13c0 .211.145.383.323.383h15.354c.179 0 .323-.172.323-.383V.896c0-.212-.144-.383-.323-.383H.451C.273.513.128.684.128.896Zm16 6.742h-.901V4.679H1.009v10.729h14.218v-3.336h.901V7.638ZM1.01 1.614h14.218v2.058H1.009V1.614Z\" \/>\n\t<path d=\"M20.5 9.846H8.312M18.524 6.953l2.89 2.909-2.855 2.855\" stroke-width=\"1.2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"\/>\n<\/svg>\n\t\t\t\t\t\t<button\n\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__button-text\"\n\t\t\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\t\t\taria-controls=\"tribe-events-subscribe-dropdown-content\"\n\t\t\t\t\t\t\taria-label=\"View links to add events to your calendar\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\tAjouter au calendrier\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\t<svg\n\t class=\"tribe-common-c-svgicon tribe-common-c-svgicon--caret-down tribe-events-c-subscribe-dropdown__button-icon\" \taria-hidden=\"true\"\n\tviewBox=\"0 0 10 7\"\n\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n>\n\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M1.008.609L5 4.6 8.992.61l.958.958L5 6.517.05 1.566l.958-.958z\" class=\"tribe-common-c-svgicon__svg-fill\"\/>\n<\/svg>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"tribe-events-subscribe-dropdown-content\" class=\"tribe-events-c-subscribe-dropdown__content\">\n\t\t\t\t\t\t<ul class=\"tribe-events-c-subscribe-dropdown__list\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--gcal\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"https:\/\/www.google.com\/calendar\/event?action=TEMPLATE&#038;dates=20251126T000000\/20251126T235959&#038;text=Making%20and%20Querying%20Databases%20in%20SQL%20with%20DuckDB&#038;details=%3Cfigure+class%3D%22wp-block-image+size-large%22%3E%3Cimg+src%3D%22https%3A%2F%2Fccdhhn.ca%2Fwp-content%2Fuploads%2F2024%2F09%2FSCDS-logo-1024x576.png%22+alt%3D%22%22+class%3D%22wp-image-2621%22%2F%3E%3C%2Ffigure%3E%3Cp%3EDate%3A+November+26+2025%3C%2Fp%3E+%3Cp%3EWant+to+work+with+structured+data+more+efficiently%3F+SQL+%28Structured+Query+Language%29+is+a+powerful+tool+for+managing+and+analyzing+data+and+it%E2%80%99s+easier+to+get+started+than+you+might+think.%3C%2Fp%3E+%3Cp%3EThis+beginner-friendly+workshop+introduces+SQL+using+DuckDB%2C+a+lightweight%2C+cross-platform+database+that+runs+locally+and+requires+no+setup.+Through+hands-on+practice%2C+you%E2%80%99ll+learn+how+to+create+a+database%2C+add+data+to+it%2C+and+write+queries+to+find+the+information+you+need.%3C%2Fp%3E+%3Cp%3EBy+the+end+of+this+session%2C+participants+will+be+able+to%3A%3C%2Fp%3E+%3Cul+class%3D%22wp-block-list%22%3E%3Cli%3EUnderstand+the+basic+structure+and+purpose+of+SQL%3C%2Fli%3E%3Cli%3ECreate+and+populate+a+DuckDB+database%3C%2Fli%3E%3Cli%3EWrite+and+run+basic+SQL+queries+to+explore+and+extract+data%3C%2Fli%3E%3C%2Ful%3E%3Cp%3EThis+session+%3C%2Fp%3E+%28View+Full+%C3%A9v%C3%A8nement+Description+Here%3A+https%3A%2F%2Fccdhhn.ca%2Ffr%2Fworkshop%2Fmaking-and-querying-databases-in-sql-with-duckdb%2F%29&#038;trp=false&#038;ctz=America\/Halifax&#038;sprop=website:https:\/\/ccdhhn.ca\/fr\/\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tGoogle Agenda\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--ical\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tiCalendar\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--outlook-365\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tOutlook 365\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"tribe-events-c-subscribe-dropdown__list-item tribe-events-c-subscribe-dropdown__list-item--outlook-live\">\n\t\t\t\t\t\t\t\t\t<a\n\t\t\t\t\t\t\t\t\t\thref=\"\"\n\t\t\t\t\t\t\t\t\t\tclass=\"tribe-events-c-subscribe-dropdown__list-item-link\"\n\t\t\t\t\t\t\t\t\t\ttarget=\"_blank\"\n\t\t\t\t\t\t\t\t\t\trel=\"noopener noreferrer nofollow noindex\"\n\t\t\t\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\tOutlook Live\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Date: November 26 2025 Want to work with structured data more efficiently? SQL (Structured Query Language) is a powerful tool for managing and analyzing data and it\u2019s easier to get [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":2621,"template":"","meta":{"_tec_requires_first_save":false,"_EventAllDay":true,"_EventTimezone":"America\/Halifax","_EventStartDate":"2025-11-26 00:00:00","_EventEndDate":"2025-11-26 23:59:59","_EventStartDateUTC":"2025-11-26 04:00:00","_EventEndDateUTC":"2025-11-27 03:59:59","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"https:\/\/libcal.mcmaster.ca\/event\/3920907","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"$","_EventCurrencyCode":"CAD","_EventCurrencyPosition":"prefix","_EventDateTimeSeparator":" @ ","_EventTimeRangeSeparator":" - ","_EventOrganizerID":[1054],"_EventVenueID":[],"_OrganizerEmail":"","_OrganizerPhone":"","_OrganizerWebsite":"","_VenueAddress":"","_VenueCity":"","_VenueCountry":"","_VenueProvince":"","_VenueState":"","_VenueZip":"","_VenuePhone":"","_VenueURL":"","_VenueStateProvince":"","_VenueLat":"","_VenueLng":"","_VenueShowMap":false,"_VenueShowMapLink":false,"_tribe_blocks_recurrence_rules":"","_tribe_blocks_recurrence_description":"","_tribe_blocks_recurrence_exclusions":"","_ecp_custom_2":"English","_ecp_custom_3":"virtual\/virtuel","_tribe_events_status":"","_tribe_events_status_reason":"","_tribe_events_is_hybrid":"","_tribe_events_is_virtual":"","_tribe_events_virtual_video_source":"","_tribe_events_virtual_embed_video":"","_tribe_events_virtual_linked_button_text":"","_tribe_events_virtual_linked_button":"","_tribe_events_virtual_show_embed_at":"","_tribe_events_virtual_show_embed_to":[],"_tribe_events_virtual_show_on_event":"","_tribe_events_virtual_show_on_views":"","_tribe_events_virtual_url":"","footnotes":""},"tags":[],"tribe_events_cat":[3],"class_list":["post-3402","tribe_events","type-tribe_events","status-publish","has-post-thumbnail","hentry","tribe_events_cat-1-4-hour-workshop","cat_1-4-hour-workshop"],"_links":{"self":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":1,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3402\/revisions"}],"predecessor-version":[{"id":3403,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3402\/revisions\/3403"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media\/2621"}],"wp:attachment":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media?parent=3402"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tags?post=3402"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events_cat?post=3402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}