CIST 1220 Syllabus

Subject Code

CIST

Course Number

1220

Course Title

Structured Query Language (SQL)

Prerequisites

CIST 1001 with a grade of C or higher, CIST 1305 with a grade of C or higher

Corequisites

Terms Offered

Credit Hours

Course Description

This course introduces basic database design concepts and instruction on solving database retrieval and modification problems using the SQL language. Topics include database vocabulary, relational database design, date retrieval using SQL, data modification using SQL, and developing and using SQL procedures.

Course Outcomes

Database Vocabulary

  • Define and use vocabulary of databases, including tables, columns, rows, data types, keys, relationships, queries, and record sets.

Relational Database Design

  • Describe the relational database model.
  • Describe one-to-one, one-to-many, and many-to-many relations.
  • Explain the difference between the various normal forms.
  • Apply normalization to the third normal form for various data specifications.

Data Retrieval Using SQL

  • Produce information from a database using SQL.
  • se the appropriate SQL constructs to restrict the items retrieved based on specified criteria.
  • Prepare queries that reference more than one table in order to supply required information.
  • Produce queries that group information, use aggregate functions, and restrict output based on aggregate results.
  • Develop queries that determine the items to select based on the result of another embedded query.

Data Modification Using SQL

  • Use SQL commands to update information in the database based on some criteria.
  • Prepare SQL commands to insert new records into the database.
  • Construct SQL commands to delete records from the database based on some criterial.

Developing and Using SQL Procedures

  • Define SQL Stored Procedures and SQL Triggers.
  • Produce simple SQL stored procedures.
  • Use simple SQL trigger procedures.