www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Oracle 10g - New Features for Developers Training Course UK

Dates and full course list

Oracle 10g - New Features for Developers Course Overview

Course Code:	ORC0040
Price:	£1250
Duration:	3 days
Date:
Who should attend:	The course is suitable for technical personnel involved in the development and maintenance of Oracle applications and those who have completed the Introduction to SQL and/or SQL*Plus course.
Prerequisite Skills:	Delegates should have a good knowledge of their operating system, SQL*PLUS and PL/SQL and previous versions of Oracle database..

The course outlines the major new features of the Oracle 10g database and tools set which are relevant to a developer and provides an environment in which to gain hands on experience of there use. Lectures are combined with sets of exercises designed to illustrate the points covered. These exercises are to be completed by the delegate.

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

Course Objectives

1. how to make use of 10g database new features.
2. how to make use 10g SQL & PLSQL enhancements
3. the enhancements to the oracle 10g tools set.

Oracle New Features for Programmers - Training Course Outline

SQL Enhancements

Merge Functionality
Commit timestamp
Materialized view enhancements
Partitioning
Other SQL Enhancements & ANSI Compliancy
Flashback Query
Flashback Transaction
Flashback Table
Flashback using SCN or Timestamp
Flashback Row History
The Recycle bin
SQL Tuning Advisor
SQL Hints

PLSQL Enhancements

New Built-in Packages
Variable enhancements

Forms & Reports Enhancements

Architecture changes
Single Sign on Support
Java Support
The Java Importer
Image Support
Javascript support
OC4J & BI Bean support
Debugger enhancement

Other Enhancements

Partitioning
Automatic Statistics Collection
External Tables
Object Inheritance
Rename tablespaces
Big File Tablespaces

Associated Courses

Oracle 11g New Features Training Course for Programmers and DBAs

Introduction to Oracle SQL

Introduction to Oracle PL/SQL

Oracle 10g DBA Combined ('Fundamentals')

Oracle 10g - New Features for Developers

Oracle 10g DBA - part 1

Oracle 10g DBA - part 2

Oracle 10g Performance & Tuning

Oracle 6i Reports

Oracle 6i Forms

Oracle Forms & Reports 5-day Hybrid

Oracle 9i Intro to SQL

Oracle 9i Intro to PL/SQL

Oracle 9i New Features

Oracle 9i Performance Tuning