Oracle Database 19c- PL-SQL Workshop


Request for price


Length: 5.0 day (40 hours)

 

This comprehensive workshop is designed to equip participants with the essential skills to write efficient and robust PL/SQL programs. It covers the core concepts of PL/SQL, from basic syntax to advanced techniques, enabling learners to leverage the full potential of this powerful language.

Audience:

  • Database developers and administrators
  • Software engineers
  • IT professionals who work with Oracle databases
  • Basic understanding of SQL and relational database concepts
  • Familiarity with Oracle Database 19c

Start with the customer – find out what they want and give it to them.

Course objectivesCourse outlines

Course objectives

After completing this course, students will be able to:

    • Understand the fundamental concepts of PL/SQL
    • Write efficient and well-structured PL/SQL code
    • Create and manage PL/SQL blocks, procedures, and functions
    • Handle exceptions and errors gracefully
    • Utilize advanced PL/SQL features, such as cursors, triggers, and packages
    • Optimize PL/SQL code for performance
    • Debug and troubleshoot PL/SQL code

Course outlines

  • Module 1: Introduction to PL/SQL
    • What is PL/SQL?
    • PL/SQL architecture
    • PL/SQL block structure
    • Data types and variables
    • Operators and expressions
  • Module 2: Control Structures
    • Conditional statements (IF-THEN-ELSE)
    • Looping statements (FOR loop, WHILE loop, LOOP)
  • Module 3: Exception Handling
    • Exception handling mechanism
    • User-defined exceptions
    • Raising and handling exceptions
  • Module 4: Procedures and Functions
    • Creating and calling procedures and functions
    • Parameter passing mechanisms (IN, OUT, IN OUT)
    • Overloading procedures and functions
  • Module 5: Cursors
    • Implicit and explicit cursors
    • Cursor attributes
    • FOR loop with cursor
  • Module 6: Triggers
    • Database triggers (BEFORE INSERT, AFTER UPDATE, etc.)
    • PL/SQL triggers (INSTEAD OF, BEFORE EACH ROW, AFTER EACH ROW)
  • Module 7: Packages
    • Package specification and body
    • Package variables, procedures, and functions
    • Package initialization and finalization
  • Module 8: Advanced PL/SQL Topics
    • Dynamic SQL
    • Bulk collect and forall
    • Autonomous transactions
    • PL/SQL tables
  • Hands-on Exercises and Projects:
  • Throughout the workshop, participants will engage in hands-on exercises and real-world projects to reinforce their learning and apply their skills. These practical exercises will cover topics such as:
    • Writing complex PL/SQL procedures and functions
    • Creating database triggers
    • Developing database packages
    • Optimizing PL/SQL code for performance

​

Download outlines