This Oracle 11g PL/SQL Programming Part 1 online training course introduces you to PL/SQL and helps you understand the benefits of Oracle's proprietary database language. You will learn to create PL/SQL blocks of application code that can be shared by multiple users, forms, reports, and data management applications. In addition you will create anonymous PL/SQL blocks as well as named stored procedures, functions, packages and triggers. Also covered in this Oracle course is learning to develop, execute, and manage PL\SQL stored program units, subprograms, triggers, declaring identifiers and both user-defined and pre-defined exceptions. You will be introduced to the utilization of some of the more useful Oracle-supplied packages.
SQL and previous programming experience.
As a result of taking this Oracle PL/SQL training, you will be able to:
•Describe the features and syntax of PL/SQL
•Declare and use both scalar and complex datatypes
•Use PL/SQL constants and Boolean values
•Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
•Use CASE statement and expression
•Simple loop, While loop, For loop
•Handle runtime errors
•Use both pre-defined and user-defined exceptions
•Use the PRAGMA EXCEPTION_INIT clause
•Design and execute PL/SQL anonymous block
•Use the Oracle supplied PL/SQL packages to generate screen output
Oracle 10g/11g PL/SQL Programming Part 1 is part of a two-course online training series that helps you to prepare for one of the following exams: 1Z0-147 Program with PL/SQL or 1Z0-144 Oracle Database 11g: Program with PL/SQL. When you pass one of these exams, you have completed a portion of the requirements towards the Oracle PL/SQL Developer Certified Associate certification.
For more information about certification, requirements and fees, click on the link found in Related Links.