Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle9i New & Advanced Features for Developers
Oracle Training Overview

This course is designed for senior application developers who will be moving to the Oracle9i database platform. This course introduces the new and advanced features of the database introduced in its 9i release.

Oracle Training Prerequisites

  • The course Introduction to Oracle9i SQL
  • The course Introduction to Oracle9i PL/SQL Language
  • The course Introduction to Oracle9i Advanced SQL
Oracle Training Audience

This course is designed for senior application developers who will be moving to the Oracle9i database platform. This course introduces the new and advanced features of the database introduced in its 9i release.

Oracle Training Course duration

5 Days

Oracle Training Course outline

USING ISQL*PLUS
  • USING ISQL*PLUS
  • CONFIGURING ISQL*PLUS
ADVANCED SQL LANGUAGE CONSTRUCTS
  • CASE STATEMENT WITHIN PL/SQL
  • CASE EXPRESSION WITHIN SQL
  • COALESCE() FUNCTION
RETRIEVING DDL WITH DBMS_METADATA()
  • WHY RETRIEVE OBJECT DEFINITIONS?
  • RETRIEVING DEFAULT METADATA
  • RETRIEVING CUSTOMIZED METADATA
ADVANCED DBMS_METADATA() PROCESSING

PROCESSING DEPENDENT OBJECTS WITH DBMS_METADATA()
  • RETRIEVING PRIMARY & DEPENDENT OBJECT DDL
REDEFINING TABLES WITH DBMS_REDEFINITION()
  • USING THE DBMS_REDEFINITION() PACKAGE
DATA WAREHOUSING FEATURES (EXTERNAL TABLES)
  • ABOUT EXTERNAL TABLES
  • CREATING & ACCESSING EXTERNAL TABLES
  • PERFORMANCE CONSIDERATIONS
  • VIEWING & ALTERING PROPERTIES OF EXTERNAL TABLES
DATA WAREHOUSING FEATURES (TABLE FUNCTIONS)
  • IMPLEMENTING A PIPELINED TABLE FUNCTION
DATA WAREHOUSING FEATURES (ANALYTIC FUNCTIONS)
  • UNDERSTANDING ANALYTIC FUNCTIONS
  • USING RANKING AND BANDING FUNCTIONS
  • USING WINDOWING FUNCTIONS
  • USING LAGGING AND LEADING FUNCTIONS
  • USING REPORTING AGGREGATES
COMPLEX SQL OPERATIONS
  • USING MULTI-TABLE INSERT METHODS
  • USING THE MERGE STATEMENT
  • USING ANSI STANDARD JOINS
  • USING NAMED SUBQUERIES
SQL STATEMENT TUNING
  • ABOUT ENHANCED SQL STATEMENT TUNING
  • FIRST_ROWS
  • ORACLE9I SQL TUNING HINTS
  • CURSOR PEEKING & CURSOR SHARING
  • MONITORING INDEX USAGE
EDITING PRIVATE OUTLINES
  • ABOUT EDITING PRIVATE OUTLINES
  • PREPARING FOR PRIVATE OUTLINES
  • CREATING PRIVATE OUTLINES
  • EDITING PRIVATE OUTLINES
  • UTILIZING PRIVATE OUTLINES
COLLECTING SYSTEM STATISTICS
  • MANAGING SYSTEM STATISTICS
FLASHBACK QUERY
  • IMPLEMENTING FLASHBACK QUERY
  • ABOUT THE DBMS_FLASHBACK() PACKAGE
  • USING THE DBMS_FLASHBACK() PACKAGE
WORKSPACE MANAGER
  • WORKSPACE OPERATIONS
  • HANDLING CONFLICT RESOLUTION
  • UTILIZING SAVEPOINTS
  • SESSION INFORMATION & DDL OPERATIONS
  • A COMPLETE WORKSPACE MANAGER SCENARIO
INVOKING EXTERNAL FEATURES


Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved