CST 159 - Database Operations

1. Identify the parts of a Database table.
   1. Describe data formats in a table.
   2. Identify rows, columns, and cells.
   3. Describe key fields.
   4. Describe a Schema.
2. Manage objects
   1. Create Tables with the appropriate data types.
   2. Create Indexes.
   3. Create Views.
   4. Create Sequences.
   5. Display table structure.
   6. Discuss database backups.
3. Apply data integrity
   1. Implement referential integrity.
   2. Construct DELETE and UPDATE statements.
   3. Use constraints such as check, unique, not null.
   4. Create relationships.
4. Retrieve data using the SQL SELECT statement.
   1. Generate a report of data from the output of a basic SELECT statement.
   2. Employ arithmetic expressions and NULL values in a SELECT statement.
   3. Use column aliases.
5. Restrict and sort data.
   1. Write queries with a WHERE clause.
   2. Use comparison and logical operators.
   3. Sort the output retrieved from queries.
6. Use functions.
   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. Apply conversion functions to convert data types.
   6. Employ a GROUP BY clause.
   7. Use a HAVING clause.
7. Display data from multiple tables.
   1. SELECT data from more than one table. 
   2. Create outer joins.
   3. Create cross joins.
   4. Write sub-queries.
   5. Employ a self-join.​