Oracle Database 12c: PL/SQL I - Introduction Training
CLASS DATE(s):
Request a Class

COURSE LENGTH: 3 Days

COURSE COST: $1995.00

COURSE TIMES: 9:00am - 1:00pm

Printable version of this course
print

COURSE OVERVIEW

This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming course series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.

PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.

AUDIENCE AND PREREQUISITES

The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:

  • Application designers and database developers
  • Database administrators
  • Web server administrators

PREREQUISITE COURSES  

*Course Cost listed does not include the cost of the courseware. For more information or if you have any questions, please contact us (learn@vtec.org or 207-775-0244). This course is subject to a minimum enrollment to run. If the mimimum enrollment is not met than this class can run as an virtual instructor led course.

COURSE TOPICS:


Module 1: Selection & Setup Of The Database Interface
Considering Available Tools
Selecting The Appropriate Tool
Oracle NET Database Connections
Oracle PAAS Database Connections
Setup SQL Developer
Setup SQL*PLUS
Setup JDeveloper

Module 2:
Using SQL Developer
Using SQL*PLUS

Module 3: Choosing A Database Programming Language
What Is Database Programming?
PL/SQL Performance Advantages
Integration With Other Languages PL/SQL Language Fundamentals
PL/SQL Program Structure
Language Syntax Rules
Embedding SQL
Writing Readable Code
Generating Database Output
SQL*PLUS Input Of A Program Block

Module 4: DECLARE Section
About The DECLARE Section
DECLARE Primitive Types
Declaration Options
NOT NULL
CONSTANT
Data Dictionary Integration
%TYPE
Declare Simple User-­-Defined Types
TYPE ... TABLE
TYPE ... RECORD
Extended User-­-Defined Types

Module 5: BEGIN Section
About The BEGIN Section
Manipulating Program Data
Logic Control & Branching
GOTO
LOOP
IF-­-THEN-­-ELSE
CASE

Module 6: Exception Section
About The EXCEPTION Section
Isolating The Specific EXCEPTION
PRAGMA EXCEPTION_INIT
SQLCODE & SQLERRM Example
SQL%ROWCOUNT & SELECT...INTO Beyond The Basics:

Module 7: Explicit Cursors
About Explicit Cursors
Extended Cursor Techniques
FOR UPDATE OF Clause
WHERE CURRENT OF Clause
Using FOR…LOOP Cursors

Module 8: Beyond The Basics: Nested Blocks

Module 9: Beyond The Basics: DECLARED Subprograms
Using DECLARED Subprograms
DECLARED Procedure
DECLARED Function