Oracle Academy: Database Programming with PL/SQL (Online) 2021-2022 AdvancedOnline
This 180 hour course introduces you to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. You also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges you to program, implement, and demonstrate a database solution for a business or organisation.
Exam Information
Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career.
This online course prepares you toward the external exam (please note that this exam retires on 31-October-2020): Oracle Database 11g: Program with PL/SQL Exam Number: 1Z0-144 Read more about this exam and its associated fee.
- All current Cambridge University members (departments and colleges)
- Further details regarding eligibility criteria are available
- Previous experience with at least one programming language and previous experience with a database application, or
- Oracle Academy Course – Database Design and Database Programming with SQL
- Fundamentals
- Introduction to PL/SQL
- Benefits of PL/SQL
- Creating PL/SQL blocks
- Defining Variables and Data types
- Using variables in PL/SQL
- Recognizing PL/SQL lexical units
- Recognizing data types
- Using scalar data types
- Writing PL/SQL executable statements
- Nested blocks and variable scope
- Good programming practices
- Using SQL in PL/SQL
- Review of SQL DML
- Retrieving data in PL/SQL
- Manipulating data in PL/SQL
- Using transaction control statements
- Program Structures to Control Execution Flow
- Conditional control: IF statements
- Conditional control: CASE statements
- Iterative control: basic loops
- Iterative control: WHILE and FOR loops
- Iterative control: nested loops
- Using Cursors and Parameters
- Introduction to explicit cursors
- Using explicit cursor attributes
- Cursor FOR loops
- Cursors with parameters
- Using cursors for UPDATE
- Using multiple cursors
- Using Composite Data types
- User-defined records
- Indexing tables of records
- Exception Handling
- Handling exceptions
- Trapping Oracle server exceptions
- Trapping user-defined exceptions
- Recognizing the scope of exceptions
- Using and Managing Procedures
- Creating procedures
- Using parameters in procedures
- Passing parameters
- Using and Managing Functions
- Creating functions
- Using functions in SQL statements
- Review of the data dictionary
- Managing procedures and functions
- Review of object privileges
- Using invoker's rights and autonomous transaction
- Using and Managing Packages
- Creating packages
- Managing package concepts
- Advanced package concepts
- Getting the Best out of Packages
- Persistent state of package variables
- Using Oracle-supplied packages
- Improving PL/SQL Performance
- Using dynamic SQL
- Improving PL/SQL performance
- Using and Managing Triggers
- Introduction to triggers
- Creating DML triggers, part I
- Creating DML triggers, part II
- Creating DDL and database event triggers
- Managing triggers
- Recognizing and Managing Dependencies
- Introduction to dependencies
- Understanding remote dependencies
- Using the PL/SQL Compiler
- Using PL/SQL initialization parameters
- Displaying compiler warning messages
- Using conditional compilation
- Hiding your source code
What is needed to access Oracle iLearning:
A browser, either:
- IE | Edge | Chrome | FireFox | Safari
- Cookies must be enabled
- Pop-ups must be allowed
- Adobe Acrobat Reader
The course is approximately 180 hours on a self study basis, however the course should be completed within one year of enrolment.
On-going
- Oracle Academy: Database Foundations (Online) 2023-2024
- Oracle Academy: Database Design and Programming with SQL (Online)
- Oracle Academy: Application Express – Application Development Foundations (Online) 2021-2022
Booking / availability