Oracle PL/SQL Instructor-led Training
Free server access, Class recordings, Certification guidance, Job & Interview assistance, Course Completion Certificate
Uplatz
Summary
- Uplatz Certificate of Completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
Oracle 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.
Versions supported 11gR2, 12cR2, 18c, 19c.
-------------------------------------------------------------------------------------------------------------------------------------
Who 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
To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.
-------------------------------------------------------------------------------------------------------------------------------------
This is a Oracle PL/SQL course by Uplatz.
Course media
Resources
- Oracle Pl/SQL tutor led course syllabus - download
Description
Oracle PL/SQL Training Course
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
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
Who is this course for?
Everyone
Requirements
None
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Uplatz Certificate of Completion
Digital certificate - Included
Course Completion Certificate by Uplatz
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.