skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

This course is self taught (Online course).

This course is taking bookings Book a place
(Provisional)

NOTE: Bookings on this course require approval by the course administrator.

You may make a provisional booking using this page, but your place will not be confirmed until the booking has been approved.


Booking / availability

Oracle Academy: Database Programming with PL/SQL (Online)
PrerequisitesOnline£

Self-taught course

Description

This is a fee-based online course for Oracle: Database Programming with PL/SQL. If you are unfamiliar with the Oracle online course environment it is strongly recommended that you attend the Oracle Academy: Database Design & SQL, and Database Programming in PL/SQL Induction to the Online Environment course.

This course covers Oracle's PL/SQL, a procedural language extension to SQL. You will learn procedural logic constructs such as variables, constraints, conditional statements and iterative controls.

This online course prepares you toward the external exams:

  • Oracle Database 11g: Program with PL/SQL Exam Number: 1Z0-144 Read more about this exam and its associated fee.
  • Program with PL/SQL Exam Number: 1Z0-147 Read more about this exam and its associated fee.
Target audience
  • All current Cambridge University members (departments and colleges)
  • Further details regarding eligibility criteria are available
Prerequisites

Previous experience with at least one programming language.

Topics covered
  • 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
Charging
  • Online access to the course £50 fee for University departments. Colleges and private payments from University members are charged + VAT = £60
Exam information
Duration

180 hours study. The course should be completed by 31st August when Oracle expires existing student accounts.

Frequency

On-going

Related courses
Themes

Booking / availability