SLOs

Week 01: March 16-20¶

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

1. Write a basic SELECT statement to retrieve all columns from a table.

2. Write a SELECT statement that retrieves only specific columns from a table.

3. Create calculated columns in a SELECT statement and assign meaningful aliases using AS.

4. Filter rows in a query using a WHERE clause with various comparison and logical operators.

5. Sort query results in ascending and descending order using ORDER BY.

6. Eliminate duplicate rows from a result set using DISTINCT.

7. Write single-line (--) and multi-line (/* */) comments in SQL to document your queries.

8. Reflect on the role of Christians in the field of data management and how ethical considerations apply to working with databases.