SLOs

Week 04: April 6–10¶

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

1. Sort query results by multiple columns using ORDER BY.

2. Explain how NULL values behave in sorted results.

3. Describe how data types affect sort order.

4. Limit and paginate results using LIMIT and OFFSET.

5. Write calculated columns in a SELECT clause using arithmetic and expressions.

6. Handle NULL values in calculations using functions like COALESCE and NULLIF.

7. Apply arithmetic operators (+, -, *, /, %) inside queries.

8. Use numeric functions such as ROUND, FLOOR, and CEIL to transform values.

9. Use datetime functions to extract and manipulate date and time data.

10. Use string functions such as UPPER, TRIM, and SUBSTR to transform text.

11. Write a basic subquery nested inside a SELECT or WHERE clause.

12. Use a CASE expression to return conditional values within a query.

13. Convert between data types using CAST.

14. Create a reusable VIEW using CREATE VIEW.