INFORMIT logo
InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
ABOUT
 
 ORACLE 10g
 
  10g DBA Track  
  10g iDS Track  
  10g Java Develop. Track  
  10g App. Server Track  
 
ORACLE 9i
 
  9i DBA Track  
  9i iDS Track  
  9i J2EE Java Develop. Track  
  9i AS Web Adm. Track  
 
Oracle Data Warehouse
 
   
   
     
  ORACLE CERTIFICATION  
  ORACLE UNIVERSITY  
     
   
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
Oracle10g: Administration Workshop I

Participants will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

This course helps Participants prepare to successfully pass the Oracle certification exam #1z0-042 to become an Oracle Database Administrator Certified Associte (OCA-DBA).

 

Course schedule

Duration: 30 hours
To view the schedule for this class, click here.

Who should attend

Administrators and other IT Professionals involved in the management of Oracle10g databases

Prerequisites

•  Oracle Database 10g: Introduction to SQL
. or equivalent knowledge.

Course Outline

INTRODUCTION
•  Identify the Oracle product line
•  Know core database administrator tasks

INSTALLING ORACLE DATABASE 10G SOFTWARE
•  Identify system requirements
•  Use optimal flexible architecture
•  Install software with the Oracle Universal Installer

CREATE AN ORACLE DATABASE
•  Oracle Database Architecture
•  Use the management framework & the Database Creation Assistant

DATABASE INTERFACES
•  Use SQL, PL/SQL, Java, and Oracle C++ Call Interface (OCCI)

CONTROLLING THE DATABASE
•  Start and stop the agent, the enterprise manager database console, & the listener
•  Startup and shutdown the database

STORAGE STRUCTURES
•  Create & manage tablespaces
•  Obtain tablespace information
•  Create and manage tablespaces using OMF

ADMINISTERING USERS
•  Create and manage database user accounts
•  Create and manage roles
•  Grant and revoke privileges
•  Control resource usage by users

MANAGING SCHEMA OBJECTS
•  Create and modify tables
•  Define constraints
•  View the attributes of a table
•  Create indexes and views

MANAGING DATA
•  Manipulating data through SQL
•  Using Import, Export & SQL Loader

PL/SQL
•  Identify PL/SQL objects
•  Understand triggers & triggering events
•  Identify configuration options that affect PL/SQL performance

ORACLE DATABASE SECURITY
•  Apply the principal of least privilege
•  Manage default user accounts
•  Implement standard password security features
•  Audit database activity

ORACLE NET SERVICES
•  Use Oracle Net Manager to create and configure listeners
•  Use TNSPING to test Oracle Net connectivity

ORACLE SHARED SERVER
•  Configure Oracle Shared Servers
•  Monitoring Shared Servers

PERFORMANCE MONITORING
•  Troubleshoot invalid and unusable objects
•  Gather optimizer statistics
•  View performance metrics
•  React to performance issues

PROACTIVE MAINTENANCE: OBJECTIVES
•  Set warning and critical alert thresholds
•  Collect and use baseline metrics
•  Use tuning and diagnostic advisors
•  Use ADDM
•  Manage the Automatic Workload Repository

UNDO MANAGEMENT
•  Monitor and administer undo
•  Configure undo retention
•  Guarantee undo retention
•  Use the undo advisor

MONITORING AND RESOLVING LOCK CONFLICTS
•  Detect and resolve lock conflicts
•  Manage deadlocks

BACKUP AND RECOVERY CONCEPTS
•  List the types of failure that may occur in an Oracle Database
•  Identify the importance of checkpoints, redo log files, and archived log file
•  Configure ARCHIVELOG mode

DATABASE BACKUPS
•  Create consistent database backups
•  Online backup
•  Monitor the flash recovery area

DATABASE RECOVERY
•  Recover from loss of a control file
•  Recover from loss of a redo log file
•  Recover from loss of a data file

 

 

 
 


INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail: info@informit.tc

 
  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved