Catalog 2014-2015, Final Edition 
    
    Mar 29, 2024  
Catalog 2014-2015, Final Edition [ARCHIVED CATALOG]

CIS 244 - SQL PL/SQL

Credits: 3
Provides a detailed introduction to the Structured Query Language (SQL) as used in modern relational database systems. Students will develop skills in storing, retrieving and manipulating data using SQL as well as in defining database objects using the portion of SQL known as the Data Definition Language (DDL). The course will also provide a detailed introduction to the PL/SQL programming language that is integral to some widely-used relational database systems, such as Oracle. Students will learn to create and maintain blocks of PL/SQL code that are used and shared by multiple forms, reports and program libraries. Users will learn to implement database triggers and other coded structures applicable to client/server databases. Three credits.