BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//CCDHHN - ECPv6.17.5//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:CCDHHN
X-ORIGINAL-URL:https://ccdhhn.ca
X-WR-CALDESC:Events for CCDHHN
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Halifax
BEGIN:DAYLIGHT
TZOFFSETFROM:-0400
TZOFFSETTO:-0300
TZNAME:ADT
DTSTART:20250309T060000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0300
TZOFFSETTO:-0400
TZNAME:AST
DTSTART:20251102T050000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0400
TZOFFSETTO:-0300
TZNAME:ADT
DTSTART:20260308T060000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0300
TZOFFSETTO:-0400
TZNAME:AST
DTSTART:20261101T050000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0400
TZOFFSETTO:-0300
TZNAME:ADT
DTSTART:20270314T060000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0300
TZOFFSETTO:-0400
TZNAME:AST
DTSTART:20271107T050000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Halifax:20261210T000000
DTEND;TZID=America/Halifax:20261210T235959
DTSTAMP:20260923T140142Z
CREATED:20260923T140118Z
LAST-MODIFIED:20260923T140142Z
UID:10000775-1796860800-1796947199@ccdhhn.ca
SUMMARY:Introduction to SQL
DESCRIPTION:Learn the fundamentals of Structured Query Language (SQL) through a hands-on introduction using SQLite Online\, a free\, browser-based environment that requires no software installation. This beginner-friendly workshop will introduce participants to the basic concepts of relational databases and provide practical experience writing and running SQL queries. \n\n\n\nParticipants will learn how to retrieve\, filter\, sort\, and summarize data using SQL and will work through examples using a sample database. The workshop will also introduce concepts such as tables\, fields\, records\, primary keys\, and relationships between tables. By the end of the session\, participants will have a foundation for using SQL to explore and analyze structured research data. \n\n\n\nBy the end of the workshop\, participants will be able to: \n\n\n\n\nExplain basic relational database concepts\, including tables\, records\, fields\, and keys.\n\n\n\nNavigate and use SQLite Online to create and run SQL queries.\n\n\n\nWrite basic SQL queries using SELECT and FROM.\n\n\n\nFilter and sort data using WHERE and ORDER BY.\n\n\n\nUse SQL functions to summarize and aggregate data\, including COUNT\, SUM\, AVG\, MIN\, and MAX.\n\n\n\nGroup and summarize data using GROUP BY.\n\n\n\nCombine information from multiple tables using basic JOIN operations.\n\n\n\nApply SQL queries to explore and extract information from structured datasets.\n\n\n\n\nDetails: 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. \n\n\n\nInstructors: John Fink and Vivek Jadon
URL:https://ccdhhn.ca/workshop/introduction-to-sql/
CATEGORIES:1-4 hour workshop
ATTACH;FMTTYPE=image/png:https://ccdhhn.ca/wp-content/uploads/2024/09/SCDS-logo.png
END:VEVENT
END:VCALENDAR