CTS 2433 - SQL Database Design & Programming

College of Computer & Information Technology

Credit(s): 3
Contact Hours: 47
Effective Term Fall 2020 (580)

Requisites

Prerequisite COP 1000 with a minimum grade of C

Course Description

This course is designed to familiarize students with SQL (Structured Query Language) in a relational database environment to include database programming and development. A series of database application assignments using SQL commands is designed to promote competency in ER (Entity Relationship) database modeling, database creation, database programming, and database optimization. The objective is to build a working knowledge and hands-on understanding of SQL.

Learning Outcomes and Objectives

  1. The student will contrast the differences between a relational database and other types by:
    1. defining associated database terms such as entity, attribute, and relationship.
    2. explaining functional dependence and identifying when one column is functionally dependent on another.
    3. using a primary key to link tables.
    4. performing the database normalization process through third normal form.
    5. creating an Entity Relationship Diagram (ERD) to represent the design of a database.
  2. The student will demonstrate the use of Data Definition Language skills in SQL by:
    1. executing existing scripts to create tables in a database system.
    2. creating objects manually using SQL commands in a database system.
    3. defining the different datatypes used in a relational database.
    4. modifying the structure of existing database tables.
  3. The student will demonstrate the use of Data Manipulation Language skills in SQL by:
    1. creating single table queries to retrieve data.
    2. creating multiple table queries using joins to retrieve data.
    3. modifying existing data using the update, insert, and delete commands.
    4. creating indexes, triggers, and constraints within the relational database.
  4. The student will perform database administration tasks by:
    1. using Data Control Language to grant and revoke users’ database privileges.
    2. using Transaction Control Language commands to finalize, reverse, and save database transactions.
  5. The student will interact with SQL using a programming language by:
    1. using functions in SQL queries.
    2. embedding SQL commands in Procedure Language extensions to Structured Query Language (PL/SQL) and Transact Structured Query Language (T-SQL) procedures.
    3. using cursors to retrieve multiple rows in embedded SQL.
    4. managing errors in procedures containing embedded SQL commands.

Criteria Performance Standard

Upon successful completion of the course the student will, with a minimum of 70% accuracy, demonstrate mastery of each of the above stated objectives through classroom measures developed by individual course instructors.

History of Changes

Course was submitted to SCNS as CGS 2001 but came back as CTS 2433. Created in CurricUNET originally under CGS 2ZZZ with J. Wise as Originator. Updated to S. Setterlind with correct prefix and no. 5/8/13 C&I Approval: 05/31/2013, BOT Approval: 08/05/2013, Effective Term: Spring 2014 (480).
C&I Approval: 02/21/2020, BOT Approval: 03/17/2020, Effective Term: Fall 2020 (580)

Related Programs

  1. Business Analyst Specialist (ANLST-ATC) (625) (Active)
  2. Cloud Computing Technology (CLOUD-AS) (640) (Active)
  3. Computer Programmer (CMPRG-CT) (580) (Active)
  4. Computer Programming and Analysis (CWPA-AS) (640) (Draft)
  5. Computer Programming and Analysis (CWPA-AS) (640) (Active)
  6. Computer Programming Specialist (CPS-CT) (580) (Active)
  7. Data Science (DATSCI-AS) (640) (Active)
  8. Technology Development & Management (TMGT-TR) (670) (Active)
  9. Web Development (WEBSDM-AS) (670) (Active)
  10. Web Development (WEBSDM-AS) (640) (Draft)