CPTR2260 - Advanced Structured Query Language
Students will build upon the skills learned in the Structured Query Language (SQL) class. This course takes on more advanced but common operations such as joins and sub-queries, unions and intersections. Additional topics will include the use of stored procedures and views and appropriate use of these features, proper indexing of data, altering table definitions and use of the CASE statement.
- Demonstrate the JOIN statements (Inner/Outer, Right/Left).
- Explain usages of UNION, EXCEPT and INTERSECT statements.
- Create, use and manage database views.
- Create and utilize database stored procedures.
- Demonstrate an awareness of SQL injection.
- Create, use and manage database temporary tables.
- Perform tasks using an ALTER TABLE statement.
- Generate SQL statements using indexes.
- Construct subqueries.
- Write SQL statements using a CASE statement.