Comprehensive Video Tutorials

Oracle PL/SQL Training

CareerVision Training

£ 72 - (86 )

Información importante

  • Curso
  • Online
  • Duración:
  • Cuándo:
    A elegir
  • Campus online

  The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Información importante
Instalaciones y fechas

Dónde se imparte y en qué fechas

Inicio Ubicación
A elegir

¿Qué aprendes en este curso?




 •  Format: DVD or Instant Download
 •  Duration: 7.5 Hours (74 lessons)
 •  Instructor: Lewis Cunningham
 •  Platform: Windows PC or Mac

In this training course by Lewis Cunningham on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database.  Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer.  With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.

Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more.  You will explore strings, numbers, booleans, and arrays.  From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects.  This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there!

By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases.  Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.

Benefits of this Software Training:
 •  Tuition by expert tutors.
 •  Narrated training videos demonstrate the key tools and professional techniques
        helping you to work faster and smarter.
 •  Learning is fast as the trainers guide you using simplistic terms and minimal jargon.
 •  Personal Tutoring - Step-by-step video training from your own desktop.
        Delivered via DVD/CD training or online tuition.
 •  The tutor transfers knowledge to you quickly and effectively.
 •  All the concepts of each application are explained clearly and precisely.
 •  Course works on PC and Mac.
 •  Alternative to a boring book or manual and expensive training courses,
        seminars and amp; classes.
 •  Jump to and from lessons - learn at your own pace.
 •  The visual and practical nature shortens the learning curve compared to standard
        training manuals.


The following sections are available for free viewing. Click on the links below to get started.

Free Videos From This Course Strings Numbers Date And Time Booleans Lobs Nested Tables Hello World Loops - Part 1 Inserting In PL/SQL Constructors NDS - Part 1

What Is PL/SQL
Course Expectations

An Overview Of PL/SQL
The Difference Between SQL And PL/SQL
Where To Access Oracle - Lesson 1
Where To Access Oracle - Lesson 2
Block Structure
Functions Procedures Packages
Data Types
Complex Objects
Variables Constants Parameters - Lesson 1
Variables Constants Parameters - Lesson 2
Flow Control
Errors Exceptions
Commenting Code

Data Types In Detail
Date And Time
Booleans Lobs

Complex Data Structures
Associative Array
Nested Tables
Arrays Of Records

Programming PL/SQL
SQL Developer - Lesson 1
SQL Developer - Lesson 2

A First Program
Hello World
Create Assign Use Variables
Create Procedure
Autonomous Transactions

Flow Control
If Statements
Case Statements
Loops - Lesson 1
Loops - Lesson 2

Functions - Lesson 1
Functions - Lesson 2
Built in Functions

Exception Handling
What Are Exceptions - Lesson 1
Predefined Exceptions
Raising Exceptions
Suggestions For Exception Handling
User Defined Exceptions

Inserting In PL/SQL
Updates And Deletes In PL/SQL
Selecting Data In PL/SQL
Cursor For Loops
Bulk Operations

Package Specifications
Package Bodies
Public And Private Globals - Lesson 1
Public And Private Globals - Lesson 2
Package Initialization
Forward Declarations
Package Cursors
Utl File

DML Triggers
Compound Triggers
Instead Of Triggers
Database Triggers

PL/SQL Objects
Object Types

Dynamic SQL
Dynamic SQL
DBMS SQL - Lesson 1
DBMS SQL - Lesson 2
DBMS SQL - Lesson 3
DBMS SQL - Lesson 4
NDS - Lesson 1
NDS - Lesson 2

About The Oracle PL/SQL Trainer
About The Oracle PL/SQL Tutor