Course Objectives
1 Write PL/SQL code to interface with the database
2 Design PL/SQL program units that execute efficiently
3 Handle run-time errors
4 Describe stored procedures and functions
5 Course Topics
6 Introduction to PL/SQL
7 What is PL/SQL
8 PL/SQL Environment
9 Benefits of PL/SQL
10 Overview of the Types of PL/SQL blocks
11 Create and Execute a Simple Anonymous Block
12 Generate Output from a PL/SQL Block
13 Declaring PL/SQL Identifiers
14 Identify the Different Types of Identifiers in a PL/SQL subprogram
15 Use the Declarative Section to Define Identifiers
16 List the Uses for Variables
17 Store Data in Variables
18 Declare PL/SQL Variables
19 Writing Executable Statements
20 Describe Basic Block Syntax Guidelines
21 Use Literals in PL/SQL
22 Customize Identifier Assignments with SQL Functions
23 Use Nested Blocks as Statements
24 Reference an Identifier Value in a Nested Block
25 Qualify an Identifier with a Label
26 Use Operators in PL/SQL
27 Use Proper PL/SQL Block Syntax and Guidelines
28 Interacting with the Oracle Server
29 Identify the SQL Statements You Can Use in PL/SQL
30 Include SELECT Statements in PL/SQL
31 Retrieve Data in PL/SQL with the SELECT Statement
32 Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
33 Manipulate Data in the Server Using PL/SQL
34 The SQL Cursor concept
35 Use SQL Cursor Attributes to Obtain Feedback on DML
36 Save and Discard Transactions
37 Writing Control Structures
38 Control PL/SQL Flow of Execution
39 Conditional processing Using IF Statements
40 Conditional Processing CASE Statements
41 Handle Nulls to Avoid Common Mistakes
42 Build Boolean Conditions with Logical Operators
43 Use Iterative Control with Looping Statements
44 Working with Composite Data Types
45 Learn the Composite Data Types of PL/SQL Records and Tables
46 Use PL/SQL Records to Hold Multiple Values of Different Types
47 Inserting and Updating with PL/SQL Records
48 Use INDEX BY Tables to Hold Multiple Values of the Same Data Type
49 Using Explicit Cursors
50 Cursor FOR Loops Using Sub-queries
51 Increase the Flexibility of Cursors By Using Parameters
52 Use the FOR UPDATE Clause to Lock Rows
53 Use the WHERE CURRENT Clause to Reference the Current Row
54 Use Explicit Cursors to Process Rows
55 Explicit Cursor Attributes
56 Cursors and Records
57 Handling Exceptions
58 Handling Exceptions with PL/SQL
59 Predefined Exceptions
60 Trapping Non-predefined Oracle Server Errors
61 Functions that Return Information on Encountered Exceptions
62 Trapping User-Defined Exceptions
63 Propagate Exceptions
64 Use The RAISE_APPLICATION_ERROR Procedure To Report Errors To Applications
65 Creating Stored Procedures and Functions
66 Differences between Anonymous Blocks and Subprograms
67 Creating and invoking Procedure
68 Creating and invoking Functions
69 Passing Parameter to the Function