This hands-on course provides an in-depth technical introduction to the new developer-related features provided with Oracle9i Release 1 and Release 2. Detailed working examples, scripts and demonstrations (code provided, of course!) reinforce your understanding and prepare you for implementation in your shop. If you are an experienced Oracle8 or 8i Developer moving to Oracle9i, we guarantee you will benefit from and enjoy this class!
This course can be taught in 2 days if the students do not need all subjects.
Audience: Application Programmers, Developers, Designers, Analysts, System Architects, DBAs.
After successfully completing this course, you will be able to:
- Use the new SQL features provided with Oracle9i such as SQL CASE, ANSI joins, Multi-Table INSERT and MERGE.
- Create performant PL/SQL applications incorporating features such as associative arrays with character-based indexes, pipelined functions and natively compiled program units.
- Tune applications with Precise Query Statistics (V$SQL_PLAN, V$SQL_PLAN_STATISTICS),
- Write performant SQL statements using dynamic sampling and cursor sharing
- Use DBMS_STATS to collect statistics (instead of the deprecated ANALYZE command)
- Use table compression to reduce storage requirements and I/O counts
- Secure sensitive data with triple DES encryption (yes, we'll show you how and give you a chance to try it!)
- Decide if security features such as n-Tier Proxy Authentication, Fine Grained Access Control and Secure Application Roles work for your applications.
- Implement External Tables to query and load data from external files
- Use the new datetime datatype and associated functions to build applications that support fractional seconds
- Use the new datetime datatype and associated functions to build applications that support time zone data
- Implement and use Flashback Query to view table data at a previous point in time
- Begin developing applications using XML DB, Oracle's suite of XML support features
- Create tables with the XMLType datatype
- Insert and access XML documents within an XMLType column, including the use of XPath and XML functions such as EXTRACT and EXISTSNODE
- Implement new indexing techniques such as bitmap join indexes and Skip Scans
- Use Resumable Space Management t restart jobs that fail due to space-related errors
- Use the SQL Analytic functions (introduced with Oracle8i, enhanced in 9i. This is an optional, "if time permits" topic)