Course Overview on PLSQL

Structured Query Language (SQL) is the most popular language used for querying relational databases. SQL supports a number of advanced features that make your queries more intelligent and efficient and take a lot of the work away from the middle ware.

This course is specifically only for Oracle PL/SQL, please contact us.

What You Will Learn

In this course you will learn how to:

Use loops and branches in queries
Create user defined functions and stored procedures
Manage constraints and triggers
Control multiple simultaneous updates

Delivery Methods

Delivery Method	Duration
Classroom Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm. Classroom	2 days	Get a Quote
Live Virtual Training This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office. Live Virtual Training	2 days	Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Information may change without notice.

Audience

Database Administrators, Programmers.

Pre-Requisites

At least one months experience using SQL
Intermediate Microsoft Excel experience recommended

Course Outline / Curriculum

Sequences

CREATE SEQUENCE

Viewing

GET

DROP

Computed

Temporary

Derived

Procedural

Variables

Declaration

Assignment

Displaying

Concatenating

Scope

Using

Records

IF

Exercises

CASE

Using

Conditional

DECODE

NVL

NVL2

NULLIF

COALESCE

XML

XMLElement

XMLForest

XMLType

Window

OVER

Creating

ROW_NUMBER

LEAD

FIRST_VALUE

Loops

While

FOR

Loop

Cursors

User

Restrictions

Exercise

Stored

Parameters

Handling

Constraints

Adding

Triggers

Schedule Dates and Booking

There are currently no scheduled dates.

Add me to the waiting list

Submit Enquiry

Name

Email

Telephone

Query