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.
After completing this class, students should be able to:
- 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