CTP 147 - PL-SQL Programming

3 credit hours - Two hours of lecture and two hours of laboratory weekly; one term.
Formerly CSI 182 - PL-SQL Programming

Learn the principles of database programming using PL/SQL language to access and manipulate data in a database. Learn stored procedures, functions, packages and database triggers. Learn key skills required for declaring variables and trapping exceptions. This course is the second in the series of Oracle database administration courses.

Prerequisite(s): CTP 145 with a grade of C or better or permission of the CTP department chair.

Location(s) Typically Offered: Online (OL)

Term(s) Typically Offered: Fall

Course Outcomes:

Introduction to PL/SQL
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
Basic PL/SQL Blocks
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
Handling Data in PL/SQL
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Manipulate database tables using PL/SQL programming
- Use Oracle-supplied packages in PL/SQL program units
Cursors and Exceptions
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Manipulate database tables using PL/SQL programming
- Build error trapping facilities within PL/SQL programs
Procedures
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Manipulate database tables using PL/SQL programming
- Create PL/SQL program units including: procedures, functions, triggers, and packages
- Use Oracle-supplied packages in PL/SQL program units
Functions
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Manipulate database tables using PL/SQL programming
- Create PL/SQL program units including: procedures, functions, triggers, and packages
- Use Oracle-supplied packages in PL/SQL program units
Packages
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Manipulate database tables using PL/SQL programming
- Create PL/SQL program units including: procedures, functions, triggers, and packages
- Use Oracle-supplied packages in PL/SQL program units
Dependencies
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Create PL/SQL program units including: procedures, functions, triggers, and packages
- Use Oracle-supplied packages in PL/SQL program units
Triggers
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Manipulate database tables using PL/SQL programming
- Build error trapping facilities within PL/SQL programs
- Create PL/SQL program units including: procedures, functions, triggers, and packages
- Use Oracle-supplied packages in PL/SQL program units
SQL *Loader
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Load data into Oracle tables from external files using the SQL*Loader utility
Dynamic SQL
- Create PL/SQL program blocks
- Identify and use appropriate programming constructs to fulfill application logic needs
- Manipulate database tables using PL/SQL programming
- Identify uses of dynamic SQL and object technology