May 21, 2024  
2018 - 2019 Catalog 
2018 - 2019 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CST 258 - Introduction to Structured Query Language

Credits: 1
Examines SQL (Structured Query Language) which is the standard database language. Creates, updates, and retrieves information from relational databases.

Prerequisite(s): CST 257  
Corequisite(s): None
Lecture Hours: 15 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 primary keys.
    4. Demonstrate table designs in Access and Oracle.
    5. Create tables with the proper data types.
    6. Manipulate primary keys especially adding and changing.
  2. Retrieve information from a table.
    1. Use the “Select” statement.
    2. Use the “Where” clause.
    3. Implement the “order by” clause.
  3. Apply the proper syntax for various SQL commands.
    1. Define and use compound where clauses.
    2. Define and use not, in, between, like and is null.
    3. Express proper SQL syntax rules.
    4. Use constant values.
    5. Perform proper syntax punctuation and case sensitivity.
  4. Save results.
    1. Create a new table from the results of the Select statement.
    2. Create a new view from the results of Select statement.
    3. Describe similarities and differences between tables and views.
    4. Manage the modifying of tables.
    5. Add, expand, and delete columns and rows.
  5. Manipulate data in tables.
    1. Change data through a view.
    2. Set column formats using SQL Plus.
    3. Use a spool file.
    4. Define and implement a data dictionary.
    5. Locate tables, views, and primary keys.
  6. Define and apply data integrity.
    1. Implement and discuss the concept of referential integrity.
    2. Implement and discuss delete and update rules.
    3. Implement and discuss constraints such as check, unique, not null.
    4. Perform functions dealing with numbers, text and date.
    5. Perform data joins from two tables.
    6. Describe the relationships-one to one, many to one, many to many and unmatched.
    7. Describe outer joins and inner joins.

Add to Portfolio (opens a new window)