Section 1 : Introduction

Lecture 1 0101 What Is PLSQL
Lecture 2 0102 Course Expectations 4:19

Section 2 : An Overview Of PLSQL

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

Section 3 : Data Types In Detail

Lecture 15 0301 Strings 5:6
Lecture 16 0302 Numbers
Lecture 17 0303 Date And Time 3:47
Lecture 18 0304 Booleans Lobs 3:43

Section 4 : Complex Data Structures

Lecture 19 0401 Records 7:0
Lecture 20 0402 Associative Array 6:36
Lecture 21 0403 Nested Tables 3:27
Lecture 22 0404 Varrays 2:50
Lecture 23 0405 Arrays Of Records 4:24

Section 5 : Programming PLSQL

Lecture 24 0501 SQLplus 3:26
Lecture 25 0502 SQL Developer - Part 1 4:45
Lecture 26 0503 SQL Developer - Part 2 6:28

Section 6 : A First Program

Lecture 27 0601 Hello World 4:7
Lecture 28 0602 Create Assign Use Variables 5:34
Lecture 29 0603 Create Procedure 5:50
Lecture 30 0604 Autonomous Transactions 7:8

Section 7 : Flow Control

Lecture 31 0701 If Statements 4:51
Lecture 32 0702 Case Statements 6:27
Lecture 33 0703 Loops - Part 1
Lecture 34 0704 Loops - Part 2 7:25

Section 8 : Functions

Lecture 35 0801 Functions - Part 1 7:25
Lecture 36 0802 Functions - Part 2 3:4
Lecture 37 0803 Built in Functions 9:7

Section 9 : Exception Handling

Lecture 38 0901 What Are Exceptions - Part 1 6:29
Lecture 39 0902 Predefined Exceptions 4:41
Lecture 40 0903 Raising Exception 5:21
Lecture 41 0904 Suggestions For Exception Handling 5:58
Lecture 42 0905 User Defined Exceptions 7:39

Section 10 : SQL In PLSQL

Lecture 43 1001 Inserting In PL-SQL
Lecture 44 1002 Updates And Deletes In PL-SQL
Lecture 45 1003 Selecting Data In PL-SQL 6:8
Lecture 46 1004 Cursors 5:22
Lecture 47 1005 Cursor For Loops 2:7
Lecture 48 1006 Bulk Operations 7:52

Section 11 : Packages

Lecture 49 1101 Package Specifications 4:46
Lecture 50 1102 Package Bodies 4:0
Lecture 51 1103 Public And Private Globals - Part 1 6:47
Lecture 52 1104 Public And Private Globals - Part 2 3:5
Lecture 53 1105 Package Initialization 5:1
Lecture 54 1106 Forward Declarations 4:29
Lecture 55 1107 Package Cursors 3:58
Lecture 56 1108 Utl File 7:35
Lecture 57 1109 Overloading 9:23

Section 12 : Triggers

Lecture 58 1201 DML Triggers 8:30
Lecture 59 1202 Compound Triggers 2:43
Lecture 60 1203 Instead Of Triggers 2:48
Lecture 61 1204 Database Triggers 2:56

Section 13 : PLSQL Objects

Lecture 62 1301 Object Types 5:55
Lecture 63 1302 Constructors 7:17
Lecture 64 1303 Members 5:47
Lecture 65 1304 Equality 6:49
Lecture 66 1305 Inheritance 8:26

Section 14 : Dynamic SQL

Lecture 67 1401 Dynamic SQL 11:32
Lecture 68 1402 DBMS SQL - Part 1 7:16
Lecture 69 1403 DBMS SQL - Part 2 4:49
Lecture 70 1404 DBMS SQL - Part 3 5:31
Lecture 71 1405 DBMS SQL - Part 4 9:35
Lecture 72 1406 NDS - Part 1 8:13
Lecture 73 1407 NDS - Part 2 13:35