Book your Oracle Database: Program with PL/SQL Training Course
This five day course is being run 18 times between Monday 11th June 2012 and Monday 3rd December 2012 in Glasgow, London, Belfast, Reading, Manchester,
Book this course with us today from as little as £2,325.00 + 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 | Oracle | Glasgow |  | £2,325.00+VAT | ||
| Monday 11 June 2012 | QA | Glasgow | | Save £230.00 | £2,325.00+VAT | |
| Monday 25 June 2012 | QA | London | | £2,555.00+VAT | ||
| Monday 25 June 2012 | Oracle | London | | £2,555.00+VAT | ||
| Monday 02 July 2012 | Oracle | London | | £2,555.00+VAT | ||
| Monday 16 July 2012 | Oracle | Belfast | | £2,325.00+VAT | ||
| Monday 06 August 2012 | Oracle | Reading | | £2,325.00+VAT | ||
| Monday 20 August 2012 | QA | Manchester | | Save £230.00 | £2,325.00+VAT | |
| Monday 20 August 2012 | Oracle | Manchester | | £2,325.00+VAT | ||
| Monday 24 September 2012 | QA | London | | £2,555.00+VAT | ||
| Monday 24 September 2012 | Oracle | London | | £2,555.00+VAT | ||
| Monday 01 October 2012 | Oracle | Belfast | | £2,325.00+VAT | ||
| Monday 08 October 2012 | Oracle | London | | £2,555.00+VAT | ||
| Monday 05 November 2012 | QA | Glasgow | | Save £230.00 | £2,325.00+VAT | |
| Monday 05 November 2012 | Oracle | Glasgow | | £2,325.00+VAT | ||
| Monday 26 November 2012 | QA | London | | £2,555.00+VAT | ||
| Monday 26 November 2012 | Oracle | London | | £2,555.00+VAT | ||
| Monday 03 December 2012 | Oracle | Reading | | £2,325.00+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 starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. In addition, creation of anonymous PL/SQL blocks as well as stored procedures and functions are covered in this course.
PreRequisites:
Required Prerequisites:
• Oracle Database: Introduction to SQL (combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II listed)
• Oracle Database: SQL Fundamentals I
• Oracle Database: SQL Fundamentals II
Suggested Prerequisites:
• Previous programming experience
Audience:
• PL/SQL Developer
• Forms Developer
• Application Developers
• Database Administrators
• Technical Consultant
• Portal Developer
• System Analysts
• Developer
Objectives:
• Create and debug stored procedures and functions
• Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
• Design PL/SQL packages to group related constructs
• Create overloaded package subprograms for more flexibility
• Design PL/SQL anonymous blocks that execute efficiently
• Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
• Write dynamic SQL for more coding flexibility
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Manage dependencies between PL/SQL subprograms
• Handle runtime errors
• Create triggers to solve business challenges
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas, standardized constants and exceptions
Outline:
- Introduction
- Introduction to PL/SQL
- Declare PL/SQL Identifiers
- Write Executable Statements
- Interaction with the Oracle Server
- Control Structures
- Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures
- Stored Functions and Debugging Subprograms
- Packages
- Deploying Packages
- Implement Oracle-Supplied Packages in Application Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Triggers
- Creating Compound, DDL, and Event Database Triggers
- PL/SQL Compiler
- Manage PL/SQL Code
- Manage Dependencies
Description:
Participants enhance their developer skills by learning to develop, execute, and manage PL\SQL
stored program units such as procedures, functions, packages, and database triggers. Understanding the basic functionality of how to debug functions and procedures using the SQL
Developer Debugger gives way to refined lines of code. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers, and trapping exceptions. The utilization of some of the Oracle-supplied packages is also in the course. Additionally participants learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies.
Oracle
Oracle University is committed to providing world-class training and an unbeatable educational experience. So confident of delegate success, Oracle back up their training with a 100% Student Satisfaction program: If you are not completely satisfied with your training experience, you may re-take the same class for free.
In the past year, only one-third of 1% of Oracle University students requested a re-take of their class.
QA
QA training has over 25 years of experience of supplying high standard training courses in many Business, Management and IT Technical areas. Since 1983 the company has grown to have 25 training centres across the UK offering businesses routes to advance on a local and national level.
QA have a dedicated team of permanent instructors and teaching consultants who constantly improve the courses to ensure the highest possible standard of training is available.