Consulting Training Blog Careers About Us Contact Us
All Classes Will Be Held Virtually – Live Online Intertech's Training Division has been successfully instructing professionals through virtual live online training since the advent of the smartboard. It is a proven form and offers the convenience of live questions, group interaction, and labs with an instructor looking over your shoulder. Because of this, we will continue all classes live but virtually, including Agile and Scrum instruction, so businesses and individual’s seeking professional development can keep moving forward during these unexpected times.

Oracle PL/SQL Training

Upcoming Classes

Click the Get Notified button for priority notification when a class is next 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 eBook: Introducing Microsoft SQL Server 2014

X