Course not currently available

Oracle PL/SQL Video Tutorial Course

Learning247

Training

Distance

£ 70 VAT inc.

The best Other programming courses

See all

See all

Description

  • Type

    Training

  • Level

    Beginner

  • Methodology

    Distance Learning

  • Duration

    Flexible

  • Delivery of study materials

    Yes

COURSE INCLUDES
• Format: DVD-ROM
• Duration: 7.5 Hours (74 lessons)
• Instructor: Lewis Cunningham
• Platform: Windows PC or Mac


COURSE INTRODUCTION

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 statem

About this course

This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • PL/SQL Programming
  • Oracle
  • Data Types
  • Flow Control
  • Databases

Teachers and trainers (1)

Distance Learning Distance Learning

Distance Learning Distance Learning

Distance Learning

This is a Distance Learning Course on DVD-ROM. The Instructors are all experts in their field and many have authored multiple training courses and books. This is a Distance Learning Course on DVD-ROM. The Instructors are all experts in their field and many have authored multiple training courses and books.

Course programme

Introduction

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

Strings

Numbers

Date And Time

Booleans Lobs


Complex Data Structures

Records

Associative Array

Nested Tables

Varrays

Arrays Of Records


Programming PL/SQL

SQLplus

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

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


SQL In PL/SQL

Inserting In PL/SQL

Updates And Deletes In PL/SQL

Selecting Data In PL/SQL

Cursors

Cursor For Loops

Bulk Operations


Packages

Package Specifications

Package Bodies

Public And Private Globals - Lesson 1

Public And Private Globals - Lesson 2

Package Initialization

Forward Declarations

Package Cursors

Utl File

Overloading


Triggers

DML Triggers

Compound Triggers

Instead Of Triggers

Database Triggers


PL/SQL Objects

Object Types

Constructors

Members

Equality

Inheritance


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

See related categories

Oracle PL/SQL Video Tutorial Course

£ 70 VAT inc.

The best Other programming courses

See all

See all