Oracle PL/SQL

Video description

Oracle PL/SQL

Video description

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.

Publisher resources

Download Example Code

Introduction

What Is PL/SQL 00:04:02

Course Expectations 00:04:19

An Overview Of PL/SQL

The Difference Between SQL And PL/SQL 00:06:43

Where To Access Oracle - Part 1 00:04:28

Where To Access Oracle - Part 2 00:05:54

Block Structure 00:07:04

Functions Procedures Packages 00:09:45

Data Types 00:07:19

Complex Objects 00:07:12

Variables Constants Parameters - Part 1 00:05:56

Variables Constants Parameters - Part 2 00:07:31

Flow Control 00:07:35

Errors Exceptions 00:07:46

Commenting Code 00:03:46

Data Types In Detail

Strings 00:05:06

Numbers 00:04:28

Date And Time 00:03:47

Booleans Lobs 00:03:43

Complex Data Structures

Records 00:07:00

Associative Array 00:06:36

Nested Tables 00:03:27

Varrays 00:02:50

Arrays Of Records 00:04:24

Programming PL/SQL

SQLplus 00:03:26

SQL Developer - Part 1 00:04:45

SQL Developer - Part 2 00:06:28

A First Program

Hello World 00:04:07

Create Assign Use Variables 00:05:34

Create Procedure 00:05:50

Autonomous Transactions 00:07:07

Flow Control

If Statements 00:04:50

Case Statements 00:06:27

Loops - Part 1 00:05:21

Loops - Part 2 00:07:25

Functions

Functions - Part 1 00:07:24

Functions - Part 2 00:03:04

Built in Functions 00:09:07

Exception Handling

What Are Exceptions - Part 1 00:06:29

Predefined Exceptions 00:04:41

Raising Exceptions 00:05:21

Suggestions For Exception Handling 00:05:58

User Defined Exceptions 00:07:39

SQL In PL/SQL

Inserting In PL/SQL 00:07:09

Updates And Deletes In PL/SQL 00:08:25

Selecting Data In PL/SQL 00:06:08

Cursors 00:05:22

Cursor For Loops 00:02:07

Bulk Operations 00:07:52

Packages

Package Specifications 00:04:46

Package Bodies 00:04:00

Public And Private Globals - Part 1 00:06:46

Public And Private Globals - Part 2 00:03:05

Package Initialization 00:05:01

Forward Declarations 00:04:29

Package Cursors 00:03:58

Utl File 00:07:35

Overloading 00:09:23

Triggers

DML Triggers 00:08:30

Compound Triggers 00:02:43

Instead Of Triggers 00:02:48

Database Triggers 00:02:56

PL/SQL Objects

Object Types 00:05:55

Constructors 00:07:17

Members 00:05:47

Equality 00:06:49

Inheritance 00:08:26

Dynamic SQL

Dynamic SQL 00:11:32

DBMS SQL - Part 1 00:07:16

DBMS SQL - Part 2 00:04:49

DBMS SQL - Part 3 00:05:31

DBMS SQL - Part 4 00:09:35

NDS - Part 1 00:08:13

NDS - Part 2 00:13:35

About The Author

About Me 00:03:49

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.

Oracle PL/SQL

Oracle PL/SQL

Video description

Oracle PL/SQL

Video description

Publisher resources

Table of Contents