	Training/Mentoring

	E-Business Suite
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Training/Mentoring
		The Service
		The Value
		References
		Contact Us / Registration
		Oracle Certification Prep
		Pricing
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing

Oracle 10g New Features for Developers

Click here to contact us

Course Overview

Oracle 10g New Features for Developers introduces students to major new database features in Oracle 10g that are relevant to application development. Some of the features are demonstrated and experienced through hands-on lab exercises. This course intentionally doesn't cover ALL new features introduced in Oracle 10g. There simply wouldn't be enough time to afford any single one of them a justified treatment if the effort is to cover them all. There are simply too many new features. If such an unfair effort is made to cover ALL new features, it is doubtful there would be real learning experienced by the student of any one feature. Such an approach would be only slightly beyond what would be gained by reading a new features list. On the contrary, a selection of very good and useful features is covered in fair depth in this course. There is an accelerated segment of time at the end rse that introduces many other new features.

Course Goals

To describe major new 10g features in a conceptual manner
To practice the use of some of the features by implementing them in lab exercises
To facilitate discussion of student questions about the concepts and implementation of the features

Prerequisites

SQL & SQL*Plus
PL/SQL
Application Tuning

Who Should Attend?

Database administrators and developers

Course Materials

10g New Features for Developers Course Notes
10g New Features for Developers Sample Script Disk
10g New Features Reference Book

Duration

Two days

Tuition

$930

Course Outline

Language and application development features
- SQL (regex, model clause, etc.)
- Commit timestamp/scn table pseudocolumns
- Expression filter
- PL/SQL
- XML
- Unicode
- Column-level VPD
- Flashback
  - Flashback version query
  - Flashback transaction query
  - Flashback table and the recycle bin
- Flashback drop
- Rename tablespace command
- Object-relational database
Data mining
Analytics
Oracle text
Application design and management features
- HTML DB
- Data warehousing
  - Data pump
  - Using external tables to unload data
  - Merge functionality
  - Materialized view enhancements
  - TUNE_MVIEW view
  - Partitioning
  - Partitioning IOTs
  - Easier partition maintenance
Application design and management features -- continued
Oracle streams
Pertinent DBMS* packages
Security
- Column-level VPD
- DBMS_CRYPTO PL/SQL package
- Auditing enhancements
Performance improvement and management
- Optimizer changes/improvements
- Advisors and statistics
  - ADDM and AWR
  - SQL tuning advisor
  - SQL access advisor
  - Automatic statistics collection
- Wait event enhancements
- DBMS_TRACE
- New/changed SQL hints
- Buffer cache flush
- OEM enhancements useful for performance diagnosis and management (performance overview charts, etc.)
- Bitmap indexes on range/hash/list partitioned IOTs sorted hash clusters