{"id":4721,"date":"2026-09-23T11:01:18","date_gmt":"2026-09-23T14:01:18","guid":{"rendered":"https:\/\/ccdhhn.ca\/?post_type=tribe_events&p=4721"},"modified":"2026-09-23T11:01:42","modified_gmt":"2026-09-23T14:01:42","slug":"introduction-to-sql","status":"publish","type":"tribe_events","link":"https:\/\/ccdhhn.ca\/fr\/workshop\/introduction-to-sql\/","title":{"rendered":"Introduction to SQL"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n
\n\t

Event Language<\/h3>\n\tEnglish<\/div>\n\n\n
\n\t

Format <\/h3>\n\tvirtual\/virtuel<\/div>\n\n\n
\n\t
Cat\u00e9gorie d\u2019\u00c9v\u00e8nement:<\/dt>
1-4 hour workshop<\/a><\/dd><\/div>\n\n\n\n

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.<\/p>\n\n\n\n

Participants 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.<\/p>\n\n\n\n

By the end of the workshop, participants will be able to:<\/p>\n\n\n\n

    \n
  1. Explain basic relational database concepts, including tables, records, fields, and keys.<\/li>\n\n\n\n
  2. Navigate and use SQLite Online to create and run SQL queries.<\/li>\n\n\n\n
  3. Write basic SQL queries using SELECT and FROM.<\/li>\n\n\n\n
  4. Filter and sort data using WHERE and ORDER BY.<\/li>\n\n\n\n
  5. Use SQL functions to summarize and aggregate data, including COUNT, SUM, AVG, MIN, and MAX.<\/li>\n\n\n\n
  6. Group and summarize data using GROUP BY.<\/li>\n\n\n\n
  7. Combine information from multiple tables using basic JOIN operations.<\/li>\n\n\n\n
  8. Apply SQL queries to explore and extract information from structured datasets.<\/li>\n<\/ol>\n\n\n\n

    Details:<\/strong> Any preparatory work for the session can be found on its information page<\/a>. This virtual workshop will be recorded and shared on the same page, and discoverable via the Sherman Centre’s Online Learning Catalogue.<\/a><\/p>\n\n\n\n

    Instructors: John Fink and Vivek Jadon<\/p>\n\n\n

    \n\t\n\t\tLink to event\t<\/a>\n<\/div>\n\n\n
    \n\t
    \n\t\t

    Sherman Centre for Digital Scholarship<\/a><\/h3>\n\t<\/div>\n\t\t\t\t

    View Organisateur Website<\/a><\/p>\n\t\t<\/div>\n\n\n

    \n\t\n\t\t\n\t<\/div>\n\n\n\t
    \n\t\t
    \n\t\t\t