DEV 140 - Database Theory and SQL Programming

5 CR

This course develops an in-depth understanding of database concepts and relational database modeling using Structured Query Language (SQL). Students apply database theory to design, create, and manage databases, tables, views, indexes, stored procedures, and triggers in a server environment. Emphasis is placed on data modeling, normalization techniques, and writing SQL statements to safely manipulate and retrieve data in multi-user environments. Students explore how AI tools can assist in evaluating entity relationships, normalizing data structures, generating database designs, and optimizing query performance. Database server and related client tools are used throughout the course to respond to realistic business requirements for data and information.

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

Course Outcomes

Use relational database server and client tools to work with relational databases in a server environment.
Design and evaluate databases according to proper relational design principles and apply normalization techniques to ensure data integrity and efficient structure.
Create databases, tables, views, and indexes using SQL commands and write SQL statements to safely add, modify, and retrieve data in multi-user environments.
Write basic and complex SQL queries, stored procedures, and triggers to respond to realistic business requirements for data and information.
Use AI tools to generate, analyze, and refine database designs, entity relationships, and optimize SQL queries for improved performance and efficiency.

GenEd Outcomes: Creative and Critical Thinking

Quantitative/Symbolic Reasoning

Find out when this course is offered