Curriculum
Section 1: Introduction to PLSQL
1 Introduction
Section 2: Some Basic Concepts on PLSQL
2 What is PLSQL
3 Advantages of PLSQL
4 Calling PLSQL‚ PLSQL Block Structure
Section 3: Anonymous Blocks
5 Anonymous Blocks
6 Anonymous Blocks Execution
7 PLSQL Functions
8 Declaration with Initialization
9 Anonymous Blocks – User Inputs
10 Anonymous Blocks – Tempp Table
11 Anonymous Blocks – Datatype
12 Anonymous Blocks – Nesting of Structures
Section 4: Decision Making in PLSQL
13 IF THEN ELSE Statement
14 IF THEN ELSEIF Statement
Section 5: Loops In PLSQL
15 Loops In PLSQL Part 1
16 Loops In PLSQL Part 2
17 Loops In PLSQL Part 3
18 Loops In PLSQL Part 4
19 Loops In PLSQL Part 5
20 Loops In PLSQL Part 6
21 Loops In PLSQL Part 7
22 Loops In PLSQL Part 8
23 Loops In PLSQL Part 9
Section 6: Sub Blocks In PLSQL
24 Sub Blocks In PLSQL Part 1
25 Sub Blocks In PLSQL Part 2
26 Sub Blocks In PLSQL Part 3
Section 7: Cursors
27 Cursors Part 1
28 Cursors Part 2
29 Cursors Part 3
30 Cursors Part 4
31 Cursors Part 5
32 Cursors Part 6
33 Cursors Part 7
34 Cursors Part 8
35 Cursors Part 9
36 Cursor Part 10
37 Cursor Part 11
38 Cursor Part 12
39 Cursor Part 13
Section 8: Exceptions
40 Exceptions Part 1
41 Exceptions Part 2
42 Exceptions Part 3
43 Exceptions Part 4
44 Exceptions Part 5
45 Exceptions Part 6
46 Exceptions Part 7
47 Exceptions Part 8
48 Exceptions Part 9
49 Exceptions Part 10
50 Exceptions Part 11
Section 9: Stored Procedures
51 Stored Procedures Part 1
52 Stored Procedures Part 2
53 Stored Procedures Part 3
54 Stored Procedures Part 4
55 Stored Procedures Part 5
56 Stored Procedures Part 6
Section 10: Stored Procedures
57 Stored Functions Part 1
58 Stored Functions Part 2
59 Stored Functions Part 3
60 Stored Functions Part 4
Section 11: Managing Subprograms
61 Managing Subprograms Part 1
62 Managing Subprograms Part 2
63 Managing Subprograms Part 3
64 Managing Subprograms Part 4
65 Managing Subprograms Part 5
Section 12: Packages
66 Packages Part 1
67 Packages Part 2
68 Packages Part 3
69 Packages Part 4
70 Packages Part 5
71 Packages Part 6
72 Packages Part 7
73 Packages Part 8
Section 13 Packages
74 Managing LOBs Part 1
75 Managing LOBs Part 2
76 Managing LOBs Part 3
Section 14 Triggers
77 Triggers Part 1
78 Triggers Part 2
79 Triggers Part 3
80 Triggers Part 4
81 Triggers Part 5
82 Triggers Part 6
83 Triggers Part 7
84 Triggers Part 8
85 Triggers Part 9
86 Triggers Part 10
87 Triggers Part 11
Section 15 Advance Triggers Concepts
88 Advance Triggers Concepts Part 1
89 Advance Triggers Concepts Part 2
