ORACLE DBA ONLINE TRAINING

Introduction

•  Introduction
•  Identify the oracle product
•  Describe the basic concept of a relational database

Installing oracle database 10g software

•  System requirements
•  Use Oracle Optimal Flexible Architecture (OFA)
•  Install software with the Oracle Universal Installer

Create an oracle database

•  Oracle Database Architecture
•  Oracle instance architecture
•  Use the Database Creation Assistant

Controlling the database

•  Manually configure the Oracle 10g EM dbconsole
•  Start and stop the agent
•  Start and stop the enterprise manager database console
•  Start and stop the listener
•  Startup and shutdown the database

Storage Structures

•  Defining the tablespaces and data files
•  Create tablespaces
•  Manage tablespaces
•  Obtain tablespace information
•  Create and manage tablespace using oracle enterprises manager

Administering users

•  Create and manage database user accounts
•  Create and manage roles
•  Grant and revoke privileges

Oracle Database Security — Only Theory

•  Apply the principal of least privilege
•  Manage default user accounts
•  Implement standard password security features

Oracle Net Services

•  Understand Oracle Net concepts
•  Use Oracle Net Manager to create and configure listeners
•  Use the Oracle Net Manager to configure client and middle-tier connection
•  Use TNSPING to test Oracle Net connectivity

Performance Monitoring

•  Gather optimizer statistics
•  View performance metrics

Monitoring and Managing Memory

•  Oracle Memory Structures
•  Automatic PGA Memory Management
•  Using the Memory Advisor
•  Using Automatic Shared Memory Management to avoid long running query issues

Monitoring and Resolving Lock Conflicts

•  Detect and resolve lock conflicts
•  Manage deadlocks

Diagnostic Sources

•  The Alert Log
•  Viewing Alerts with EM
•  Alerts Notification —– Only Theory
•  Editing Thresholds —– Only Theory
•  Trace Files

Proactive Maintenance: Objectives — Only Theory

•  Set warning and critical alert thresholds
•  Collect and use baseline metrics
•  Use tuning and diagnostic advisors
•  Use the Automatic Database Diagnostic Monitor (ADDM)

Automatic Storage Management Only Theory

•  ASM Concepts
•  ASM General Architecture
•  Creating an ASM instance
•  Creating tablespaces that use ASM storage
•  Viewing ASM information
•  Migrating a tablespace to use ASM storage.

Undo Management — Only Theory

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

Backup and Recovery — Only Theory

•  Describe the basics of database backup, restore and recovery
•  List the types of failure that may occur in an Oracle Database
•  Describe ways to tune instance recovery
•  Identify the importance of checkpoints, redo log files, and archived log file

Managing Data

•  Manipulating data through SQL
•  Using Import
•  Using Export

Database backups

•  Configure ARCHIVELOG mode
•  Create consistent database backups
•  Back your database up without shutting it down
•  Create incremental backups
•  Automate database backups
•  Monitor the flash recovery area

Managing schema objects

•  Create and modify tables
•  Define constraints
•  View the attributes of a table
•  View the contents of a table
•  Create indexes and views

Database Recovery

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

• 8+ years of experience in Oracle PLSQL Development.
• 5+ yrs of exp as an ORACLE trainer.
• Working as Manager for DBA operations.
• Entirely customized to your level.
• Superior training experience skills
• Practical experience with theoretical topics.
• Very approachable and well experienced.
• Empowering students with best conceptual & practical skills
• Providing the Projects on emerging Technologies with Real-time scenarios.