Course Description

This course focuses on the powerful capabilities of aggregating data in SQL. You will learn to analyze and summarize data using aggregate functions such as SUM, AVG, COUNT, and GROUP BY. You will gain hands-on experience in deriving meaningful insights from large datasets through real-world scenarios and practical exercises.

What You'll Learn

  • 1

    Course Overview

    • Welcome

    • Optional: Tell Us About Yourself

    • Course Overview

    • Installing DB Browser

  • 2

    Aggregating Data in SQL

    • Aggregate Functions

    • Practice: Aggregate Functions

    • Aggregate Functions with Multiple Columns

    • Practice: Aggregate Functions with Multiple Columns

    • GROUP BY Clause

    • Practice: GROUP BY Clause

    • HAVING Clause

    • Practice: HAVING Clause

  • 3

    Wrap Up

    • Course Summary

    • Share your feedback with us!

    • Congratulations and the Next Steps

Why Should You Learn SQL?

In today's data-driven world, having a versatile skill like SQL can open the door to various opportunities. By developing the ability to work efficiently with databases, manipulate data effortlessly, and extract valuable insights, you can improve your career outlook. Whether you have a passion for data, want to become an analyst, or work in business, mastering SQL can significantly impact your professional journey.

  • 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.

  • It's 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!

Related Courses

Want to keep learning? Try out these courses to take your SQL skills to the next level.

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.