Oracle PL/SQL
- Course Code OPI
- Duration 2 days
Course Delivery
Additional Payment Options
-
GTC 15 inc. VAT
GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details
Jump to:
Course Delivery
This course is available in the following formats:
-
Company Event
Event at company
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopOracle PL/SQL Course Overview
The Oracle PL/SQL course is designed to introduce Oracle DBAs,software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 12cR2,18c and 19c.
Course Schedule
Top-
- Delivery Format: Virtual Learning
- Date: 16-17 May, 2024
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 20-21 May, 2024
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 13-14 June, 2024
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 11-12 July, 2024
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 22-23 July, 2024
- Location: Virtual
-
- Delivery Format: Virtual Learning
- Date: 08-09 August, 2024
- Location: Virtual
Target Audience
TopWho will the Course Benefit?
Oracle database administrators,software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.
Course Objectives
TopCourse Objectives
To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.
Course Content
TopOracle PL/SQL Training Course
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: PL/SQL FUNDAMENTALS
- What is PL/SQL?
- Basic Elements
- Variables and Constants
- Data Types
- Initialising Variables and Assigning Values
- Using SQL Statements in Code
- Generating Output to SQL or SQL Developer
Session 2: PROGRAM LOGIC
- IF THEN ELSIF ELSE Statements
- CASE Statements
- The Basic Loop Construct
- WHILE and FOR Loops
- Nested and Labelled Loops
- The GOTO Statement
- The CONTINUE Statement
Session 3: USING CURSORS
- What is a Cursor?
- Implicit and Explicit Cursors
- Cursor Operations
- Declaring,Opening and Closing Cursors
- Fetching Rows
- Status Checking
- Using Cursors FOR UPDATE
- The Cursor FOR Loop
- Parameterised Cursors
Oracle PL/SQL Training Course
Course Contents - DAY 2
Session 4: EXCEPTIONS AND NESTED BLOCKS
- The EXCEPTION Section
- Types of Exception
- Handling Named System-Raised Exceptions
- Handling Un-named System-Raised Exceptions
- User-Declared Exceptions and Application Errors
- WHEN OTHERS THEN NULL
- Nested and Labelled Blocks
- Propagation of Exceptions
- Scope of Variables and Cursors
- Scope of Goto Statements
Session 5: PL/SQL RECORDS AND INDEX-BY TABLES
- Declaring Record Types
- Handling PL/SQL Records
- Nested Records
- Declaring PL/SQL Index-By Tables or Associative Arrays
- PL/SQL Table Built-in Functions
- Manipulating PL/SQL Tables or Associative Arrays
Course Prerequisites
TopRequirements
A working knowledge of SQL*Plus or SQL Developer and Oracle SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite course. Some previous programming experience will also prove advantageous.
Follow on Courses
TopFurther Learning
- Oracle PL/SQL Stored Program Units
- Oracle Database 19c Administration
- STA_OPI
- Oracle PL/SQL
- Database Management & Development
- STA_OPI | Oracle PL/SQL | Training Course | Oracle.
- Oracle