Section 1 : Introduction

Lecture 1 0101 What Is PLSQL
Lecture 2 0102 Course Expectations 00:04:19 Duration

Section 2 : An Overview Of PLSQL

Lecture 1 0201 The Difference Between SQL And PL-SQL 00:06:43 Duration
Lecture 2 0202 Where To Access Oracle - Part 1 00:04:28 Duration
Lecture 3 0203 Where To Access Oracle - Part 2 00:05:54 Duration
Lecture 4 0204 Block Structure 00:07:04 Duration
Lecture 5 0205 Functions Procedures Packages
Lecture 6 0206 Data Types 00:07:19 Duration
Lecture 7 0207 Complex Objects 00:07:12 Duration
Lecture 8 0208 Variables Constants Parameters - Part 1 00:05:56 Duration
Lecture 9 0209 Variables Constants Parameters - Part 2 00:07:31 Duration
Lecture 10 0210 Flow Control 00:07:35 Duration
Lecture 11 0211 Errors Exceptions 00:07:46 Duration
Lecture 12 0212 Commenting Code 00:03:46 Duration

Section 3 : Data Types In Detail

Lecture 1 0301 Strings 00:05:06 Duration
Lecture 2 0302 Numbers
Lecture 3 0303 Date And Time 00:03:47 Duration
Lecture 4 0304 Booleans Lobs 00:03:43 Duration

Section 4 : Complex Data Structures

Lecture 1 0401 Records 00:07:00 Duration
Lecture 2 0402 Associative Array 00:06:36 Duration
Lecture 3 0403 Nested Tables 00:03:27 Duration
Lecture 4 0404 Varrays 00:02:50 Duration
Lecture 5 0405 Arrays Of Records 00:04:24 Duration

Section 5 : Programming PLSQL

Lecture 1 0501 SQLplus 00:03:26 Duration
Lecture 2 0502 SQL Developer - Part 1 00:04:45 Duration
Lecture 3 0503 SQL Developer - Part 2 00:06:28 Duration

Section 6 : A First Program

Lecture 1 0601 Hello World 00:04:07 Duration
Lecture 2 0602 Create Assign Use Variables 00:05:34 Duration
Lecture 3 0603 Create Procedure 00:05:50 Duration
Lecture 4 0604 Autonomous Transactions 00:07:08 Duration

Section 7 : Flow Control

Lecture 1 0701 If Statements 00:04:51 Duration
Lecture 2 0702 Case Statements 00:06:27 Duration
Lecture 3 0703 Loops - Part 1
Lecture 4 0704 Loops - Part 2 00:07:25 Duration

Section 8 : Functions

Lecture 1 0801 Functions - Part 1 00:07:25 Duration
Lecture 2 0802 Functions - Part 2 00:03:04 Duration
Lecture 3 0803 Built in Functions 00:09:07 Duration

Section 9 : Exception Handling

Lecture 1 0901 What Are Exceptions - Part 1 00:06:29 Duration
Lecture 2 0902 Predefined Exceptions 00:04:41 Duration
Lecture 3 0903 Raising Exception 00:05:21 Duration
Lecture 4 0904 Suggestions For Exception Handling 00:05:58 Duration
Lecture 5 0905 User Defined Exceptions 00:07:39 Duration

Section 10 : SQL In PLSQL

Lecture 1 1001 Inserting In PL-SQL
Lecture 2 1002 Updates And Deletes In PL-SQL
Lecture 3 1003 Selecting Data In PL-SQL 00:06:08 Duration
Lecture 4 1004 Cursors 00:05:22 Duration
Lecture 5 1005 Cursor For Loops 00:02:07 Duration
Lecture 6 1006 Bulk Operations 00:07:52 Duration

Section 11 : Packages

Lecture 1 1101 Package Specifications 00:04:46 Duration
Lecture 2 1102 Package Bodies 00:04:00 Duration
Lecture 3 1103 Public And Private Globals - Part 1 00:06:47 Duration
Lecture 4 1104 Public And Private Globals - Part 2 00:03:05 Duration
Lecture 5 1105 Package Initialization 00:05:01 Duration
Lecture 6 1106 Forward Declarations 00:04:29 Duration
Lecture 7 1107 Package Cursors 00:03:58 Duration
Lecture 8 1108 Utl File 00:07:35 Duration
Lecture 9 1109 Overloading 00:09:23 Duration

Section 12 : Triggers

Lecture 1 1201 DML Triggers 00:08:30 Duration
Lecture 2 1202 Compound Triggers 00:02:43 Duration
Lecture 3 1203 Instead Of Triggers 00:02:48 Duration
Lecture 4 1204 Database Triggers 00:02:56 Duration

Section 13 : PLSQL Objects

Lecture 1 1301 Object Types 00:05:55 Duration
Lecture 2 1302 Constructors 00:07:17 Duration
Lecture 3 1303 Members 00:05:47 Duration
Lecture 4 1304 Equality 00:06:49 Duration
Lecture 5 1305 Inheritance 00:08:26 Duration

Section 14 : Dynamic SQL

Lecture 1 1401 Dynamic SQL 00:11:32 Duration
Lecture 2 1402 DBMS SQL - Part 1 00:07:16 Duration
Lecture 3 1403 DBMS SQL - Part 2 00:04:49 Duration
Lecture 4 1404 DBMS SQL - Part 3 00:05:31 Duration
Lecture 5 1405 DBMS SQL - Part 4 00:09:35 Duration
Lecture 6 1406 NDS - Part 1 00:08:13 Duration
Lecture 7 1407 NDS - Part 2 00:13:35 Duration