Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

Oracle10g Database Administration OCA Preparation Class

A five-day on-site Oracle Certified Associate OCA Training Course
Test 1Z1-042

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

 

 

Key Features

* Learn Oracle DBA Concepts.

* Understand Concurrency Management.

* Employ DBA Management.

* Use Oracle Performance Tuning.

* See Oracle security and user management.

 

  

Course Description

The primary goal is this course is to prepare the students to pass the Oracle10g OCA Database Administration exam 1, a prerequisite for exam 2, test 1Z1-043 for the Oracle10g OCP.  This Oracle10g OCP course is an intensive 5-day course is designed to provide Oracle professionals with an in-depth understanding of the DBA concepts and knowledge required for the OCA exam, and tips and techniques for passing the Oracle10g OCA exam.

This course covers all of the Oracle10g Database Administration topics on the OCP exam including SGA instance management, file & tablespace management, user administration & security and table & index management.

exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle10g OCP exam.  In addition, this course provides sample OCP exam questions and an opportunity to access your overall knowledge of Oracle DBA concepts.

Audience

This Oracle OCA DBA exam review training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle 10g database administration.  This includes Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand the architecture of an Oracle database.  The course assumes a basic knowledge of computer programming techniques, relational database concepts, SQL, and basic Oracle architecture.

Curriculum Design

This Oracle OCA training was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle tuning training.

Learning Objectives:

The primary objective of this Oracle10g OCA training is to provide each student with the knowledge and testing secrets for passing the Oracle10g OCA exam.  The student will gain confidence in their Oracle DBA knowledge and learn the tricks and traps of the Oracle10g OCA DBA exam.

Using a proven training combination of intense instruction, practicum and numerous Oracle10g OCA sample exam questions, the student should have a firm understanding of Oracle10g Database Administration.  The student will successfully install and configure a working Oracle database, create tablespaces and files, manage security and user access and learn basic performance tuning.



Oracle 10g Certified Professional
Oracle10g Database Administration OCA Exam Preparation

 
Test 1Z1-042
Copyright © 2007-2016 by Burleson Corporation
 
Syllabus

 

Day 1: Oracle DBA Concepts
 
Oracle10g Instance creation and management
 
What is an Oracle Instance?
Installing Oracle
Oracle Optimal Flexible Architecture (OFA)
Locating initialization, listener.ora & sqlnet.ora files
Finding the alert log
Common environment variables
Structures in an Oracle Instance
            Oracle Memory Structures, SGA and PGA
            Oracle Processes and their purposes
Startup nomount, mount and open database commands
Sample Oracle10g OCP exam questions
 
Oracle10g Database Architecture
 
Oraclde10g management framework
Using the Database Creation Assistant (DBA)
Creating and dropping a database
Tablespaces
Tables and Indexes
Clusters
Partitioning of Tables and Indexes
Gathering and applying patches
Sample Oracle10g OCP exam questions
 
 
Day 2:
 
Concurrency Management
 
Transactions, serialization, locks and latches
Lock modes
Detecting and resolving lock conflicts
Managing deadlocks
 
Interfacing with Oracle
 
Oracle transaction management
Using SQL*Plus and iSQL*Plus
Using embedded Oracle with Pro*C & Java
PL/SQL & Triggers
Pining PL/SQL packages & compiling PL/SQL
System-level triggers – startup trigger, logon trigger, PL/SQL error trigger
 
 
Oracle*Net
 
Basic Network structure
Oracle*Net Files
Multi-threaded server
Create additional listeners
Create Oracle Net service aliases
Configure connect time failover
Use ping and tnsping
Oracle*Net names resolution
Sample Oracle10g OCP exam questions
 
 
Day 3: DBA Management
 
Tablespace Management Overview
 
Dictionary Managed Tablespaces
Locally Managed Tablespaces
Automatic Segment Space Management
Moving tablespaces online and offline
Sample Oracle10g OCP exam questions
 
UNDO Tablespace Management
 
Use of undo segments
Creating an undo tablespace
User managed undo tablespaces
Automatic undo management
Monitor & Configure undo retention
Use the Undo Advisor
Size the undo tablespace
Sample Oracle10g OCP exam questions
 
Oracle Utilities
 
Datapump - Import/export
SQL*Loader
Oracle streams
 
Day 4: Oracle Performance Tuning
 
 
Oracle Performance Tuning
 
Locate invalid and unusable objects
Gather SQL optimizer statistics with dbms_stats
Basic Oracle performance metrics
 
Use OEM and dbms_alert to set warning and critical alert thresholds
The SQL Tuning Advisor
The SQL Access Advisor
Interpreting server generated alerts
 
Oracle advisory utilities v$db_cache_advice, v$shared_pool_advice, v$pga_aggregate_target_advice
Using OEM performance screens
Fixing performance issues
 
Day 5: Oracle security and user management
 
User Management
 
Creating Users
Altering users
User Profiles
User resource groups
Granting privileges & roles
Auditing user activity with dbms_audit
Sample Oracle10g OCP exam questions
 
Oracle Security
 
Password use in Oracle
Password encryption and password aging
External authentication
Using Single sign-on (SSO)
Object security
Virtual Private Databases (VPD) in Oracle
Oracle “grant execute” security
Use of Roles in Oracle
Register for security updates
Sample Oracle10g OCP exam questions
 
Backup & Recovery
 
Oracle backup & recovery planning
Parallel instance recovery
Basics of checkpoints, redo log files, and archived log files
Using ARCHIVELOG mode
Creating consistent Oracle backups
Online hot backups
Incremental Oracle backups
Automating database backups with dbms_scheduler
Monitor the flash recovery area
Recovering from loss of a Control file
Recovering from loss of a Redo log file
Recovering from loss of a system-critical data file
Recovering from loss of a non system-critical data file
 
OCP Final Exam Review
 
Full sample OCP DBA exam
OCP testing techniques for success
Testing tips and secrets

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational