Title
CPTR2230 - Structured Query Language
Description
Description
This course covers the basics of SQL (Structured Query Language) programming. SQL is a popular computer language used by small and large business organizations and computer programmers. The primary purpose of SQL is in working with databases and relational database management systems to store, retrieve, edit, manipulate and format data for end users and decision makers.
API ID
Credits
3 (2/1/0)
Competencies
- Create a subquery in an SQL statement.
- Join multiple tables in an SQL query utilizing the WHERE clause.
- Create group restrictions utilizing the GROUP BY and HAVING command in an SQL query.
- Utilize the COUNT, SUM, MAX and MIN statistical functions in an SQL query.
- Specify query selection criteria utilizing the FROM and WHERE clauses.
- Correct data errors and delete records in a table utilizing the UPDATE and DELETE commands.
- View data in a table utilizing the SELECT command.
- Specify the INSERT command in SQL to load data into tables.
- Specify data types in SQL.
- Utilize the CREATE TABLE and DROP TABLE SQL commands.
- Use the ORDER BY command and DESC operator to sort results in an SQL query.
- Describe integrity constraints and support.
- Specify compound conditions in an SQL select query.
- Utilize comparison operators in an SQL select query.
Degrees that use this course
Degrees that use this course
Degree:
Associate of Applied Science (AAS)
Location:
Moorhead Campus
Online
Credits:
60
Degree:
Associate of Applied Science (AAS)
Location:
Moorhead Campus
Online
Credits:
60
