Oct 18, 2021  
2021 - 2022 Catalog 
    
2021 - 2022 Catalog
Add to Portfolio (opens a new window)

CST 159 - Database Operations

Credits: 3
Instructional Contact Hours: 3

Introduces the concepts of relational databases and the popular SQL language. Provides the essential skills that allow database operators to write queries against single and multiple tables, manipulate data in tables, and create database objects. Explains how to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. 

Prerequisite(s): CST 133W  or CST 134 or CST 155 (A grade of “C” or better must be earned.) 
Corequisite(s): None
Lecture Hours: 45 Lab Hours: 0
Meets MTA Requirement: None
Pass/NoCredit: Yes

Outcomes and Objectives  

  1. Identify the parts of a Database table.
    1. Describe data formats in a table.
    2. Identify rows, columns, and cells.
    3. Describe key fields.
    4. Describe a Schema.
  2. Manage objects
    1. Create Tables with the appropriate data types.
    2. Create Indexes.
    3. Create Views.
    4. Create Sequences.
    5. Display table structure.
    6. Discuss database backups.
  3. Apply data integrity
    1. Implement referential integrity.
    2. Construct DELETE and UPDATE statements.
    3. Use constraints such as check, unique, not null.
    4. Create relationships.
  4. Retrieve data using the SQL SELECT statement.
    1. Generate a report of data from the output of a basic SELECT statement.
    2. Employ arithmetic expressions and NULL values in a SELECT statement.
    3. Use column aliases.
  5. Restrict and sort data.
    1. Write queries with a WHERE clause.
    2. Use comparison and logical operators.
    3. Sort the output retrieved from queries.
  6. Use functions.
    1.  Differentiate between single row and multiple row functions.
    2. Manipulate strings using character functions.
    3. Manipulate numbers with functions.
    4. Manipulate dates with date functions.
    5. Apply conversion functions to convert data types.
    6. Employ a GROUP BY clause.
    7. Use a HAVING clause.
  7. Display data from multiple tables.
    1. SELECT data from more than one table. 
    2. Create outer joins.
    3. Create cross joins.
    4. Write sub-queries.
    5. Employ a self-join.​



Add to Portfolio (opens a new window)