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 |