Course Objectives
The overall objective of this course is to allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting point for Oracle database administrators and also the foundation for advanced administrator training and certification.
Target 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.
Course Prerequisites
Mandatory prerequisites for this course are the following Sideris courses:
• ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY
• ORACLE DATABASE 10G: PROGRAM WITH PL/SQL – PART II
Course Outline
INSTALLING ORACLE 10G DATABASE SOFTWARE
EXPLORING THE ORACLE DATABASE ARCHITECTURE
DATABASE INSTANCE PROCESS ARCHITECTURE
CREATING AN ORACLE DATABASE
CONTROLLING THE DATABASE ENVIRONMENT
STORAGE STRUCTURES: TABLESPACES
STORAGE STRUCTURES: ADVANCED TABLESPACES
STORAGE STRUCTURES: DATA FILES & TEMP FILE
UNDO MANAGEMENT
DATABASE SECURITY
ADMINISTERING USERS
MANAGING DATA: LOADING DATA WITH SQL LOADER
MANAGING DATA: EXPORTING & IMPORTING DATA
ORACLE NET SERVICES
ORACLE SHARED SERVERS
MONITORING & RESOLVING LOCK CONFLICTS
BACKUP & RECOVERY CONCEPTS
