by | Released October 2011 | ISBN: 9781926873718

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. Show and hide more Publisher resources Download Example Code

1. Introduction
   • What Is PL/SQL 00:04:02
   • Course Expectations 00:04:19
2. 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
3. Data Types In Detail
   • Strings 00:05:06
   • Numbers 00:04:28
   • Date And Time 00:03:47
   • Booleans Lobs 00:03:43
4. 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
5. Programming PL/SQL
   • SQLplus 00:03:26
   • SQL Developer - Part 1 00:04:45
   • SQL Developer - Part 2 00:06:28
6. 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
7. Flow Control
   • If Statements 00:04:50
   • Case Statements 00:06:27
   • Loops - Part 1 00:05:21
   • Loops - Part 2 00:07:25
8. Functions
   • Functions - Part 1 00:07:24
   • Functions - Part 2 00:03:04
   • Built in Functions 00:09:07
9. 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
10. 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
11. 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
12. Triggers
    • DML Triggers 00:08:30
    • Compound Triggers 00:02:43
    • Instead Of Triggers 00:02:48
    • Database Triggers 00:02:56
13. PL/SQL Objects
    • Object Types 00:05:55
    • Constructors 00:07:17
    • Members 00:05:47
    • Equality 00:06:49
    • Inheritance 00:08:26
14. 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
15. About The Author
    • About Me 00:03:49
Show and hide more