SQL Fundamentals SQL Fundamentals

Filtering via WHERE Exercise

This course is out of date and does not reflect our quality standards.

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