The Develop PL/SQL Program Units Curriculum consists of the following courses:

Oracle PL/SQL: Procedures, Functions and Packages
PL/SQL: Database Programming

Course Overview

Learn To:

• Identify the types and components of a subprogram.
• Create a subprogram.
• Create and use packages.
• Identify the features of exceptions.
• Identify the directions and guidelines to handle exceptions.
• Write codes for trapping exceptions.
• Identify the process of propagating an exception.

Skills-Based

Audience

Application Developers, Database Administrators, and Tech Support Professionals. Participants should have knowledge equivalent to: Course 60111, Oracle SQL and SQL *Plus: Basic SELECT Statements; course 60112, Oracle SQL and SQL *Plus: DML and DDL; and, course 60113, Oracle PL/SQL: Basics.

Total Learning Time

7 - 8 Hour(s)

Course Contents

• Identify the definition and types of subprograms in PL/SQL.
• Identify the various components that make up a subprogram.
• Identify the steps to create a subprogram.
• Identify the modes and types of parameters in subprograms.
• Identify the syntax and guidelines for creating parameters in subprograms.
• Differentiate between the parameter modes in a subprogram.
• Differentiate between a procedure and a function.
• Identify the syntax and guidelines to create a procedure.
• Identify the syntax and guidelines to create a function.
• Identify the steps to invoke a procedure from Procedure Builder.
• Identify the steps to invoke a procedure from another procedure.
• Identify the syntax to create bind variables in Procedure Builder.
• Identify the steps to invoke a function from Procedure Builder.
• Identify the steps to start a debug session in the Interpreter component of Procedure Builder.
• Identify the steps to set a breakpoint, stepping through the code and determining the cause of errors in a debug session in Procedure Builder.
• Identify the place and method to examine and modify local variable values in a debug session in Procedure Builder.

• Identify the syntax to create a package specification.
• Identify the syntax to create a package body.
• Identify the features of a 'one time only' procedure or function.
• Identify the syntax to invoke package constructs and referencing global variables.
• Identify the persistent state of package variables.
• Identify the benefits and uses of Oracle-supplied database built-in packages.
• Identify the benefits and uses of Oracle-supplied Procedure Builder built-in packages.

• Identify the definition and features of exceptions and when they are raised.
• Identify the types of exceptions and how they are raised.
• Identify the syntax to trap exceptions in the exception handling section of a PL/SQL block.
• Identify the predefined Oracle exceptions and the steps to trap them.
• Identify the non-predefined Oracle exceptions and the steps to trap them.
• Identify the user-defined exceptions and the steps to raise and trap them.
• Identify built-in functions to identify unknown errors.
• Identifying the process Oracle uses to handle unhandled exceptions in different calling environments.
• Identify propagating rules in sub-blocks.

Course Overview

Learn To:

• Create subprograms and packages.
• Manage procedures and functions.
• Create triggers.

Skills-Based

Audience

Application Developers, Database Administrators, and Tech Support Professionals. Participants should have knowledge equivalent to: Course 60111, Oracle SQL and SQL *Plus: Basic SELECT Statements; course 60112, Oracle SQL and SQL *Plus: DML and DDL; course 60113, Oracle PL/SQL: Basics.

Total Learning Time

7 - 8 Hour(s)

Course Contents

• Identify the steps to create a stored procedure in SQL*Plus and in Procedure Builder.
• Identify the differences between storing code in the client versus the server.
• Identify the limitations of moving a program unit between the server and client.
• Identify the syntax to create stored procedures.
• Identify the syntax to create stored functions.
• Identify the syntax to create stored packages.
• Identify the syntax to execute stored procedures and functions.
• Identify the advantages of and guidelines for invoking stored functions in SQL statements.
• Identify the syntax to handle runtime exceptions in stored procedures and functions.
• Identify the Oracle built-in database packages.
• Identify the advantages and features of the DBMS_SQL built-in package.
• Identify the method and environments for debugging stored procedures and functions.

• Identify the steps and syntax to document stored procedures and functions
• Identify the methods of obtaining compile errors.
• Identify the syntax to control stored procedure and function security.
• Identify the methods to manage stored procedures and functions.
• Identify the definition of dependency and the effect of change on stored procedures and functions.
• Identify the types of dependencies and the methods to track them.
• Identify the guidelines for managing local dependencies explicitly.
• Identify the automatic remote dependency mechanism.
• Identify the sources and syntax for managing packages.
• Identify the features of dependencies with packages and the syntax to manage them.

• Identify the components and benefits of database triggers.
• Identify the definition and syntax of STATEMENT and ROW level triggers.
• Identify the rules for reading and writing data using triggers.
• Identify the features of applying database triggers.
• Identify the sources and syntax for managing database triggers.
• Identify the differences between database triggers and stored procedures.

Click here for Secure Yahoo Order: Develop PL/SQL Program Units Curriculum

Get Train in SQL
SQL Software Training

Best Regards,
Oracle Database, SQL, Application, Programming Tips