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
Python
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
Oracle Database 10g: New & Advanced Features For Developers
This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Oracle training, SQL Server training, MS Access training, Powerbuilder training, Visual Foxpro training, DB2 training, Crystal Reports training, Sybase training, Cognos training and Datawarehousing training
Oracle Training Overview

This Oracle 10g courseware training guide book will present some of the most advanced features available to database developers. Many of these features are either newly available with the Oracle10g release or have been substantially improved with that release

Oracle Training Prerequisites

The following courses are mandatory prerequisites:
  • ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY
  • ORACLE DATABASE 10G: PROGRAM WITH PL/SQL – COMPLETE LIBRARY
Suggested Prerequisites

ORACLE DATABASE 10G: SQL TUNING
  • ORACLE DATABASE 10G: ARCHITECTURE FOR DEVELOPERS
  • ORACLE DATABASE 10G: ADVANCED PL/SQL PROGRAMMING & TUNING
  • ORACLE DATABASE 10G: SQL TUNING should ideally be taken prior to this course but it is an acceptable alternative to complete that course after finishing this one.
  • ORACLE DATABASE 10G: ARCHITECTURE FOR DEVELOPERS and ORACLE DATABASE 10G: ADVANCED PL/SQL PROGRAMMING & TUNING
Oracle Training Important Curriculum

One of the most substantial changes of interest to developers within the Oracle10g release is the matter of SQL tuning. The fundamental means by which this task is approached and accomplished has almost completely changed with the Oracle10g release. This is addressed separately in the one-week course entitled ORACLE10G DATABASE: SQL TUNING. That course may be taken either before or after this course, but it should be considered as a mandatory complement to this course.

Oracle Training Objectives

Among the specific subjects presented in this course are:
  • A review of the grid-computing and manageability architecture available from the Oracle 10g release of the database and the application server.
  • Database flashback technology, including flashback queries, flashback table, flashback versions query and flashback transaction query capabilities.
  • Creating and using directory objects within the database.
  • The Data Pump Export and Import utilities.
  • A comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, linguistic, bitmap and bitmap join indexes.
  • A comprehensive look at all table types available when building an application schema, including heap-organized tables, index clusters, hash clusters, index-organized tables, external tables, temporary tables and compressed tables.
  • Advanced SQL hierarchal data processing capabilities available from the CONNECT BY PRIOR and related language structures.
  • Enhanced SQL and transactional capabilities, including asynchronous commits, DML error trapping and use of regular expressions.
  • Enhanced PL/SQL programming capabilities and compiler directives.
  • A brief glimpse into the Enterprise Manager database interface which may be of occasional use to senior developers
Oracle Training Course duration

4 Days

Oracle Training Course outline

ABOUT PARTITIONING & PARALLELIZATION • ABOUT THE ARCHITECTURE • METHODS OF PARTITIONING

CREATING PARTITIONED TABLES
• CREATE A RANGE PARTITIONED TABLE
• CREATE A HASH PARTITIONED TABLE
• CREATE A LIST PARTITIONED TABLE
• CREATE A RANGE-HASH PARTITIONED TABLE
• CREATE A RANGE-LIST PARTITIONED TABLE
• PARTITION SCENARIOS

MANAGING TABLE PARTITIONS • USING SUBPARTITION TEMPLATES • MANAGING TABLE PARTITIONS & SUBPARTITIONS

CREATING & MANAGING PARTITIONED INDEXES
• ABOUT PARTITIONED INDEXES
• CREATE LOCAL PARTITIONED INDEXES
• CREATE GLOBAL PARTITIONED INDEXES
• TABLE MAINTENANCE IMPACT ON INDEX PARTITIONS
• MANAGING INDEX PARTITIONS & SUBPARTITIONS
• EQUI-PARTITIONING OF TABLES

THE PARTITION-AWARE OPTIMIZER • SETUP FOR OPTIMIZATION MONITORING • PARTITION-AWARE OPTIMIZATION

PARALLEL PROCESSING WITHIN THE ORACLE DATABASE
• HARDWARE CONFIGURATIONS
• ORACLE INSTANCE PARALLEL PROCESSING
• ABOUT DATABASE PARALLEL SQL EXECUTION

ENABLING & TUNING PARALLEL SQL EXECUTION
• ENABLING PARALLEL EXECUTION
• CONTROLLING THE DEGREE OF PARALLELISM
• MANUALLY TUNING PARALLEL OPERATIONS
• About PARALLEL_THREADS_PER_CPU & The Default DOP
• PARALLEL PROCESSING OPTIMIZER HINTS
• [NO]PARALLEL
• [NO]APPEND
• [NO]PARALLEL_INDEX
• EXPLAINING A PARALLEL EXECUTION PLAN

ADVANCED TUNING OF PARALLEL EXECUTION

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