We provide virtual course about Oracle Database: PL/SQL Fundamentals in english. This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL and explains the benefits of this programming language.
Course description:
You'll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
Learn to:
• Conditionally control code flow (loops, control structures)
• Use explicit cursors
• Handle runtime errors
• Describe stored procedures and functions
• Work with composite data types
• Declare PL/SQL variables
• Create anonymous PL/SQL blocks, stored procedures and functions
• Declare identifiers and trap exceptions
Course objectives:
• Handle runtime errors
• Describe stored procedures and functions
• Use cursors to process rows
• Design PL/SQL anonymous block that execute efficiently
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Benefits to you:
Enrolling in this course will teach you how to extend the functionality of the SQL language with PL/SQL language to write application code. Your organization can then realize the full benefit of utilizing Oracle best practices.
Target audience:
Technical Consultants, System Analysts, PL/SQL Developers, Forms Developers
Prerequisites:
• Oracle Database: Introduction to SQL
Language:
• English course material, english speaking instructor