Course Description

Get introduced to the complexities of working with multiple tables in a relational database through JOIN operations. This course will explore different types of JOINs,  including INNER JOIN, LEFT JOIN, and RIGHT JOIN, enabling you to combine data from various tables seamlessly. Practical examples and hands-on exercises provide a solid foundation for navigating relationships between tables and extracting comprehensive information from interconnected datasets.

What You'll Learn

  • 1

    Course Overview

    • Welcome

    • Optional: Tell Us About Yourself

    • Course Overview

    • DB Browser

  • 2

    Multiple Tables and Introduction to JOINs

    • Introduction to Database Relationships

    • Quiz: Understanding Database Relationships

    • One-to-One Relationships

    • One-to-Many Relationships

    • Many-to-Many Relationships

    • Quiz: Database Relationships

    • Introduction to JOINs

    • Practice: INNER JOIN

    • NULL Values with INNER JOIN

    • Practice: NULL Values with INNER JOIN

    • LEFT and RIGHT JOINs

    • Practice: LEFT and RIGHT JOINs

    • FULL OUTER JOIN

    • Quiz: FULL OUTER JOIN

  • 3

    Wrap Up

    • Course Summary

    • Share your feedback with us!

    • Congratulations and the Next Steps

Why Should You Learn SQL?

In demand: Acquiring a highly sought-after skill can make you a more competitive candidate in the job market and open doors to various positions across industries.

  • In demand: Acquiring a highly sought-after skill can make you a more competitive candidate in the job market and open doors to various positions across industries.

  • Versatile: SQL is a universal skill applicable in various roles, allowing you to explore different career paths within the data domain.

  • Just the beginning: SQL is a foundational skill that can serve as a stepping stone for further exploration into advanced data analysis and database management technologies.

Meet Your Instructor

Instructor, Lighthouse Labs

Warren Uhrich

Having spent a decade in the industry, Warren discovered his passion for mentoring and teaching junior developers, which led him to a fulfilling career as an instructor. With a love for programming and a desire to share his knowledge, he went on to write the University of Alberta’s Full Stack Web Development Diploma and certificate programs. Now, Warren works full-time with Lighthouse Labs to train the next generation of tech enthusiasts!

The SQL Essentials course bundle is being offered at no cost as part of the ICT Boost Initiative. Funded by the Government of Canada’s Sectoral Workforce Solutions Program.