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


