On-line training course catalogue
Oracle9i: Program with PL/SQL
Type of course: Classroom
| Fee | £2200 |
|---|---|
| Days | 5 |
| Course code | OR9IPLSQL |
We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.
Print this page | Download as Word document |
Overview
Please note that Oracle courses running at London training centres are subject to a 5% surcharge.
This course is intended for Application Developers, System Analysts, Database Administrators and Technical Support Personnel. This course introduces delegates to PL/SQL and helps them understand the benefits of this powerful programming language. Delegates learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications. Delegates also learn how to create procedures, functions, packages and database triggers. iSQL*Plus is used to develop these program units. Finally, delegates learn how to manage PL/SQL program units and database triggers to manage dependencies, to manipulate large objects and to use some of the Oracle-supplied packages.
Prerequisites
Delegates must have some experience of working with iSQL*Plus. Delegates should also have attended course SQLINT (Introduction to Oracle9i: SQL) or SQLEXP (Introduction to Oracle9i for Experienced SQL Users). Some 3GL programming experience or awareness of programming constructs and techniques would be beneficial.
Delegates will learn how to
- Describe the features and syntax of PL/SQL
- Handle run-time errors Create, execute and maintain procedures, functions, packages and triggers
- Conditionally control code flow (loops, control structures and explicit cursors)
- Describe Oracle-supplied packages Manage program constructs
- Manipulate large objects Manage dependencies
Outline
- Overview of PL/SQL
- PL/SQL Blocks and Declaring Variables
- Writing Executable Statements
- Interacting with Oracle Server
- Writing Control Structures
- Working with Composite Datatypes
- Writing Explicit Cursors A
- dvanced Explicit Cursor Concepts
- Handling Exceptions
- Creating Procedures
- Creating Functions
- Managing Subprograms
- Creating Packages
- More Package Concepts
- Using Oracle-supplied Packages
- Manipulating Large Objects
- Creating Database Triggers
- More Trigger Concepts
- Managing Dependencies
Related Certifications
This course forms part of the following certification track(s):
Link to this page: http://www.xpertise.co.uk/OR9IPLSQL
Xpertise – Oracle9i: Program with PL/SQL training courses
Xpertise provides Oracle9i: Program with PL/SQL training courses from 7 UK locations: in Altrincham Manchester, Hinckley East Midlands, Leeds Yorkshire, London King William Street, Maidenhead Berkshire, Malmesbury Wiltshire and Washington Tyne & Wear – and at 44 partner locations nationwide.
Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.