Duration: 5 days
Description
This course combines the Oracle9i New Features for DBA and developer courses to give a comprehensive overview of the new features in Oracle9i Release 1 and Release2. Students will learn the new feature/functionality on the database and application side.
Topics
- New globalization and Unicode features
- New CROSS, NATURAL, INNER and OUTER join syntax
- Database workspaces
- Data Guard
- Data Guard Logical standby
- Automated consumer group switching
- Improved memory management
- Real Application Clusters and Cache Fusion
- New data warehouse features
- New view constraints
- MERGE statements
- FOR UPDATE WAIT statement
- Grouping sets
- New built-in SQL functions
- PL/SQL enhancements
- Analytical functions
- Table enhancements
- Multiple table inserts
- Default column value changes
- CBO enhancements
- Enhancements to object-relational features
- Multiple block sizes
- Multiple block sizes
- Enhanced security features
- New Java and XML features
- Enhancements to Standby databases
- Automated consumer Group switching
- Global index management
- Extensions to Advanced Queuing
- Data warehouse enhancements
- CASE expressions
- Cursor subqueries
- List partitioning
- New schema objects
- Using External tables
Prerequisites
- Working experience in an Oracle8i environment.
|