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 R1 & R2: New Features For Administrators
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 review all of the major administration features and improvements introduced with Release 1 and Release 2 of the Oracle database version 10g. Students will be able to apply their experience with previous releases of the Oracle database to this new release, which offers numerous productivity and manageability improvements.

Oracle Training Prerequisites

The mandatory prerequisite for this course is extensive experience administering an Oracle database using version Oracle9i. Those who lack such experience would be better served by completing the curriculum for new database administrators comprising the following course modules:
  • The course ORACLE DATABASE 10G: ADMINISTRATION I
  • The course ORACLE DATABASE 10G: ADMINISTRATION II
Those who have experience administering Oracle databases prior to Oracle9i should at least obtain and read the following course before proceeding onto this course:
  • The course ORACLE 9i NEW & ADVANCED FEATURES FOR ADMINISTRATORS
Suggested Next Courses

Administrators may wish to obtain additional experience in the operating system platform on which their Oracle databases have been deployed. This is available from the curricula for MS Windows Server, Linux and UNIX. As alluded to above, the following Oracle courses are suggested to follow this course:
  • The course ORACLE DATABASE 10G: SQL TUNING
  • The course ORACLE DATABASE 10G: DATA WAREHOUSES
  • The course ORACLE DATABASE 10G: IMPLEMENT PARALLEL SQL & PARTITIONING
Oracle Training Objectives

Within this course, students will learn how to:
  • Install and initially configure, or upgrade an Oracle10g database.
  • Load and unload data between databases using the Data Pump architecture.
  • Enable and configure automatic database management.
  • Utilize advanced self-tuning and self-management capabilities, including the use of the database Advisors and other components of the Management Framework.
  • Take advantage of the new recovery features available from flashback, flashback database, the flash recovery area and RMAN enhancements.
  • Enable and use general storage management enhancements and incorporate the powerful new automatic storage management (ASM) option.
  • Work within the changed Enterprise Manager (EM) interface and the database control.
Oracle Training Audience

The target audience for this course is database administrators with experience using Oracle9i, wanting to learn about the new and modified features introduced in Oracle10g

Oracle Training Certification Examination

This course covers information necessary to complete the following certification test:
  • EXAM #1Z0-040 ORACLE DATABASE 10G: NEW FEATURES FOR ADMINISTRATORS
Oracle Training Course duration

5 Days

Oracle Training Course outline

INSTALLING ORACLE 10G DATABASE SOFTWARE • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA) • ORACLE_BASE • ORACLE_HOME • CONFIGURE THE INSTALLATION ENVIRONMENT • INSTALLATION USING THE UNIVERSAL INSTALLER • MORE ABOUT ENTERPRISE MANAGER • REGISTER FOR SECURITY UPDATES

CREATING AN ORACLE DATABASE • CREATE A DATABASE • CONFIGURE & DROP A DATABASE • MANAGE DBCA TEMPLATES

CONTROLLING THE DATABASE ENVIRONMENT • STARTING & STOPPING DATABASE CONTROL • STARTING & STOPPING ISQL*PLUS • DATABASE LISTENER CONFIGURATION USING EM • STARTING & STOPPING THE DATABASE • HANDLING PARAMETER FILES & PARAMETER SETTINGS

MANAGING DATA: EXPORTING & IMPORTING DATA • CREATE DIRECTORY OBJECTS • ABOUT THE DATA PUMP ARCHITECTURE • DATA PUMP EXPORT • DATA PUMP IMPORT • DATA PUMP DATA DICTIONARY VIEWS • USING THE EM INTERFACE

STORAGE STRUCTURES: TABLESPACES, DATA FILES & TEMP FILES • ABOUT ORACLE 10G TABLESPACES • TABLESPACE MANAGEMENT • MORE ABOUT PERMANENT TABLESPACES • About DATABASE_PROPERTIES • MORE ABOUT TEMPORARY TABLESPACES • MORE ABOUT BIGFILE TABLESPACES • MORE ABOUT THE SYSAUX TABLESPACE • MANAGING DATA FILES

UNDO MANAGEMENT • ABOUT UNDO SPACE MANAGEMENT • CONFIGURE UNDO MANAGEMENT • UNDO_MANAGEMENT • UNDO_TABLESPACE • UNDO_RETENTION • GUARANTEE UNDO RETENTION • MONITOR UNDO SPACE • USE THE UNDO ADVISOR

PERFORMANCE MONITORING & PROACTIVE MAINTENANCE • THE MANAGEMENT & ADVISORY FRAMEWORK • MANAGING THE AUTOMATIC WORKLOAD REPOSITORY • AUTOMATIC DATABASE DIAGNOSTIC MONITOR • METRICS & ALERT THRESHOLDS • USING THE SEGMENT ADVISOR • MTTR ADVISOR & TUNING CHECKPOINTS • LOG_CHECKPOINTS_TO_ALERT • REDO LOG FILE SIZE ADVISOR • ISOLATING PERFORMANCE PROBLEMS • AUTOMATIC OPTIMIZER STATISTICS COLLECTION • GATHER_STATS_JOB

ORACLE FLASHBACK TECHNOLOGY • ABOUT FLASHBACK TECHNOLOGY • FLASHBACK QUERY • SELECT...AS OF TIMESTAMP • SELECT...AS OF SCN • FLASHBACK TABLE • FLASHBACK DROP • FLASHBACK VERSIONS QUERY • FLASHBACK TRANSACTION QUERY

FLASHBACK DATABASE • ABOUT FLASHBACK DATABASE • CONFIGURING THE FLASH RECOVERY AREA • MONITORING FLASHBACK DATABASE PERFORMANCE • FLASHBACK DATABASE CONSIDERATIONS

RMAN ENHANCEMENTS • RMAN & DATABASE RECOVERY ENHANCEMENTS • INCREMENTAL CUMULATIVE MERGE BACKUPS • CROSS-PLATFORM TRANSPORTABLE TABLESPACES

MANAGING RESOURCES • DATABASE RESOURCE MANAGER ARCHITECTURE • CONSUMER GROUPS • RESOURCE PLANS • AUTOMATIC & ADAPTIVE CONSUMER GROUP MAPPING • ENABLING & MONITORING THE RESOURCE MANAGER • EXPLICIT CONSUMER GROUP SWITCHING

AUTOMATING TASKS WITH THE DATABASE SCHEDULER (BASIC) • SCHEDULER ARCHITECTURE • MANAGE PROGRAMS • MANAGE SCHEDULES • MANAGE JOBS

AUTOMATING TASKS WITH THE DATABASE SCHEDULER (ADVANCED) • MANAGE JOB CLASSES • MANAGE WINDOWS & WINDOW GROUPS • MANAGE CHAINS • ABOUT EVENTS & THE SCHEDULER

MONITORING & MANAGING MEMORY • AUTOMATIC SHARED MEMORY MANAGEMENT • USING EM & THE MEMORY ADVISORS • MONITOR IN MEMORY ACCESS MODE

AUTOMATIC STORAGE MANAGEMENT • ASM & THE BROADER DATABASE ARCHITECTURE • DEFINING AN ASM INSTANCE • CONFIGURING STORAGE IN THE ASM INSTANCE • ASM & THE ORACLE UNIVERSAL INSTALLER • ASM & THE DBCA • USING ASMCMD • MIGRATING AN EXISTING DATABASE TO ASM

MISCELLANEOUS ENHANCEMENTS • MANAGING THE REDO LOG BUFFER • LOGMINER ENHANCEMENTS • RESUMABLE SPACE ALLOCATION ENHANCEMENT • AUDIT DATABASE ACTIVITY OPTIONS • THE PRINCIPLE OF LEAST PRIVILEGE • REGULAR EXPRESSIONS


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