Filtering data: The WHERE clause and subqueries

  • Module
  • 5 Units
Beginner
Database Administrator
Developer
Azure Database for PostgreSQL

This module introduces the WHERE clause and subqueries in SQL. You learn how to filter data, combine conditions and use functions like EXTRACT, NOW() and CAST.

Learning objectives

By the end of this module, you'll be able to:

  • Filter data using the WHERE clause
  • Combine conditions and use functions like EXTRACT, NOW(), and CAST
  • Use subqueries to feed one query into another
  • Apply subqueries in SELECT, FROM, WHERE, and UPDATE statements

Prerequisites

Before starting this module, you should have a basic understanding of SQL SELECT statement.

Start