Oracle Training Overview
This course will prepare application developers to take advantage of new features in Oracle's flagship server product, Oracle8i (version 8.1.5 and above). Through lecture and extensive hands-on workshops, you will learn how to critical new features regarding PL/SQL, Java, OO support, partitioning, materialized views, query enhancements, security enhancements and more.
Oracle Training Prerequisites
You must have Oracle PL/SQL development experience and familiarity with SQL*Plus and basic Oracle concepts such as data types. This can be acquired in the Introduction to Oracle8i for Developers course.
Course duration
3 Days
Oracle Training Course outline
- 8.0 New Features and Options
- 8.1 New Features and Options
- Oracle8 Object Oriented Features
- What is OOP?
- Abstraction
- Encapsulation
- Polymorphism
- Types Overview
- Basic, Collection, References, User-Defined types
- Creating and Dropping User-Defined types
- Constructor Method
- Indexes
- Object Tables
- REF/DEREF
- Objects and Methods
- Member Methods
- MAP Function
- ORDER Function
- Using Persistent and Transient Objects in PL/SQL
- Collections
- Nested Tables
- VARRAYs
- Initializing, Assigning, Referencing, Comparing, Manipulating Collections
- CURSOR Operator
- Built-in Methods
- Exceptions
- Large Objects
- LONG to LOB Conversions
- LOB Architecture
- DBMS_LOB
- Temporary LOBs
- PL/SQL Enhancements
- Autonomous Transactions
- Bulk Binding
- Definer vs. Invoker Rights
- Native Dynamic SQL (NDS)
- Monitoring and Tracing PL/SQL
- Database Enhancements
- DROP COLUMN
- Temporary Tables
- Deferred and Enforced Constraints
- Database Event Triggers
- Partitioning
- Oracle8i Partitioning
- Range Partitioning
- Hash Partitioning
- Composite Partitioning
- Row Movement
- Index Enhancements
- Function-based Indexes
- Reverse Key Indexes
- Descending Indexes
- Index-Organized Tables
- Summary Management
- Materialized Views
- Indexing M-Views
- DBMS_OLAP
- Dimensions
- External Routines
- C Callout Architecture
- Calling External Routines
- Parameters
- Java in Oracle8i
- Oracle's Java Strategy
- Java Components: JServer, JDBC, SQLJ, CORBA, EJB, Jdeveloper
- Java Installation
- Calling Java from Oracle
- Oracle8 ROWID
- Oracle7 vs. Oracle8
- DBMS_ROWID
- PLAN_TABLE Changes
- New PLAN_TABLE definition
- Explaining a query
- Optimizer Enhancements
- Plan Stability
- DBMS_STATS
- Index Statistics
- Query Features
- ROLLUP
- CUBE
- Top-N Queries
- Data Sampling
- TRIM Function
- Security Enhancements
- Virtual Private Database
- Fine Grain Access Control
- Application Context
Hardware/Software Requirements
- Hardware Requirements
- Minimal Processor: Pentium 166 or Pentium 200
- Recommended Processor: Pentium 233 or Pentium 266
- RAM: 128 MB (256 MB recommended)
- Oracle Corporation also recommends increasing virtual memory to 200 MB. (Modify it in the Performance tab of System Properties in the Control Panel.)
- Available Disk Space (FAT or HTFS): 3 GB
- Video: 256 color
- A connection to the Internet is desirable (but not absolutely necessary) to show students various Oracle-related sites.
- Software Requirements
- Windows NT 4.0 or Windows 2000
- Oracle8i 8.1.6 or above
- Java JDK 1.1.5 or above*
- Microsoft Internet Explorer 5 or Netscape Navigator 4.5
- Adobe Acrobat Reader or Acrobat 4.0 or later (for the course presentation)*
- Student Files
- Text Editor*
|
