CIS 332 - Database and SQL

1. Create executable SQL statements to perform single-table queries
   1. Apply filtering, sorting, aliases, and computed columns
   2. Use comparison operators and search conditions
2. Manage database structure
   1. Apply transaction control commands
   2. Use data definition language (DDL) commands
   3. Apply appropriate data integrity techniques to ensure accuracy 
   4. Use data manipulation language (DML) to insert, update, and delete data
   5. Utilize a sequence to generate and insert values into a table
   6. Apply transaction control commands to ensure data consistency 
3. Evaluate database security issues
   1. Apply GRANT and REVOKE for access control
   2. Utilize roles and privileges in a database
4. Construct multiple-table queries using inner-, outer-, and self-joins
   1. Utilize table aliases to simply the process of qualifying columns
   2. Employ set operators such as union, intersect, and minus 
5. Produce SQL functions and aggregation
   1. Utilize single-row functions
   2. Apply group functions
   3. Nest functions
6. Implement subqueries and advanced query techniques
   1. Implement single-row and multi-row subqueries
   2. Formulate a multiple-column subquery
   3. Handle NULL values
   4. Nest subqueries
7. Follow code standards, naming conventions, documentation practices, and testing strategies
   1. Access database information using the data dictionary
   2. Develop strategies for testing and verifying SQL statements