Learning Oracle PL/SQL Training Video

expand all / collapse all

• 00. 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

• 01. Introduction

  • 0101 What Is PL/SQL
  • 0102 Course Expectations

• 02. An Overview Of PL/SQL

  • 0201 The Difference Between SQL And PL/SQL
  • 0202 Where To Access Oracle - Part 1
  • 0203 Where To Access Oracle - Part 2
  • 0204 Block Structure
  • 0205 Functions Procedures Packages
  • 0206 Data Types
  • 0207 Complex Objects
  • 0208 Variables Constants Parameters - Part 1
  • 0209 Variables Constants Parameters - Part 2
  • 0210 Flow Control
  • 0211 Errors Exceptions
  • 0212 Commenting Code

• 03. Data Types In Detail

  • 0301 Strings
  • 0302 Numbers
  • 0303 Date And Time
  • 0304 Booleans Lobs

• 04. Complex Data Structures

  • 0401 Records
  • 0402 Associative Array
  • 0403 Nested Tables
  • 0404 Varrays
  • 0405 Arrays Of Records

• 05. Programming PL/SQL

  • 0501 SQLplus
  • 0502 SQL Developer - Part 1
  • 0503 SQL Developer - Part 2

• 06. A First Program

  • 0601 Hello World
  • 0602 Create Assign Use Variables
  • 0603 Create Procedure
  • 0604 Autonomous Transactions

• 07. Flow Control

  • 0701 If Statements
  • 0702 Case Statements
  • 0703 Loops - Part 1
  • 0704 Loops - Part 2

• 08. Functions

  • 0801 Functions - Part 1
  • 0802 Functions - Part 2
  • 0803 Built in Functions

• 09. Exception Handling

  • 0901 What Are Exceptions - Part 1
  • 0902 Predefined Exceptions
  • 0903 Raising Exceptions
  • 0904 Suggestions For Exception Handling
  • 0905 User Defined Exceptions

• 10. SQL In PL/SQL

  • 1001 Inserting In PL/SQL
  • 1002 Updates And Deletes In PL/SQL
  • 1003 Selecting Data In PL/SQL
  • 1004 Cursors
  • 1005 Cursor For Loops
  • 1006 Bulk Operations

• 11. Packages

  • 1101 Package Specifications
  • 1102 Package Bodies
  • 1103 Public And Private Globals - Part 1
  • 1104 Public And Private Globals - Part 2
  • 1105 Package Initialization
  • 1106 Forward Declarations
  • 1107 Package Cursors
  • 1108 Utl File
  • 1109 Overloading

• 12. Triggers

  • 1201 DML Triggers
  • 1202 Compound Triggers
  • 1203 Instead Of Triggers
  • 1204 Database Triggers

• 13. PL/SQL Objects

  • 1301 Object Types
  • 1302 Constructors
  • 1303 Members
  • 1304 Equality
  • 1305 Inheritance

• 14. Dynamic SQL

  • 1401 Dynamic SQL
  • 1402 DBMS SQL - Part 1
  • 1403 DBMS SQL - Part 2
  • 1404 DBMS SQL - Part 3
  • 1405 DBMS SQL - Part 4
  • 1406 NDS - Part 1
  • 1407 NDS - Part 2

• 15. About The Author

  • 1501 About Me

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.