This Oracle Database: Develop PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Program Units in this powerful programming language.
On successful Completion of this course you will be able to:
Describe stored procedures and functions
Create, use and debug stored procedures and functions
Design and use PL/SQL packages to group and contain related constructs
Create overloaded package subprograms for greater flexibility
Use Oracle supplied PL/SQL packages to generate console and file output
Write dynamic SQL for more coding flexibility
Create Triggers
Manage dependencies between PL/SQL subprograms
Course Requirements
Prerequisites
Required Prerequisites
Basic knowledge of database concepts, including relational database management systems (RDBMS).
Familiarity with data processing concepts and techniques.
Oracle Database: Introduction to SQL (combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II listed)
Oracle Database: SQL Fundamentals I
Suggested Prerequisites
Previous programming experience