{"id":3026,"date":"2025-01-24T15:00:01","date_gmt":"2025-01-24T19:00:01","guid":{"rendered":"https:\/\/ccdhhn.ca\/?post_type=tribe_events&#038;p=3026"},"modified":"2025-01-27T11:26:29","modified_gmt":"2025-01-27T15:26:29","slug":"introduction-to-databases-for-humanist-data","status":"publish","type":"tribe_events","link":"https:\/\/ccdhhn.ca\/fr\/workshop\/introduction-to-databases-for-humanist-data\/","title":{"rendered":"Introduction to Databases for Humanist Data"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"907\" height=\"287\" src=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2025\/01\/DHSI-East-website-banner.png\" alt=\"\" class=\"wp-image-3054\" srcset=\"https:\/\/ccdhhn.ca\/wp-content\/uploads\/2025\/01\/DHSI-East-website-banner.png 907w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2025\/01\/DHSI-East-website-banner-300x95.png 300w, https:\/\/ccdhhn.ca\/wp-content\/uploads\/2025\/01\/DHSI-East-website-banner-768x243.png 768w\" sizes=\"auto, (max-width: 907px) 100vw, 907px\" \/><\/figure>\n\n\n\n<p>Dr. Jon Bath, Associate Professor of Art and Art History, University of Saskatchewan<\/p>\n\n\n\n<p>Max Participants: 12<\/p>\n\n\n\n<p>This course will introduce the use of relational databases for the analysis of humanities data. We will begin by examining why a database might be an appropriate tool for your project and then move on to how to model, or structure, your data in a database. Finally we will learn how to query, or ask questions, of your data set. Throughout this process we will be using MySQL, a free, open-source relational database tool, and learning the basics of Structured Query Language (SQL). No previous experience with databases or programming is required, and you should feel free to bring your own data in whatever form it currently is.<\/p>\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-events-schedule tribe-clearfix\" >\n\t<p class=\"tribe-events-schedule__datetime\">\n\t\t<span class=\"tribe-events-schedule__date tribe-events-schedule__date--start\">\n\t\t\tmai 5, 2025\t\t<\/span>\n\n\t\t\n\t\t\t\t\t\t\t\t\t<span class=\"tribe-events-schedule__separator tribe-events-schedule__separator--time\">\n\t\t\t\t\t &#8211; \t\t\t\t<\/span>\n\t\t\t\n\t\t\t\t\t\t\t<span class=\"tribe-events-schedule__date tribe-events-schedule__date--end\">\n\t\t\t\t\tmai 8, 2025\t\t\t\t<\/span>\n\n\t\t\t\t\n\t\t\t\n\t\t\t\t\t\t<\/p>\n<\/div>\n\n\n<div  class=\"tribe-block tribe-block__additional-field tribe-block__additional-field__dropdown\" >\n\t<h3>Format <\/h3>\n\tin person\/face-\u00e0-face<\/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\/20-hour-workshop\/\" rel=\"tag\">20+ hour workshop<\/a><\/dd><\/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\/stfx-digital-humanities-centre\/\" title=\"StFX Digital Humanities Centre\" target=\"_self\" rel=\"\">StFX Digital Humanities Centre<\/a><\/h3>\n\t<\/div>\n\t\t\t\t<p class=\"tribe-block__organizer__website\"><a href=\"https:\/\/www.mystfx.ca\/digital-humanities\/\" 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 tribe-block__venue--has-map\" >\n\t\n\t\n<div class=\"tribe-block__venue__meta\">\n\t<div class=\"tribe-block__venue__name\">\n\t\t<h3><a href=\"https:\/\/ccdhhn.ca\/fr\/lieu\/st-francis-xavier-university\/\" title=\"St Francis Xavier University\">St Francis Xavier University<\/a><\/h3>\n\t<\/div>\n\n\t\n\t\t\t\t\t\t<address class=\"tribe-block__venue__address\">\n\t\t\t\t<span class=\"tribe-address\">\n\n<span class=\"tribe-street-address\">4130 University Ave<\/span>\n\t\n\t\t<br>\n\t\t<span class=\"tribe-locality\">Antigonish<\/span><span class=\"tribe-delimiter\">,<\/span>\n\n\t<abbr class=\"tribe-region tribe-events-abbr\" title=\"Nova Scotia\">Nova Scotia<\/abbr>\n\n\t<span class=\"tribe-postal-code\">B2G 2W5<\/span>\n\n\t<span class=\"tribe-country-name\">Canada<\/span>\n\n<\/span>\n\n\t\t\t\t\t\t\t\t\t<a class=\"tribe-events-gmap\" href=\"https:\/\/www.google.com\/maps\/search\/?api=1&#038;query=45.617725033365%2C-61.995403645836\" title=\"Cliquez pour voir une carte Google Maps\" target=\"_blank\" rel=\"noreferrer noopener\">+ Google Map<\/a>\t\t\t\t\t\t\t<\/address>\n\t\t\n\t\t\n\t\t\t\n\t<\/div>\n\t\n<div class=\"tribe-block__venue__map\">\n\t\n<iframe loading=\"lazy\"\n  title=\"Google maps iframe displaying the address to St Francis Xavier University\"\n  aria-label=\"Venue location map\"\n  width=\"310px\"\n  height=\"256px\"\n  frameborder=\"0\" style=\"border:0\"\n  src=\"https:\/\/www.google.com\/maps\/embed\/v1\/place?key=AIzaSyDNsicAsP6-VuGtAb1O9riI3oc_NOb7IOU&#038;q=4130+University+Ave+Antigonish+Nova+Scotia+B2G+2W5+Canada+&#038;zoom=10\" allowfullscreen>\n<\/iframe>\n<\/div>\n\n\t<\/div>\n\n\n<div  class=\"tribe-block tribe-block__event-website\" >\n\t<a\n\t\thref=\"https:\/\/www.stfx.ca\/research\/digital-humanities\/dhsi-east\"\n\t\ttarget=\"_self\"\n\t\t\t>\n\t\tWebsite &amp; Registration\t<\/a>\n<\/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=20250505T000000\/20250508T235959&#038;text=Introduction%20to%20Databases%20for%20Humanist%20Data&#038;details=%3Cfigure+class%3D%22wp-block-image+size-full%22%3E%3Cimg+src%3D%22https%3A%2F%2Fccdhhn.ca%2Fwp-content%2Fuploads%2F2025%2F01%2FDHSI-East-website-banner.png%22+alt%3D%22%22+class%3D%22wp-image-3054%22%2F%3E%3C%2Ffigure%3E%3Cp%3EDr.+Jon+Bath%2C+Associate+Professor+of+Art+and+Art+History%2C+University+of+Saskatchewan%3C%2Fp%3E+%3Cp%3EMax+Participants%3A+12%3C%2Fp%3E+%3Cp%3EThis+course+will+introduce+the+use+of+relational+databases+for+the+analysis+of+humanities+data.+We+will+begin+by+examining+why+a+database+might+be+an+appropriate+tool+for+your+project+and+then+move+on+to+how+to+model%2C+or+structure%2C+your+data+in+a+database.+Finally+we+will+learn+how+to+query%2C+or+ask+questions%2C+of+your+data+set.+Throughout+this+process+we+will+be+using+MySQL%2C+a+free%2C+open-source+relational+database+tool%2C+and+learning+the+basics+of+Structured+Query+Language+%28SQL%29.+No+previous+experience+with+databases+or+programming+is+required%2C+and+you+should+feel+free+to+bring+your+own+data+in+whatever+form+it+currently+is.%3C%2Fp%3E+&#038;location=St%20Francis%20Xavier%20University,%204130%20University%20Ave,%20Antigonish,%20Nova%20Scotia,%20B2G%202W5,%20Canada&#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>Dr. Jon Bath, Associate Professor of Art and Art History, University of Saskatchewan Max Participants: 12 This course will introduce the use of relational databases for the analysis of humanities [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3021,"template":"","meta":{"_tec_requires_first_save":false,"_EventAllDay":true,"_EventTimezone":"America\/Halifax","_EventStartDate":"2025-05-05 00:00:00","_EventEndDate":"2025-05-08 23:59:59","_EventStartDateUTC":"2025-05-05 03:00:00","_EventEndDateUTC":"2025-05-09 02:59:59","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"https:\/\/www.stfx.ca\/research\/digital-humanities\/dhsi-east","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"$","_EventCurrencyCode":"CAD","_EventCurrencyPosition":"prefix","_EventDateTimeSeparator":" @ ","_EventTimeRangeSeparator":" - ","_EventOrganizerID":[47],"_EventVenueID":[334],"_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":"in person\/face-\u00e0-face","_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":[6],"class_list":["post-3026","tribe_events","type-tribe_events","status-publish","has-post-thumbnail","hentry","tribe_events_cat-20-hour-workshop","cat_20-hour-workshop"],"_links":{"self":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3026","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\/2"}],"version-history":[{"count":2,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3026\/revisions"}],"predecessor-version":[{"id":3057,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events\/3026\/revisions\/3057"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media\/3021"}],"wp:attachment":[{"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/media?parent=3026"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tags?post=3026"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/ccdhhn.ca\/fr\/wp-json\/wp\/v2\/tribe_events_cat?post=3026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}