Oracle PL/SQL Video Tutorial Course

CareerVision Training
Distancia

£ 70 - (Rs 6,031)
VAT incl.

Important information

  • Training
  • Beginner
  • Distance learning
  • Duration:
    Flexible
  • When:
    Flexible
  • Delivery of study materials
Description

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

Important information

Requirements: 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.

Venues

Where and when

Starts Location
Flexible
Distance Learning

What you'll learn on the course

Databases
PL/SQL Programming
Oracle
Data Types
Flow Control

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