Title

CPTR2230 - Structured Query Language

API ID

Credits

3 (2/1/0)

Description

This course covers the basics of SQL (Structured Query Language) programming. SQL is a popular computer language that is 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.
Prerequisites

Competencies

  1. Create a subquery in a SQL statement.
  2. Join multiple tables in a SQL query utilizing the WHERE clause.
  3. Create group restrictions utilizing the GROUP BY and HAVING command in a SQL query.
  4. Utilize the COUNT, SUM, MAX, and MIN statistical functions in a SQL query.
  5. Specify query selection criteria utilizing the FROM and WHERE clauses.
  6. Correct data errors and delete records in a table utilizing the UPDATE and DELETE commands.
  7. View data in a table utilizing the SELECT command.
  8. Specify the INSERT command in SQL to load data into tables.
  9. Specify data types in SQL.
  10. Utilize the CREATE TABLE and DROP TABLE SQL commands.
  11. Use the ORDER BY command and DESC operator to sort results in a SQL query.
  12. Describe integrity constraints and support.
  13. Specify compound conditions in a SQL select query.
  14. Utilize comparison operators in a SQL select query.
Degrees that use this course

Degrees that use this course

Computer Programming
Degree:
Associate of Applied Science (AAS)
Location:
Moorhead Campus
Online
Credits:
60
Cybersecurity
Degree:
Associate of Applied Science (AAS)
Location:
Moorhead Campus
Online
Credits:
60