PROG 140 - Database Theory and SQL Programming

5 CR

This course develops in-depth understanding of database concepts and terminology, emphasizing relational database modeling. Students will use Structured Query Language (SQL), data modeling, normalization of database tables and apply relational database theory to create databases, tables, views, indexes, stored procedures, and triggers in a server environment. SQL server and related client tools are used in all work.

Prerequisite(s): BUSIT 103 with a grade of C or higher or permission of instructor.

Course Outcomes

Define common database terminology such as entities, attributes and relationships.
Write SQL statements to manipulate data (DML SQL statements).
Write SQL statements to create and modify database objects (DDL SQL statements).
Use normalization to design database tables demonstrating logical database design.
Create and use Entity-Relationship modeling concepts and diagrams.
Create and execute views, user-defined functions, SQL stored procedures, and triggers.
Use tools and techniques to optimize query performance.
Manage security permissions for users and roles.

GenEd Outcomes: Creative and Critical Thinking

Quantitative/Symbolic Reasoning

Find out when this course is offered