P100 - Prepare Oracle DBAs dream learning environment on Linux (Step by Step) -  
Covers steps to prepare a home learning environment for Oracle DBAs.
   1) Install Linux (Ubuntu) 64 bit Operating System.
   2) Setup Firewall & use of System monitoring tools (for CPU, Disk usage).
   3) Install VMware server & web console for Virtulization.
   4) Process of creating Virtual Machines (VMs).
   [Many Virtual machines within your same Physical machine]
   [Each Virtual machine can install an Oracle Product for learning purposes!]

P101 - Install/Configure Oracle10g Clusterware, RAC, GridControl and Agent (Step by Step) -  
Detailed steps to install & configure 2 node Oracle RAC cluster on your computer!
   1) Overview of pre-requisites to set up an Oracle RAC setup at your home.
   2) Install 10g Oracle clusterware, RAC database and RAC database on a 2 node setup.
   3) Install 10g ASM (Automatic Storage Management) for your RAC database storage.
   4) Install 10g Oracle Grid Control (a GUI tool) for monitoring Oracle RAC environment.
   5) Install 10g Grid Control Management Agents on each of RAC node targets.
   6) DBA Queries / Scripts to manage RAC/ASM/GridControl/Agent environment
      (e.g. start/stop/administer etc).

P102 - Setup/Configure Streams (bi directional, LDC, Schema & Table mode) (Step by Step) -  
Covers steps to setup and configure Oracle Streams in different ways
   1) Overview of pre-requisites to set up Oracle Streams.
   2) Setup Bi-Directional Streams (txns streamed from one database to another instantly)
       a) Table mode
       b) Schema mode
   3) Setup Local Downward Capture mode (LDC) - log shipping and mining at destination.
   4) DBA tasks in Streams (Schema changes, new columns, sequences etc.)
   5) Streams Performance Tuning considerations.
   6) DBA Queries / Scripts for Oracle Streams.

P103 - Oracle Database Administration - Most Important DBA Activities (Step by Step) -  
Covers important Oracle DBA tasks in very clear steps
   1) SGA and PGA - Really important concepts and queries.
   2) Rename and Relocate Datafile.
   3) Relocate Controlfile.
   4) Transportable Tablespaces (TTS) - plug tablespaces from one database into another.
   5) Database, Tablespace, Datafile, Object Sizing scripts.
   6) Cloning a database - Copy entire database (e.g. from production to test environment).
   7) Bind Variables - understanding and considerations - best practices.
   8) Setup & Use of Resource Manager - set Quota for CPU, Disk for various processes.
   9) Extending table partitions as per business requirements automatically thru jobs.
   10) Dynamic SQL technique - on the fly.
   11) SQL - PL/SQL tables handling.
   12) SQL constructs very important for DBAs.

P104 - Oracle Performance Tuning - Most Important DBA Activities (Step by Step) -  
Covers important Performance Tuning DBA tasks in clear steps
   1) Identify effectively & many tracing methods high resource consuming sessions in Linux.
   2) Tuning a slow running query / PLSQL code (procedure/function/pacakge).
   3) Reorganization for space reduction and performance - Index Rebuilds & Move object.
   4) AWR and ADDM reports - How to read and Intrepret effectively.
   5) Very Handy Performance Tuning scripts / queries applicable in many scenerios.

P105 - Oracle Backup and Recovery DBA Activities (Step by Step) -  
Covers important Backup and Recovery DBA tasks in clear steps
   1) Backing up your database (Cold/Hot).
   2) Recover your database (Complete/Incomplete recovery).
   3) RMAN (Recovery Manager) - Setup, Administer, Backup and Recover databases.
   4) Switching between ARCHIVELOG and NOARCHIVELOG modes.
   5) Complete Archiving Strategy discussed with clear production db implementation.
   6) Data pump (expdp and impdp) - clear examples and concepts.
   7) Traditional export (exp) and import (imp) - clear examples and concepts.
   8) SQL Loader for loading data into oracle database - clear examples.
   9) External tables - reading text file into database.

P106 - Linux knowledge (commands & shell scripting) most essential for DBAs (Step by Step) -  
This material is a very quick way of learning the most commonly used Linux commands in daily DBA activities. Correct use of these commands is very essential for a DBA to be an effective DBA, since most of the database installations are on Linux these days. Besides commands like grep, find, du, df, gzip, gunzip, tar, scp etc it also has OS monitoring commands which are very important to diagnose any CPU, Disk related issue on the server.

P108 - Setup and Administer Oracle Advanced Replication (Step by Step) - This material discusses how to setup, administer and manage Advanced Replication using updatable materialized views. You can keep database tables across databases far apart geographically (different locations) in synchronized state using this. It also discusses how you can manage and administer such replicated environments. Scripts to setup and administer included.

P109 - ALL OF THE ABOVE STUDY MATERIAL !!! Limited time special offer (Step by Step) - This is a limited time special offer where we are offering all of the material sets. As you would know all these topics are very important components of DBA Tasks.

As you can see that this is 43% reduction in our prices! Hurry limited time.