Course Description
An advanced course in the use of the PL/SQL programming language. Create and manage PL/SQL program units and data structures. Develop stored procedures and functions, database triggers, and packages to process data using database objects.
Student Learning Outcomes
After successful completion of this course, students will be able to:
- Outcome 1: Develop and test PL/SQL routines including packages, functions, procedures, and triggers using procedural code
- Outcome 2: Develop and test PL/SQL routines that use programming techniques with database tables, including cursors, error handling using predefined and user-defined exceptions, transaction management, and dynamic SQL
- Outcome 3: Design and use composite data types: user-defined records and the PL/SQL collection types
- Outcome 4: Design and develop PL/SQL routines that include the XML native type, including converting between XML format of data and relational format of data
Textbook
Steven Feuerstein; Oracle PL/SQL Programming 6th edition; O'Reilly Press; ISBN 978-1-449-32445-2
ISBN: 978-0-07-179935-5. Available at the bookstore and on many online booksellers in print and ebook versions.
