Learn Oracle Pl/Sql - A Comprehensive Training Course

A Comprehensive Oracle PL/SQL Course Taught By Infinite Skills

What you'll learn
To Master Oracle PL/SQL - Learn From A Leading Expert
Requirements
A Desire To Learn
Description
In this training course by Infinite Skills 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.

Overview

Section 1: Introduction

Lecture 1 Important - Download These First - Working Files

Lecture 2 0101 What Is PL/SQL

Lecture 3 0102 Course Expectations

Section 2: An Overview Of PL/SQL

Lecture 4 0201 The Difference Between SQL And PL/SQL

Lecture 5 0202 Where To Access Oracle - Part 1

Lecture 6 0203 Where To Access Oracle - Part 2

Lecture 7 0204 Block Structure

Lecture 8 0205 Functions Procedures Packages

Lecture 9 0206 Data Types

Lecture 10 0207 Complex Objects

Lecture 11 0208 Variables Constants Parameters - Part 1

Lecture 12 0209 Variables Constants Parameters - Part 2

Lecture 13 0210 Flow Control

Lecture 14 0211 Errors Exceptions

Lecture 15 0212 Commenting Code

Section 3: Data Types In Detail

Lecture 16 0301 Strings

Lecture 17 0302 Numbers

Lecture 18 0303 Date And Time

Lecture 19 0304 Booleans Lobs

Section 4: Complex Data Structures

Lecture 20 0401 Records

Lecture 21 0402 Associative Array

Lecture 22 0403 Nested Tables

Lecture 23 0404 Varrays

Lecture 24 0405 Arrays Of Records

Section 5: Programming PL/SQL

Lecture 25 0501 SQLplus

Lecture 26 0502 SQL Developer - Part 1

Lecture 27 0503 SQL Developer - Part 2

Section 6: A First Program

Lecture 28 0601 Hello World

Lecture 29 0602 Create Assign Use Variables

Lecture 30 0603 Create Procedure

Lecture 31 0604 Autonomous Transactions

Section 7: Flow Control

Lecture 32 0701 If Statements

Lecture 33 0702 Case Statements

Lecture 34 0703 Loops - Part 1

Lecture 35 0704 Loops - Part 2

Section 8: Functions

Lecture 36 0801 Functions - Part 1

Lecture 37 0802 Functions - Part 2

Lecture 38 0803 Built in Functions

Section 9: Exception Handling

Lecture 39 0901 What Are Exceptions - Part 1

Lecture 40 0902 Predefined Exceptions

Lecture 41 0903 Raising Exceptions

Lecture 42 0904 Suggestions For Exception Handling

Lecture 43 0905 User Defined Exceptions

Section 10: SQL In PL/SQL

Lecture 44 1001 Inserting In PL/SQL

Lecture 45 1002 Updates And Deletes In PL/SQL

Lecture 46 1003 Selecting Data In PL/SQL

Lecture 47 1004 Cursors

Lecture 48 1005 Cursor For Loops

Lecture 49 1006 Bulk Operations

Section 11: Packages

Lecture 50 1101 Package Specifications

Lecture 51 1102 Package Bodies

Lecture 52 1103 Public And Private Globals - Part 1

Lecture 53 1104 Public And Private Globals - Part 2

Lecture 54 1105 Package Initialization

Lecture 55 1106 Forward Declarations

Lecture 56 1107 Package Cursors

Lecture 57 1108 Utl File

Lecture 58 1109 Overloading

Section 12: Triggers

Lecture 59 1201 DML Triggers

Lecture 60 1202 Compound Triggers

Lecture 61 1203 Instead Of Triggers

Lecture 62 1204 Database Triggers

Section 13: PL/SQL Objects

Lecture 63 1301 Object Types

Lecture 64 1302 Constructors

Lecture 65 1303 Members

Lecture 66 1304 Equality

Lecture 67 1305 Inheritance

Section 14: Dynamic SQL

Lecture 68 1401 Dynamic SQL

Lecture 69 1402 DBMS SQL - Part 1

Lecture 70 1403 DBMS SQL - Part 2

Lecture 71 1404 DBMS SQL - Part 3

Lecture 72 1405 DBMS SQL - Part 4

Lecture 73 1406 NDS - Part 1

Lecture 74 1407 NDS - Part 2

Users Of All Levels