Course Description

Designed for those seeking a comprehensive understanding of data analysis using SQL, this course covers the entire lifecycle of a data analysis project. You will learn to formulate queries, manipulate data, and leverage various SQL functions for in-depth analysis. The course also covers data cleaning, optimization, and presenting results, providing a holistic approach to end-to-end data analysis with SQL. By the end of the course, you will be well-equipped to tackle real-world data challenges and draw meaningful conclusions from diverse datasets.

What You'll Learn

  • 1

    Course Overview

    • Welcome

    • Course Overview

    • Installing DB Browser
  • 2

    End-to-End Data Analysis with SQL

    • Reporting with SQL

    • Transforming Data for Reports: Calculated Columns

    • Transforming Data for Reports: CASE WHEN

    • Practice: Transforming Data for Reports

    • Creating Your Own SQL Report

    • Comprehensive SQL Exercise
  • 3

    Wrap Up

    • Course Summary

    • Share your feedback with us!

    • Congratulations!

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.

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

Keep Learning with Lighthouse Labs

Ready to advance your data skills? Take the next step with our Data Science and Data Analytics programs and courses.

Become a data expert

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.