Enrollment Options:

1. PL/SQL Basics
1. What is PL/SQL?
2. Blocks
3. Outputting Information
4. Variables and Constants
5. Constants
6. Data Types
7. Naming Variables and Other Elements
8. Embedding SQL in PL/SQL
9. SELECT...INTO and RETURNING...INTO
10. PL/SQL Features
2. Subprograms
1. Introduction to Subprograms
2. Procedures
3. Variable Declarations
4. Dropping a Procedure
5. Parameters
6. Parameters with Default Values
7. Parameter Modes
8. IN Mode
9. OUT Mode
10. IN OUT Mode
11. Named Notation
12. Using SQL in a Subprogram
13. %TYPE
14. Functions
15. Using PL/SQL Functions in SQL Queries
3. Conditional Processing
1. Conditions and Booleans
2. IF-ELSIF-ELSE Conditions
3. ELSIF
4. BOOLEAN Values and Standard SQL
5. The CASE Statement
6. CASE Expressions
4. Exceptions
1. Introduction to Exceptions
2. Predefined Exceptions
3. The EXCEPTION Part of the Block
4. User-defined Exceptions
5. User-defined Exceptions in Subprograms
6. Re-raising Exceptions
7. Naming Unnamed Predefined Exceptions
8. WHILE Loops
9. When to Use Exceptions
5. Cursors
1. Implicit Cursors
2. Explicit Cursors
3. %ROWTYPE
4. Explicit Cursor Use Case
5. Cursor FOR LOOP
6. Cursor Parameters
6. Packages
1. Package Basics
2. The Package Specification
3. The Package Body
4. Building an Employee Package
5. Overloading Subprograms
6. Auditing
7. Validation Procedures
8. Package Cursors
9. Benefits of Packages
7. Triggers
1. What are triggers?
2. Trigger Parts
3. Validation Triggers
4. The WHEN Clause
5. Audit Triggers
6. Statement-level Triggers
7. Compound Triggers
8. Trigger Warning