| |
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
* Learn Oracle DBA
Concepts.
* Understand Concurrency
Management.
* Employ DBA
Management.
* Use Oracle Performance
Tuning.
* See Oracle security and
user management.
|
|
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.
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.
|
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.
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
|
and include the URL for the page.
