Title
CPTR2260 - Advanced Structured Query Language
Description
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.
API ID
Credits
3 (2/1/0)
Prerequisites
Competencies
- 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.
Degrees that use this course
Degrees that use this course
Degree:
Associate of Applied Science (AAS)
This program provides the skills to support and maintain information technology (IT) systems. These skills include overall computer...
Location:
Moorhead Campus
Online
Credits:
60
