Course Description

In this course, you'll learn how to filter and sort data using SQL queries. You'll gain expertise in creating accurate queries to extract particular information from databases, appreciate the significance of sorting results, and learn to use conditional statements efficiently. With the help of practical examples and hands-on exercises, you'll develop the skills to manipulate and retrieve data from a relational database.

What You'll Learn

  • 1

    Course Overview

    • Welcome

    • Course Overview

    • Installing DB Browser
  • 2

    Filtering and Sorting Data in SQL

    • SQL Syntax

    • Quiz: SQL Syntax

    • SELECT FROM

    • Practice: SELECT FROM

    • WHERE Clause

    • Comparison Operators

    • Practice: WHERE Clause and Comparison Operators

    • Logical Operators

    • Practice: Logical Operators

    • LIMIT Clause

    • Practice: LIMIT Clause

    • ORDER BY Clause

    • Practice: ORDER BY Clause
  • 3

    Wrap Up

    • Course Summary

    • Share your feedback with us!

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

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