Jul 22, 2024  
2023-24 Catalog 
2023-24 Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

DEV 140 - Database Theory and SQL Programming

5 CR

Previously PROG 140.
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

Add to Favorites (opens a new window)