Arcus Skill Series on SQL
Slides, code, and other materials for the Arcus Education Skill Series workshop on SQL
Beyond the Spreadsheet: Understanding SQL and Relational Databases
Join Arcus Education for a series of workshops to learn about relational databases and how to use SQL to query databases effectively. SQL is a relational database solution that has been around for decades. In the first two workshops, learn more about this technology at a high level, without having to write code. In the last three workshops, practice writing simple code to build your skills. If you work with raw data that is stored in multiple tables and you want to go beyond the capabilities of a spreadsheet, you’ll want to attend these workshops. You’ll leave these webinars with access to training modules that will help you practice these skills and develop confidence.
This series is being offered a second time after a successful run in FY 24 (Fall 2023-Spring 2024)
Session 1 - Demystifying SQL
October 7, 2024 at 12 pm sign up link
October 15, 2024 at 4 pm sign up link
What is a database? What is Structured Query Language?
After completion of this module, learners will be able to:
- Define the acronym “SQL”
- Explain the basic organization of data in relational databases
- Explain what “relational” means in the phrase “relational database”
- Give an example of what kinds of tasks SQL is ideal for
Session Materials
- Watch a recording of the Nov 2023 Demystifying SQL workshop
- Review the Demystifying SQL slides
- Work through Demystifying SQL as an interactive tutorial
Session 2 - Database Normalization
October 21, 2024 at 12 pm sign up link
October 29, 2024 at 4 pm sign up link
Session Materials
- Watch a recording of the Dec 2023 Database Normalization workshop
- Review the Database Normalization slides
- Work through Database Normalization as an interactive tutorial
Session 3 - SQL Basics
November 4, 2024 at 12 pm sign up link
November 12, 2024 at 4 pm sign up link
Session Materials
- Watch a recording of the Jan 2024 SQL Basics workshop
- Review the SQL Basics slides
- Work through SQL Basics as an interactive tutorial
Session 4 - SQL Intermediate Level
November 18, 2024 at 12 pm sign up link
December 3, 2024 at 4 pm sign up link
Session Materials
- Watch a recording of the Feb 2024 SQL Intermediate Level workshop
- Review the SQL Intermediate Level slides
- Work through this content as an interactive tutorial
Session 5 - SQL Joins
December 9, 2024 at 12 pm sign up link
December 17, 2024 at 4 pm sign up link
Session Materials
- Watch a recording of the Mar 2024 SQL Joins workshop
- Review the SQL Joins slides
- Work through SQL Joins as an interactive tutorial