PROG 140 SQL & Relational Database Programming • 5 Cr.
Students learn to apply relational database theory by creating databases, tables, views and indexes in a server environment. Focus is on developing complex SQL queries to retrieve meaningful information and on developing procedures to manipulate data. SQL server and related client tools are used in all work. Prerequisite: DBA 130 with a grade of C or better, and either PROG 108 or PROG 110 or PROG 111 with a grade of C or better.