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: Implement Parallel SQL & Partitioning For Data Warehouses
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 equip database professionals with the advanced skills needed to administer data warehouses. As the size of databases and data warehouses increases, one cannot rely upon the default features of the Oracle database to sufficiently process such massive volumes of information. One must employ advanced features intended for such environments. In fact, these features are at the same time, among the most powerful tuning options available within the Oracle database yet some of the least understood and utilized.

Oracle Training Prerequisites

Mandatory Prerequisites

The following courses are mandatory prerequisites for taking this course:
  • The course ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY
  • The course ORACLE DATABASE 10G: SQL TUNING
Recommended Prerequisites

  • The course ORACLE DATABASE 10G: ARCHITECTURE FOR DEVELOPERS
Oracle Training Suggested Next Courses

The following course is recommended because the outline you are now viewing is itself a mandatory prerequisite for the following course title:
  • The course ORACLE DATABASE 10G: DATA WAREHOUSES I
Oracle Training Audience

The target audience for this course is database administrators, data warehouse administrators, and senior application developers. In fact, managers and any other information technology or database professionals who will interact with very large databases (VLDB) would benefit from this course.

Oracle Training Objectives

The purpose of this course is to equip database professionals with the skills to utilize such advanced features as these:
  • The full range of table partitioning options, including range, hash, list, and composite partitioning schemes.
  • The full range of index partitioning options, including local and global partitioned indexes.
  • Discuss the broad conceptual rationales one may base partition schemes on. These various possibilities are illustrated using two different sample data models.
  • The performance benefits of using database object partitions and monitoring the execution of SQL statements under the control of the partition-aware Optimizer.
  • Understanding the operations within a complex SQL execution plan which operates in parallel upon partitioned objects.
  • General principles of parallel processing and their use in Oracle database technology.
  • The specific feature of parallel SQL execution and the configuration options available to activate and administer this technology
Oracle Training Course duration

3 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