Course PL-SQL

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape

PL-SQL

About Course

Learn PL/SQL (Procedural Language/SQL) from the fundamentals to advanced programming concepts used with Oracle Database. This course covers PL/SQL syntax, variables, constants, conditional statements, loops, cursors, exception handling, procedures, functions, packages, triggers, and dynamic SQL. You’ll learn how to combine SQL with procedural programming to implement business logic and build reliable, reusable database solutions.

Duration: 30 Hours

Category: Data & AI

Skill Level: Beginner & Intermediate

Modules:     22

Subjects & Expertise

With extensive experience in T-SQL and Microsoft SQL Server technologies, I specialize in teaching SQL programming, database development, query optimization, stored procedures, functions, and transaction management. The training focuses on combining SQL fundamentals with T-SQL programming techniques to help learners develop practical solutions for real-world business requirements.

Whether you’re new to T-SQL or a working professional looking to enhance your SQL Server programming skills, the course provides hands-on learning through practical exercises, real-time examples, and industry-oriented projects. Students gain the confidence to write complex queries, develop reusable database programs, implement business logic, and troubleshoot SQL-related problems effectively.

Educational Background

Our PL/SQL training is designed by industry professionals with extensive experience in Oracle Database, database development, application development, and software engineering. The curriculum combines Oracle SQL fundamentals with procedural programming concepts, enabling learners to build strong, job-ready PL/SQL development skills.

Each module includes hands-on labs, coding exercises, real-world scenarios, and practical assignments, helping learners confidently apply PL/SQL in enterprise applications, data processing, database automation, reporting solutions, and database development projects.

Modules

1. Introduction to PL/SQL

  • PL/SQL Architecture
  • PL/SQL Block Structure
  • Advantages of PL/SQL
  • Anonymous Blocks

2. Variables and Data Types

  • DECLARE Section
  • Variables
  • Constants
  • %TYPE
  • %ROWTYPE

3. Operators and Expressions

  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Assignment Operator

4. Conditional Statements

  • IF
  • IF-ELSE
  • ELSIF
  • Nested IF
  • CASE Statement

5. Loops

  • Simple LOOP
  • WHILE LOOP
  • FOR LOOP
  • Nested Loops

6. Exception Handling

  • Predefined Exceptions
  • User Defined Exceptions
  • RAISE Statement
  • Exception Section

7. Cursors

  • Implicit Cursors
  • Explicit Cursors
  • Cursor Attributes

8. Cursor FOR Loops

  • Cursor FOR LOOP
  • Fetching Records
  • Bulk Processing Basics

9. Procedures

  • Creating Procedures
  • IN Parameters
  • OUT Parameters
  • IN OUT Parameters
  • Calling Procedures

10. Functions

  • Creating Functions
  • Return Values
  • Using Functions in SQL
  • Best Practices

11. Packages

  • Package Specification
  • Package Body
  • Package Variables
  • Package Procedures

12. Triggers

  • BEFORE Trigger
  • AFTER Trigger
  • Row Level Triggers

13. Collections

  • Associative Arrays
  • Nested Tables
  • VARRAYS

14. Records

  • Creating Records
  • Working with Records
  • %ROWTYPE Records

15. Dynamic SQL

  • EXECUTE IMMEDIATE
  • Dynamic Queries
  • Dynamic DDL

16. Bulk Processing

  • BULK COLLECT
  • FORALL
  • Performance Improvement

17. Transaction Management

  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • Autonomous Transactions

18. Business Logic Development

  • Validation Logic
  • Approval Logic
  • Order Processing
  • Inventory Processing

19. Auditing and Logging

  • Audit Tables
  • Error Logging
  • Execution Logs
  • Tracking Changes

20. File Handling

  • UTL_FILE Package
  • Reading Files
  • Writing Files

21. Real-Time PL/SQL Scenarios

  • Data Migration
  • Data Synchronization
  • ETL Processing
  • Batch Jobs

22. Mini Projects and Interview Questions

  • Employee Management System
  • Banking Scenarios
  • Procedure Questions
  • Trigger Questions