ORACLE PL/SQL Fundamentals Training Course

This 5-day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions, and triggers using both SQL and PL/SQL commands.

The course takes the format of a workshop, with a mix of lectures, working examples, and practical exercises. Although the content may be customized, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, for example, SQL files, and free software tools for use in accessing an ORACLE database.

• Understand the fundamentals of Oracle PL/SQL programming
• Learn how to write, test, and execute PL/SQL blocks, procedures, functions, and triggers
• Gain practical skills in using SQL and PL/SQL together for database development
• Work with variables, datatypes, conditions, loops, and records in PL/SQL
• Understand exception handling and error management techniques
• Use cursors for handling multi-row query processing efficiently
• Develop modular programs using procedures, functions, and packages
• Implement triggers for automating database operations and enforcing business rules
• Learn dynamic SQL and its applications in PL/SQL development
• Work with file handling using UTL_FILE and system packages
• Understand collections (nested tables, VARRAYs, index-by tables) and their usage
• Apply bulk processing techniques to improve performance
• Gain hands-on experience through workshops and real database examples
• Build the ability to develop and maintain PL/SQL-based database applications

• The course is suitable for participants with basic knowledge of SQL
• Prior experience with interactive computer systems is desirable but not required
• No advanced technical background is necessary to attend the course
• Suitable for learners with a foundational understanding of databases or data concepts