📚 PL/SQL – Course Content

1. Introduction to PL/SQL

• What is PL/SQL and its advantages
• Difference between SQL & PL/SQL
• PL/SQL architecture
• PL/SQL block structure

2. PL/SQL Basics

• Declaring variables & constants
• Data types in PL/SQL
• Using SELECT INTO
• Writing simple PL/SQL blocks

3. Control Structures

• Conditional statements (IF, IF-ELSE, CASE)
• Looping statements (LOOP, WHILE, FOR)
• Nested loops

4. Cursors

• Implicit cursors
• Explicit cursors
• Cursor attributes
• Parameterized cursors

5. Records & Collections

• Records
• %ROWTYPE & %TYPE
• Collections:
• Associative arrays
• Nested tables
• VARRAY

6. Exception Handling

• Types of exceptions
• Predefined exceptions
• User-defined exceptions
• Exception propagation

7. Stored Procedures

• Creating and executing procedures
• IN, OUT & IN OUT parameters
• Advantages of procedures
• Real-world procedure examples

8. Functions

• Creating user-defined functions
• Returning values
• Functions vs procedures
• Using functions in SQL queries

9. Packages

• Package specification & body
• Benefits of packages
• Variables & cursors in packages
• Package-based programming

10. Triggers

• What are triggers
• BEFORE & AFTER triggers
• INSERT, UPDATE & DELETE triggers
• Row-level & statement-level triggers
• Trigger use cases

11. Dynamic SQL

• EXECUTE IMMEDIATE
• Using dynamic queries
• Handling runtime SQL

12. Performance & Optimization Basics

• Bulk collect & FORALL
• Reducing context switching
• Writing efficient PL/SQL code

13. Security & Privileges

• Grant & revoke
• Definer rights vs invoker rights
• Secure PL/SQL coding practices

14. Real-Time Projects & Practice

• Employee management module
• Banking / finance database logic
• Validation & automation use cases
• End-to-end PL/SQL project

🛠 Skills You Will Gain

• Advanced SQL & PL/SQL programming
• Stored procedure & function development
• Trigger & package creation
• Exception handling & optimization
• Enterprise-level database programming skills

💼 Career Opportunities After Course

• PL/SQL Developer
• Oracle Database Developer
• Backend Developer
• Database Analyst
• Application Support Engineer
• ERP / Oracle Consultant (Junior Level)