Consulting Training Blog Careers About Us Contact Us

Oracle PL/SQL Training

Upcoming Classes

Sorry, nothing scheduled right now. Click the Get Notified button below to be alerted when a class is scheduled.

Get Notified

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us

Description

PL/SQL is Oracle's extension language for standard SQL.

In this PL/SQL training class, students will Increase the productivity, performance, scalability, portability, and security of your Oracle database with this comprehensive PL/SQL programming course. With this training, you learn to write PL/SQL programs, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.

Bring This Course To You

For groups of 5 or more, let Intertech bring this course to your location. Customized versions tailored towards your objectives are also available.

Learn More

Prerequisites

SQL Programming language experience; Oracle Database 12c: Introduction

Course Outline

Lesson 1 : Introduction and Overview

  • PL/SQL fundamentals 
  • Oracle 11g and 12c PL/SQL features

Lesson 2 : Data Manipulation Techniques

  • Maintaining data with DML statements 
  • Managing data retrieval with cursors 
  • Cursor variables

Lesson 3 : Developing Well-Structured and Error-Free Code

  • Error handling using EXCEPTIONs 
  • Debugging PL/SQL blocks

Lesson 4 : Achieving Maximum Reusability

  • Writing stored procedures and functions
  • Coding user-written functions 
  • Developing safe triggers

Lesson 5 : Exploiting Complex Datatypes

  • Collection types 
  • Bulk binding for high performance

Lesson 6 : Invoking Native Dynamic SQL

  • Finessing the compiler 
  • Types of dynamic SQL

Lesson 7 : Package Tips and Techniques

  • Package structure: SPEC and BODY 
  • Eliminating dependency problems 
  • Overloading for polymorphic effects 
  • Evaluating application frameworks 
  • Declaring and using persistent global variables

Free Resources from Intertech

2 Free Resources: Missed Issues in Software Estimation and Stakeholder Questionnaire

Free Recorded Webinar: Changes with SSIS 2012/2014

Free Whitepaper: Eclipse Content Assist Activation with VS IntelliSense Behavior

X