Skip to main content
SQL Essentials

Selecting and Filtering Data with SQL

When dealing with large, unwieldy datasets, it can be difficult to sift through the data to get relevant information. In this course, you will explore how, with a few simple commands, you can use SQL to arrange, modify and filter the data in your database to extract the results you need.

Beginner        9Lessons        90 Minutes        CPD Credits
Start Today

About This Course

You’ve been introduced to some of the basic components of SQL. In this course, you will explore how these components can be combined to construct complex but incredibly useful queries to extract exactly what you need from your database.

You will be introduced to some of SQL’s basic commands like SELECT DISTINCT, before experimenting with more complex conditional operators like IF, AND and LIKE. You will touch on some advanced techniques like nesting queries within other queries.

By the end of this course, you will have the tools necessary to arrange the data in your database. You will have written your own SQL queries of varying degrees of complexity and will feel confident applying these techniques to your own databases.

Start Today

Learning Outcomes

  • Select data from a table
  • Filter data
  • Modify filters with operators such as IF & AND
  • Make subqueries
  • Create common table expressions (CTE)


1. Course Overview
2. SELECT Statements
3. Basic WHERE Clauses
4. AND & OR Operators
5. IN & BETWEEN Operators
6. LIKE Operator

Read More

7. NOT Operator
8. CASE Conditions
9. Subqueries and Common Table Expressions
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world