Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
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
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 10g: Administration I
Oracle Training Overview

This Oracle 10g courseware training guide book will allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification

Oracle Training Prerequisites

Mandatory prerequisites for this course are the following courses:
  • ORACLE DATABASE 10G: INTRODUCTION TO SQL COMPLETE LIBRARY
  • ORACLE DATABASE 10G: PROGRAM WITH PL/SQL PART II
Oracle Training Suggested Next Courses

This course should be considered the first part of the integrated database administrator curriculum. Therefore, in the not-too-distant future one should proceed to the follow-up course ORACLE DATABASE 10G: ADMINISTRATION II.

Oracle Training Audience

The target audience for this course is Oracle database administrators. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface

Oracle Training Objectives

Major tasks to be considered are:
  • Software installation and the creation of new databases.
  • An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
  • Management of database files.
  • Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  • Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
  • Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
  • Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
  • Control over database support services, including iSQL*Plus, the Database Control, Oracle Net and others.
  • A primer on backup and recovery structures and strategies.
  • Operating system-specific considerations for Unix, Linux and MS Windows
Certification Examination

This course along with its prerequisites cover information necessary to complete the certification test EXAM #1Z0-042 ORACLE DATABASE 10G: ADMINISTRATION I.

Oracle Training Course duration

3 Days

Oracle Training Course outline

INSTALLING ORACLE 10G DATABASE SOFTWARE
  • IDENTIFY DATABASE SYSTEM REQUIREMENTS
  • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
  • CONFIGURE THE INSTALLATION ENVIRONMENT
  • INSTALLATION USING THE UNIVERSAL INSTALLER
  • MORE ABOUT ENTERPRISE MANAGER
EXPLORING THE ORACLE DATABASE ARCHITECTURE
  • GENERAL DATABASE ARCHITECTURE
  • DATABASE INSTANCE MEMORY ARCHITECTURE
DATABASE INSTANCE PROCESS ARCHITECTURE
  • ABOUT THE INSTANCE PROCESS ARCHITECTURE
  • INSTANCE BACKGROUND PROCESSES
  • SQL EXECUTION PROCESSES
CREATING AN ORACLE DATABASE
  • CREATE A DATABASE
  • CONFIGURE & DROP A DATABASE
  • MANAGE DBCA TEMPLATES
  • MANUALLY CREATING A DATABASE
CONTROLLING THE DATABASE ENVIRONMENT
  • STARTING & STOPPING DATABASE CONTROL
  • STARTING & STOPPING ISQL*PLUS
  • STARTING & STOPPING THE DATABASE LISTENER
  • STARTING & STOPPING THE DATABASE
  • MORE ABOUT THE DATABASE FILES
  • HANDLING PARAMETER FILES & PARAMETER SETTINGS
STORAGE STRUCTURES: TABLESPACES
  • ABOUT TABLESPACES
  • TABLESPACE MANAGEMENT
STORAGE STRUCTURES: ADVANCED TABLESPACES
  • MORE ABOUT TEMPORARY TABLESPACES
  • ABOUT TEMPORARY TABLESPACE GROUPS
  • MORE ABOUT PERMANENT TABLESPACES
  • MORE ABOUT BIGFILE TABLESPACES
  • MORE ABOUT THE SYSAUX TABLESPACE
STORAGE STRUCTURES: DATA FILES & TEMP FILES
  • MANAGING DATA FILES
  • MANAGING TEMP FILES
  • ABOUT ORACLE-MANAGED FILES (OMF)
UNDO MANAGEMENT
  • ABOUT UNDO SPACE MANAGEMENT
  • CONFIGURE UNDO MANAGEMENT
  • GUARANTEE UNDO RETENTION
  • MONITOR UNDO SPACE
  • USE THE UNDO ADVISOR
DATABASE SECURITY
  • DATABASE SYSTEM PRIVILEGES
  • DATABASE OBJECT PRIVILEGES
  • AUDIT DATABASE ACTIVITY
  • REGISTER FOR SECURITY UPDATES
ADMINISTERING USERS
  • CREATE & MANAGE DATABASE ACCOUNTS
  • GRANT & REVOKE DATABASE PRIVILEGES
  • RESOURCE LIMITS VIA PROFILES
  • PASSWORD MANAGEMENT VIA PROFILES
  • ABOUT ROLE-BASED SECURITY
MANAGING DATA: LOADING DATA WITH SQL LOADER
  • ABOUT THE DATABASE UTILITIES
  • USING THE LOADER
  • UNDERSTANDING THE LOADER PROCESS
  • CONTROL FILE OPTIONS
  • DIRECT PATH LOADS
MANAGING DATA: EXPORTING & IMPORTING DATA
  • CREATE DIRECTORY OBJECTS
  • EXPDP
  • IMPDP
ORACLE NET SERVICES
  • WHAT IS ORACLE NET SERVICES?
  • ORACLE NET MANAGER
  • LISTENER CONFIGURATION
  • LISTENER ADMINISTRATION
  • LSNRCTL COMMANDS
  • CONFIGURING CLIENT PARAMETERS
  • ISOLATING THE PROBLEM
  • ORACLE TRACE ASSISTANT
  • NETWORK TROUBLESHOOTING UTILITIES
ORACLE SHARED SERVERS
  • SHARED SERVERS ARCHITECTURE
  • CONFIGURATION OF SHARED SERVER MODE
MONITORING & RESOLVING LOCK CONFLICTS
  • ABOUT LATCHES & LOCKS
  • MORE ABOUT LATCHES
  • MORE ABOUT LOCKS
BACKUP & RECOVERY CONCEPTS
  • ABOUT DATABASE BACKUP & RECOVERY
  • ABOUT REDO DATA
  • REDO LOG FILE MAINTENANCE
  • MANAGING THE ARCHIVE OPTIONS
  • MORE ABOUT THE CONTROL FILE

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy