SQL Fundamentals

SQL Fundamentals Filtering via WHERE Exercise

This course has been updated! We now recommend you take the Complete Intro to SQL & PostgreSQL course.

Check out a free preview of the full SQL Fundamentals course:
The "Filtering via WHERE Exercise" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:

In this exercise, students show how to add WHERE clauses to the collection query for two pages on the app. On the products list page, students allow the user to filter by those products that need to be reordered, discontinued, or display the full list. On the customer list page, students add a rudimentary search field and use a LIKE clause to find matching rows.

Get Unlimited Access Now