You will have understanding and hands-on of

• Understand the Oracle10g architecture, installation on NT, Linux and Unix
• Configure and manage Oracle10g database
• Perform effective storage management
• Manage User accounts, privileges and roles
• Database creation (OLTP, WAREHOUSE and HYBRID)
•  Deploy appropriate backup strategy to safeguard Oracle10g database.
• Oracle10g backup and recovery features – Recovery Manager
• Exploit new features like “Data Pump” , SYSAUX Tablespace, Automatic Database Management, Automatic Workload Repository, Oracle Scheduler,
• Oracle10g Server performance tuning
• Oracle Networking environment and Net10g architecture  
• Data Modeling – Forward and Reverse Engineering
  • Review of RDBMS concepts and Oracle10g Architecture and Internals
    • Your tasks as a DBA
    • Instance vs. database
    • Oracle Processes and memory usage
    • User and Server Processes
    • SGA/PGA
    • Single Vs Multiple Process Architecture
    • Server Processes (Background processes)
    • Redo log and control files
    • Checkpoint process
    • Rollback and Undo segments
  • Oracles OFA architecture
    • Physical Layout
    • Distributing physical structures
  • Oracle’s “Networked Environment”
    • Understanding and configuring Net10g
    • Understanding Listener
    • Understanding Client
    • Setting up Oracle database connection from non-oracle clients (Microsoft Access, ODBC and Visual Basic)
  • Oracle Installation Procedure  and Database Creation
    • Database Design Overview
    • Overview and Preparation for Installation
    • Database Products Installation and Test database creatio
    • Create Database for
    • Data Warehouse, OLTP and Hybrid Database
    • Using DBCA and Connectivity Testing

• Oracle on Linux Unix and NT
  • OS issues for Oracle
  • Basic Unix commands Shell Scripting required for installation
  • Job Scheduling – CRON and WINAT
• Managing Critical Database Elements, Users, Roles,  Privileges and Profile
  • Managing Datafiles, Tablespace, Redo Logs
  • Managing Rollback Segments and UNDO Tablespaces
  • Roles, Privileges and Profiles
• Developing and implementing correct backup strategy and Recovering database
  • Protecting database
  • Performing Backups
  • Hot Backups
  • Cold Backups
  • Export/Import and Data Pump Technology
  • Archiving full database recovery
  • Introduction to standby database
  • Recovery Manager – Understanding and implementing
  • Recovery Manager Backup/recovery methods
  • Log Miner
• Oracle10g – Performance Tuning
  • Tuning methods
  • Understanding Optimizer and Hints
  • Tuning memory and structures
  • Oracle10g tuning tools
• Database Monitoring with Enterprise Manager
  • Database Control and Enterprise manager
  • Monitoring Database with EM
  • Managing Users, privileges, roles and profiles
  • Killing sessions
• Oracle10 Advanced features
  • Automatic Database Management
  • Automatic Workload Repository
  • Oracle Scheduler
  • Other New Features
• Data Modeling
• Forward and reverse engineering