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(s): 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.

Course Outcomes

Interpret requests for business data and information
Write basic and complex SQL queries to retrieve and modify data in a database
Demonstrate good database design
Create and modify SQL views and scripts
Create and execute user-defined functions, SQL stored procedures, and triggers
Access system views and system stored procedures
Use tools and techniques to optimize query performance
Manage security permissions for users and roles

Find out when this course is offered