Oracle DBA Training Courses on Linux

Certificate Program Provided by Cympac Software Solutions Pvt. Ltd. Oracle DBA is certification oriented course which covers two major parts as: Oracle 10g Administrator I Oracle 10g Administrator II Faculty: We are having world class faculty having 8+ years of experience in the DBA field. Two certifications are: Paper I: OCA: Oracle Certified Associates Paper I: OCP: Oracle Certified Professional Duration of this course would be approx 4-6 months. Batch Timings would be Morning :- 7: 30 AM to 9: 30 AM Evening :- 7: 30 PM to 9: 30 PM Contact Person: Chetan Bhalerao Cympac Software Solutions Pvt. Ltd. Email: training@cympac. com info@cympac. com Web: www. cympac. com

Oracle DBA Training Courses on Linux Oracle 10g Administrator I
-Installing the Oracle Database Software
-Installation: System Requirements
-Checking the System Requirements
-Optimal Flexible Architecture (OFA)
-Setting Environment Variables
-Installing the Oracle Software

Creating an Oracle Database
-Database Configuration Assistant (DBCA)
-Using the DBCA to Create a Database

Managing the Oracle Instance
-Starting and Stopping Database Control
-Oracle Enterprise Manager

Managing Database Storage Structures
-How Table Data Is Stored
-Tablespaces and Data Files
-Space Management in Tablespaces
-What Is Automatic Storage Management?
-ASM: Key Features and Benefits
-ASM: Concepts

Administering User Security
-Database User Accounts
-Authenticating Users
-Administrator Authentication
-Unlocking a User Account and Resetting the Password
-Creating a Password Profile

Managing Schema Objects
-What Is a Schema?
-Accessing Schema Objects
-Naming Database Objects
-Types of Indexes
-B-Tree Index
-Bitmap Indexes
-What Is a View?
-Creating Views
-Sequences
-Creating a Sequence
-Data Dictionary:
-Data Dictionary Views

Managing Data and Concurrency
-Manipulating Data Through SQL

Managing Undo Data
-Data Manipulation
-Undo Data
-Undo Data Versus Redo Data
-Configuring Undo Retention
-Guaranteeing Undo Retention

Implementing Oracle Database Security
-Database Security
-Standard Database Auditing
-Uniform Audit Trails
-Value-Based Auditing
-Fine-Grained Auditing
-DBA Auditing

Configuring the Oracle Network Environment
-Oracle Net Services
-Oracle Net Listener
-Establishing Net Connections
-Establishing a Connection
-Naming Methods

Proactive Maintenance
-Optimizer Statistics
-Using the Manage Optimizer Statistics
-Automatic Workload Repository (AWR)
-Automatic Database Diagnostic Monitor (ADDM)
-Enterprise Manager and Advisors

Performance Management
-Performance Monitoring
-SQL Tuning Advisor:
-Enabling Automatic Shared Memory Management (ASMM)
-Using the Memory Advisor


Oracle 10g Administrator II

Backup and Recovery Concepts

Performing Database Backups
-Oracle Secure Backup
-User-Managed Backup
-Recovery Manager (RMAN)
-Managing Backups

Performing Database Recovery

Performing Flashback
-When to Use the Flashback Technology

Moving Data
-Loading Methods
-Data Pump:
-Data Pump Export and Import:
-Data Pump Utility
-External Table Population with ORACLE_DATAPUMP
-External Table Population with ORACLE_LOADER

Configuring Recovery Manager

Using Recovery Manager

Database Recovery

Flashback

Dealing With Database Curruption

Monitoring and Managing Memory
-Memory Management
-How ASMM Works and how to Configure

Autumatic Performance Management
-Tuening Activity
-Performance Planning
-Statics collection
-Troubleshooting and Tuening
-Database Control and Advisor

Managing Storage
-Space Management
-Extends Typs
-Row Chaning and Migretion
-Monitoring Tablespace
-Transporting Tablespace
-Transporting Database

Automatic Storage Management
-ASM Architecture
-Creating ASM Instance
-ASM Storage
-Disk Group Mirroring
-ASM files
-Migreting Database to ASM instance

About The Training Provider: Cympac Software Solutions Pvt. Ltd.