The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.
- Use various features of PL/SQL.
- Write anonymous blocks of code in PL/SQL.
- Use various PL/SQL conditional constructs and loops in program blocks.
- Interface the PL/SQL code with the database.
- Use stored procedures and functions in their program blocks.
- Handle Exceptions in PL/SQL code.
Upon completing this course, the learner will be able to meet these overall objectives:
- Design PL/SQL anonymous block that execute efficiently
- Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
- Handle exceptions in the program units
- Create and execute simple stored procedures and functions
- Write PL/SQL code to interface with the database
- Describe the features and syntax of PL/SQL
Module 1: Introduction
Module 2: Introduction to PL/SQL
Module 3: Declaring PL/SQL Variables
Module 4: Writing Anonymous PL/SQL blocks
Module 5: Using SQL Statements within a PL/SQL Block
Module 6: Writing Control Structures
Module 7: Working with Composite Data Types
Module 8: Using Explicit Cursors
Module 9: Handling Exceptions
Module 10: Creating Stored Procedures and Functions
Who Should Attend
- PL/SQL Developer
- Database Administrators
- System Analysts
- Forms Developer
- Technical Consultant
- Portal Developer
- Familiarity with programming languages
- Familiarity with data processing concepts and technique
- Oracle Database 12c: Introduction for Experienced SQL Users
Show Schedule for: