Selecting and Filtering Data with SQL
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Course Overview
Course Overview
In this lesson, we introduce the core material covered in the course.
SELECT Statements
SELECT Statements
In this lesson, we learn about different ways of selecting data such as using aliases and SELECT DISTINCT.
Basic WHERE Clauses
Basic WHERE Clauses
This lesson introduces the WHERE clause which can be used to apply filters to your data.
AND & OR Operators
AND & OR Operators
This lesson covers the AND & OR operators which can be used to combine multiple filters at a time.
IN & BETWEEN Operators
IN & BETWEEN Operators
This lesson demonstrates how to use the IN and BETWEEN operators to filter out data that's not contained within a predefined range of values.
LIKE Operator
LIKE Operator
In this lesson, we use the LIKE operator to filter text data on whether or not it contains a specific substring.
NOT Operator
NOT Operator
In this lesson, we use the NOT operator to inverse our filters.
CASE Conditions
CASE Conditions
In this lesson, we learn how to use the CASE function to create a new column of data whose makeup is defined by a set of predefined conditions.
Subqueries and Common Table Expressions
Subqueries and Common Table Expressions
In this lesson, we learn how to nest a SQL query within another SQL query and how this can help us make our queries more dynamic and quicker to write.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
