Please enable JavaScript to view this page.

Introduction to Structured Query Language

CST 258

Introduction to Structured Query Language

CST 258

Course Description

Prerequisite: CST 257. Examines SQL (Structured Query Language) which is the standard database language. Creates, updates, and retrieves information from relational databases. (15-0)

Outcomes and Objectives

Identify the parts of a Database table.

Objectives:

  • Describe data formats in a table.
  • Identify rows, columns, and cells.
  • Describe primary keys.
  • Demonstrate table designs in Access and Oracle.
  • Create tables with the proper data types.
  • Manipulate primary keys especially adding and changing.

Retrieve information from a table.

Objectives:

  • Use the "Select" statement.
  • Use the "Where" clause.
  • Implement the "order by" clause.

Apply the proper syntax for various SQL commands.

Objectives:

  • Define and use compound where clauses.
  • Define and use not, in, between, like and is null.
  • Express proper SQL syntax rules.
  • Use constant values.
  • Perform proper syntax punctuation and case sensitivity.

Save results.

Objectives:

  • Create a new table from the results of the Select statement.
  • Create a new view from the results of Select statement.
  • Describe similarities and differences between tables and views.
  • Manage the modifying of tables.
  • Add, expand, and delete columns and rows.

Manipulate data in tables.

Objectives:

  • Change data through a view.
  • Set column formats using SQL Plus.
  • Use a spool file.
  • Define and implement a data dictionary.
  • Locate tables, views, and primary keys.

Define and apply data integrity.

Objectives:

  • Implement and discuss the concept of referential integrity.
  • Implement and discuss delete and update rules.
  • Implement and discuss constraints such as check, unique, not null.
  • Perform functions dealing with numbers, text and date.
  • Perform data joins from two tables.
  • Describe the relationships-one to one, many to one, many to many and unmatched.
  • Describe outer joins and inner joins.