SLOs

Week 03: March 30 – April 3¶

At the end of this week, you should be able to:

1. Handle NULL values in queries using IS NULL and IS NOT NULL.

2. Filter numeric data in a WHERE clause using comparison operators.

3. Filter string data in a WHERE clause, including considerations for case sensitivity.

4. Use string functions inside a WHERE clause to refine text-based filters.

5. Filter rows based on date and time values.

6. Combine multiple filter conditions using the logical operators AND, OR, and NOT.

7. Use the IN operator to match a column against a list of values.

8. Use LIKE and wildcard characters (%, _) to match patterns in string data.