HOME
 

Oracle PL/SQL

STL
Course summary
Length: 2 days
Language: English
Location: Nationwide
Provider: STL plus
Course type: Company-Specific / In-House

Oracle PL/SQL



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... By the end of this course, delegates will be able to:

Create and execute PL/SQL scripts from SQL*Plus / SQL Developer
Work with variables and constants
Work with values
Use SQL statements
Use conditional logic
Create loops
Use cursors
Handle errors and exceptions
Implement nested loops and blocks
Raise exceptions
Work with PL/SQL tables and records
Use native functions

Suitability - Who should attend?



This course is suitable for database administrators, software developers, network administrators and support staff who require PL/SQL to enhance their ability to manipulate data.

Training Course Content



Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: PL/SQL FUNDAMENTALS

Overview of PL/SQL
Introduction
Variables and Constants
Defining data types
Initialising variables
Assigning values to variables
Using SQL statements
Outputting to SQL or SQL Developer

Session 2: PROGRAM LOGIC

Decision logic:
- IF THEN ELSIF ELSE statements
- CASE Statements
Basic loop structures
WHILE loops and FOR loops
Labelled and nested loops
Using the GOTO Statement
Using the CONTINUE Statement

Session 3: USING CURSORS

Overview of Cursors
Implicit versus explicit Cursors
Types of Cursor operations
Declaring, Opening and Closing Cursors
Getting rows
Checking status
Updating using Cursors
Working with the Cursor FOR loop
Cursors and parameters

Session 4: EXCEPTIONS AND NESTED BLOCKS

Exception types
Handling named Exceptions
Handling Un-named Exceptions
User-defined Exceptions
Application-driven Errors
Using WHEN OTHERS THEN NULL statement
Labelled and nested blocks
Repeating exceptions
Variables scope and Cursor scope
GOTO statement scope

Session 5: PL/SQL RECORDS AND INDEX-BY TABLES

Record types declarations
Working with PL/SQL records
Nested records
Declaring PL/SQL Index
-By Tables
-By Associative Arrays
Using native PL/SQL functions
Manipulating PL/SQL Tables
Manipulating Associative Arrays

Expenses



Prices from £3000 (Guideline pricing). Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Oracle PL/SQL.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Oracle PL/SQL course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here