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
# | Date | Time | Venue | Trainer | |
---|---|---|---|---|---|
1 | Thu 21 Nov 2013 09:30 - 11:00 * | 09:30 - 11:00 * | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Lynn Foot |
2 | Wed 6 Aug 2014 14:00 - 15:30 * | 14:00 - 15:30 * | University Information Services, Roger Needham Building, Ely Training Room 2 | map | Lynn Foot |
- 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
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.
Booking / availability