Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Oracle PL/SQL Programming Training Class

2016 by Burleson Corporation

 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

 

   
Key Features

* Learn the basics of PL/SQL.

* Understand PL/SQL tables and arrays.

* Understand how to implement PL/SQL structures.

* Create Dynamic SQL in PL/SQL.

* See when to use Nested blocks in PL/SQL.

* Use Stored procedures, functions and packages in PL/SQL.

* See Iteration  and looping in PL/SQL.

* Program complex Boolean logic in PL/SQL

* Learn ref cursors

* See how to use the bulk collect and forall operators.

 

  

Course Description

The BC PL/SQL programming training is an intense course that is designed to give the student hands-on exposure to Oracle PL/SQL.  The student learns by coding, and this class has dozens of in-class exercises and the student will be guided from very simple PL/SQL programs to increasingly complex PL/SQL coding techniques.

The topics start with the basics of PL/SQL and progress into increasingly complex programmatic structures including array manipulation cursor management and bulking operations.  The PL/SQL training class begins with simple concepts and the student gradually masters PL/SQL through increasingly challenging classroom exercises.

Book Required

  Easy Oracle PL/SQL Programming:


ISBN 0-9759135-7-3

 
  Oracle PL/SQL Tuning
Expert Secrets for High Performance Programming

Dr. Tim Hall

ISBN 0-9761573-9-X

Audience

This course is designed for practicing Oracle professionals who have basic experience with SQL and the use of a relational database. Prior experience with Oracle PL/SQL is not required, but experience using Oracle or any other relational database is highly desirable.

Curriculum Design

This PL/SQL training course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle PL/SQL training.

Learning Objectives

By the end of this course the student will be able to write simple and advanced PL/SQL code blocks, and will be able to use advanced features such as ref cursors and bulk fetches. The student will also become familiar with the internals of Oracle9i PL/SQL and will be able to compile PL/SQL for super-fast performance.

Note:  This is a custom PL/SQL class that can be for 3, 4 or 5 days in duration.  The class is customized according to your specific needs, and you choose from a variety of lessons.  For more advanced PL/SQL training, please see our PL/SQL Performance Tuning Training Course



 

Oracle PL/SQL Programming and Tuning
Syllabus

© 2016 by Donald K. Burleson

 

Basics of PL/SQL

  • PL/SQL architecture
  • PL/SQL and SQL*Plus
  • PL/SQL Basics, Variables, Constants, data types & error handling
  • PL/SQL wrapper utility

PL/SQL structures 

  • Simple blocks
  • Control structures
  • PL/SQL records
  • Recognizing the Basic PL/SQL Block and Its Sections
  • Describing the Significance of Variables in PL/SQL
  • Distinguishing Between PL/SQL and Non-PL/SQL Variables
  • Declaring Variables and Constants
  • Executing a PL/SQL Block

Error checking – exception handling

  • Defining exceptions
  • Using the when others clause
  • Ensuring complete error checking
  • Passing error messages to calling routine

Boolean logic in PL/SQL

  • Identifying the Uses and Types of Control Structures
  • Constructing an IF Statement
  • Constructing and Identifying Different Loop Statements
  • Controlling Block Flow Using Nested Loops and Labels
  • Using Logic Tables
  • If-then-else structure
  • Testing for numbers characters and Booleans

Cursors in PL/SQL

  • Cursor basics
  • Using a cursor for a multi-row SQL query

Iteration in PL/SQL

  • For loop
  • While loop

 

 

PL/SQL tables

  • Defining PL/SQL tables
  • Reasons to use PL/SQL tables
  • Populating a PL/SQL table
  • Retrieving from a PL/SQL table

Dynamic SQL in PL/SQL 

  • Introduction to the dbms_sql package
  • Creating a dynamic SQL statement

Nested blocks in PL/SQL

  • Creating nested blocks
  • Understanding scope in nested blocks

Triggers in PL/SQL

  • Triggers and database events
  • Defining a trigger
  • Timing a trigger
  • Enabling and disabling a trigger

Stored procedures, functions and packages

  • Basics of stored procedures
  • Basics of functions
  • Basics of packages
  • Defining stored procedures & functions
  • Function and stored procedures prototypes
  • Passing arguments to functions and stored procedures
  • Recompiling functions and stored procedures
  • Pinning packages in the SGA with dbms_shared_pool.keep
  • Package forward declaration
  • Package dependency
  • Package overloading
  • Listing package information

Bulking in PL/SQL

  • Bulk queries
  • Bulk DML (forall statement)
  • Using cursor attributes
  • Analyzing impact of bulk operations

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.