Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: cnc programming course | cnc programming courses | introduction in presentation | introduction to finance | introduction to counselling | introduction to counselling courses | oracle warehouse builder training | presentation introduction | introduction to excel | introduction to business research
Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › Oracle Courses

Introduction To Oracle 9i/10g PL/SQL Programming

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£1,030 + VAT

Duration:

3 Days

Start:

02/12/2008 calendar
See course programme

Requirements:

A solid understanding of SQL and 3GL programming is required. It is recommended the student understand ... see more

Request free information

Course objectives:

The Oracle 10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of w...

PTR Associates Ltd

PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company ...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 3 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives The Oracle 10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of w...
Requirements
A solid understanding of SQL and 3GL programming is required. It is recommended the student understand Oracle 10g SQL features.
Price £1,030 + VAT
Get direct information on how to enrol, venues and availability...

Oracle courses (from other course providers)

 
Oracle
We Teach You
Distance - £50 + VAT
 
Oracle Series
Sales 101 Ltd
Online - £75 + VAT
Compare the selected courses
+ oracle Courses + Oracle Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Introduction To Oracle 9i/10g PL/SQL Programming
Course objectives:
The Oracle 10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

This course is targetted at application developers and database administrators.

Course content:
Triggers
  • Beyond Declarative Integrity
  • Triggers
  • Types of Triggers
  • Row-Level Triggers
  • Cascading Triggers and Mutating Tables
  • Generating an Error
  • Triggers on Views
  • System Triggers
  • Maintaining Triggers
    PL/SQL Variables and Datatypes
  • Declaring Variables
  • Datatypes
  • Subtypes
  • Character Data
  • Dates and Timestamps
  • Date Intervals
  • Anchored Types
  • Assignment and Conversions
  • Selecting into a Variable
    PL/SQL Syntax and Logic
  • PL/SQL Blocks and Programs
  • Conditional Statements – IF/THEN
  • Conditional Statements – CASE
  • Comments and Labels
  • Loops
  • WHILE and FOR Loops
    Stored Procedures and Functions
  • Stored Subprograms
  • Procedures and Functions
  • Creating a Stored Procedure
  • Calling a Stored Procedure
  • Passing Parameters and Default Arguments
  • Parameter Modes
  • Creating a Stored Function
  • Calling a Stored Function
  • Stored Functions and SQL
  • Local Procedures and Functions
    Exception Handling
  • SQLCODE and SQLERRM
  • Exception Handlers
  • Nesting Blocks
  • Scope and Name Resolution
  • User-Defined Exceptions
  • Compile-Time Warnings
    Records and Collections
  • Record Variables
  • Using the %ROWTYPE Attribute
  • VARRAY and Nested TABLE Collections
  • Using Nested TABLEs
  • Using VARRAYs
  • Associative Array Collections
  • Collection Methods
  • Iterating Through Collections
  • FORALL Statement
  • BULK COLLECT Clause
    Cursors
  • Multi-Row Queries
  • Declaring and Opening Cursors
  • Fetching Rows
  • Closing Cursors
  • The Cursor FOR Loop
  • FOR UPDATE Cursors
  • Cursor Parameters
  • The Implicit (SQL) Cursor
    Using Packages
  • Packages
  • Oracle-Supplied Packages
  • The DBMS_OUTPUT Package
  • The DBMS_UTILITY Package
  • The UTL_FILE Package
  • The DBMS_METADATA Package
  • XML Packages
  • Networking Packages
  • Other Supplied Packages
    Creating Packages
  • Structure of a Package
  • The Package Interface and Implementation
  • Package Variables
  • Overloading Package Functions and Procedures
  • Named Parameter Notation
  • REF CURSOR Variables
    Working with LOBs
  • Large Object Types
  • Oracle Directories
  • LOB Locators
  • Internal LOBs
  • External LOBs
  • Temporary LOBs
  • The DBMS_LOB Package
    Maintaining PL/SQL Code
  • Privileges for Stored Programs
  • PL/SQL Stored Program Compilation
  • The PL/SQL Execution Environment
  • Dependencies and Validation
  • Maintaining Stored Programs
    Appendix A - Dynamic SQL
  • Generating SQL at Runtime
  • Native Dynamic SQL vs. DBMS_SQL Package
  • The EXECUTE IMMEDIATE Statement
  • Using Bind Variables
  • Multi-row Dynamic Queries
  • Bulk Operations with Dynamic SQL
  • Using DBMS_SQL
  • DBMS_SQL Subprograms
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 02/12/2008 Finish: 04/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Oracle

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses Oracle | Courses Database | Courses Database Administration | Courses Oracle 10g | Courses Oracle database 10g | Courses PL/SQL | Courses SQL

    Information related to Oracle

    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: oracle warehouse builder 10g database design database architecture
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights