CST 159 - Database Operations

1. Retrieve data using the SQL SELECT statement.
   1. Generate a report of data from the output of a basic SELECT statement.
   2. Use arithmetic expressions and NULL values in a SELECT statement.
   3. Use column aliases.
   4. Display the table structure.
2. Restrict and sort data.
   1. Write queries with a WHERE clause to limit the output retrieved.
   2. Use comparison and logical operators.
   3. Use character string literals in the WHERE clause.
   4. Sort the output retrieved from queries.
   5. Use substitution variables.
3. Use single-row functions to customize output.
   1. Differentiate between single row and multiple row functions.
   2. Manipulate strings using character functions.
   3. Manipulate numbers with functions.
   4. Manipulate dates with date functions.
   5. Perform arithmetic with date data.
4. Use conversion functions and conditional expressions.
   1. Use conversion functions to convert data types.
   2. Nest multiple functions.
   3. Apply functions to NULL data.
   4. Use conditional decision/branching logic in a SELECT statement.
5. Report aggregated data using group functions.
   1. Use aggregation functions in SELECT statements to produce meaningful reports.
   2. Use arithmetic functions.
   3. Create queries that divide the data in groups by using a GROUP BY clause.
   4. Create queries that exclude groups of data by using a HAVING clause.
6. Display data from multiple tables.
   1. Write SELECT statements to access data from more than one table.
   2. View data that does not meet a join condition by using outer joins.
   3. Join a table by using a self-join.
   4. Create cross joins.
7. Use sub-queries to solve queries.
   1. Use a sub-query to solve a problem.
   2. Execute single-row sub queries.
   3. Aggregate data results with group functions in a sub-query.
   4. Use multiple-row sub-queries.