Oracle: Database Programming with PL/SQL Induction to the Online Envrionment

Prerequisites

This course is an induction to the Oracle online environment for the Oracle: Database Programming with PL/SQL (Online) course. It provides a session of familiarisation for those who are new to this environment.

If you wish to attend this induction session please make a booking as well as booking onto the Oracle: Database Programming with PL/SQL (Online) course so that you will have access to the online environment during and after the induction session.

This induction session is free, there is a compulsory charge for access to the Oracle: Database Programming with PL/SQL (Online) course which will be requested at the time of booking on that course as follows:

• £50 for University departments
• £50 + VAT = £60 for colleges and private payments from University members

If you are already familiar with the online environment and would just like access to the online course please directly book onto the Oracle: Database Programming with PL/SQL (Online) course. Should you need to discuss this with us first, please contact Oracle: Database Programming with PL/SQL (Online).

• All University members (departments and colleges)
• Further details regarding eligibility criteria are available

• Before booking on this induction session, please book on the Oracle: Database Design and SQL (Online) course

Number of sessions: 2

• Fundamentals
• Defining Variables and Datatypes
• Using SQL in PL/SQL
• Program Structures To Control Execution Flow
• Using Composite Datatypes
• Exception Handling
• Using and Managing Procedures
• Using and Managing Functions
• Using and Managing Packages
• Getting the Best out of Packages
• Improving PL/SQL Performance
• Using and Managing Triggers
• Recognizing and Managing Dependencies
• Using the PL/SQL Compiler

Presentations, demonstrations and practicals

• This induction session is free, there is a compulsory charge for access to the Oracle: Database Design and SQL (Online) course during and after the induction session. This which will be requested at the time of booking on that course as follows:

• £50 for University departments
• £50 + VAT = £60 for colleges and private payments from University members

• There are two external exams for those who wish to take it
  • Oracle Database 11g: Program with PL/SQL 1Z0-144
  • Program with PL/SQL 1Z0-147

One session of half a day

On-going. Enrollment can be at any time of the year though we offer an induction to the course twice a year.