Book your Oracle Program with PL/SQL Training Course
This five day course is being run five times between Monday 11th June 2012 and Monday 3rd December 2012 in London,
Book this course with us today from as little as £1,525.50 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Provider | Location | Rating | Price | ||
|---|---|---|---|---|---|---|
| Monday 11 June 2012 | StayAhead | London |  | Save £169.50 | £1,525.50+VAT | |
| Monday 23 July 2012 | StayAhead | London | | Save £169.50 | £1,525.50+VAT | |
| Monday 17 September 2012 | StayAhead | London | | Save £169.50 | £1,525.50+VAT | |
| Monday 29 October 2012 | StayAhead | London | | Save £169.50 | £1,525.50+VAT | |
| Monday 03 December 2012 | StayAhead | London | | Save £169.50 | £1,525.50+VAT |
|
|
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Summary:
This course is designed for Oracle programmers and developers and provides practical experience in writing stand-alone PL/SQL programs and database triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.
PreRequisites:
Attendance on the pre-requisite course Oracle SQL*Plus or iSQLPlus products and practical experience in writing SQL statements. Some prior programming experience will also prove advantageous.
Objectives:
By the end of this course, the delegate will be able to write PL/SQL programs, manage stored program units, implement package constructs and handle Large Objects programmatically. The content of the course covers all the topics required for the Oracle PL/SQL Developer Certified Associate Examination #1Z0-147.
Outline:
- The PL/SQL Program Structure
- Variables and Constants
- Using SQL in PL/SQL Programs
- Generating Output
- IF Statements and LOOP Constructs
- Using Cursors
- Handling Exceptions
- PL/SQL Records and Tables
- Creating Triggers, Stored Procedures and Functions
- Passing Parameters to Stored Program Units
- Creating Packages
- Implementing Package Features and Constructs
- Using PL/SQL Records and Tables in Packages
- Managing Stored Program Units
- Using Native Dynamic SQL
- Overview of Oracle-supplied Packages
- The DBMS_LOB Package for Handling Large Objects
Description:
This course is designed for Oracle programmers and developers and provides practical experience in writing stand-alone PL/SQL programs and database triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.
StayAhead
StayAhead training has been offering high quality IT technical training courses since 1992. They specialise in UNIX, Oracle, Linux and MySQL training and pride themselves on the long term investments they put into attending delegates.
StayAhead has gained a reputation for offering high quality courses and is ranked as one of the UK’s top 50 business organisations in 2008.