Course Outlines

You are in the Academics section


CPTR2260 – Advanced Structured Query Language pdf

Credits: 3 (2/1/0)
Description: 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.
Prerequisites: CPTR2230
Corequisites: (None)
  1. Demonstrate the JOIN statements (Inner/Outer, Right/Left).
  2. Explain usages of UNION, EXCEPT and INTERSECT statements.
  3. Create, use and manage database views.
  4. Create and utilize database stored procedures.
  5. Demonstrate an awareness of SQL injection.
  6. Create, use and manage database temporary tables.
  7. Perform tasks using an ALTER TABLE statement.
  8. Generate SQL statements using indexes.
  9. Construct subqueries.
  10. Write SQL statements using a CASE statement.
MnTC goal areas: (N/A)

« back to course outlines