DEV140 — 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. Course