PL/SQL by Example - Beginner to Advanced PL/SQL

• Declare PL/SQL Variables
• Conditionally control code flow (loops, control structures)
• Use some of the Oracle supplied PL/SQL packages to generate screen output
• Create anonymous PL/SQL blocks, functions and procedures
• Use PL/SQL packages to group and contain related constructs
• Catch run time errors using Exceptions
• Perform Data processing using Records and Cursors
• Manage data using Collections
• Create triggers to solve business challenges
• Peform Bulk Processing to improve performance
• Execute SQL using Dynamic SQL
• Pipelining the data as it is processed
• Working with Large Objects (LOB's)

Learn to become a PL/SQL developer in just four weeks.

This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.

PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.

In this course participants will learn

• Describe the features and syntax of PL/SQL
• Design PL/SQL anonymous blocks that execute efficiently
• Use the Oracle supplied PL/SQL packages to generate screen output
• Create and debug Stored Procedures and Functions
• Design PL/SQL packages to group related constructs
• Use PL/SQL programming constructs and conditionally control code flow
• Create overloaded package subprograms for more flexibility
• Handle runtime errors using Exceptions
• Writing manageable code using Records
• Storing and processing data using Collections
• Processing data using Implicit and Explicit Cursors

Softwares used

• Oracle Database 11g
• SQL Developer