Course Introduction: Oracle PL/SQL Programming Part 1 ...

http://www.gogotraining.com, 1-877-546-4446
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.

Course Prerequisites:
SQL and previous programming experience.

Course Objectives:
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
•CONTINUE statement
•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

http://www.gogotraining.com, 1-877-546-4446