IT Online Training and Placements in USA.

Oracle Online Training

Oracle 10g/11g, Oracle APPS Technical, Siebel Analytics, Siebel CRM, Oracle DBA etc.,

 

Courses » Oracle Courses » Oracle DBA Online Training

 

Oracle DBA Online Training

 

Oracle 10g DBA Online Training Course Content

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 management framework.
  • Use the Database Creation Assistant.

Controlling the database:

  • 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
  • Control resource usage by users.

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

Managing Data

  • Manipulating data through SQL
  • Using Import
  • Using Export
  • Using SQL Loader

PL/SQL

  • Identify PL/SQL objects
  • Understand triggers and triggering events
  • Identify configuration options that affect PL/SQL performance

Oracle Database Security

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

Oracle Net Services

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

Oracle Shared Server

  • Understand when to use Oracle Shared Servers
  • Configure Oracle Shared Servers
  • Monitoring Shared Servers

Performance Monitoring

  • Troubleshoot invalid and unusable objects
  • Gather optimizer statistics
  • View performance metrics
  • React to performance issues

Proactive Maintenance: Objectives

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

Undo Management

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

Monitoring and Resolving Lock Conflicts

  • Detect and resolve lock conflicts
  • Manage deadlocks

Backup and Recovery

  • 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
  • Configure ARCHIVELOG mode

Database backups

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

Database Recovery

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

Using Globalization Support

  • Datetimes with Timezones
  • Specifying Language-Dependent Behavior
  • Locale Variants
  • Linguistic Sorting
  • Case and Accent Insensitive Sorts
  • Linguistic Comparisons
  • Obtaining Information about the Current NLS Configuration

Diagnostic Sources

  • The Alert Log
  • Viewing Alerts with EM
  • Alerts Notification
  • Editing Thresholds
  • Trace Files

Recovering from non-critical losses

  • Creating New Temporary Tablespace
  • Recreating Redo Log Files
  • Recovering an Index Tablespace
  • Read-Only Tablespace Recovery
  • Loss of Password Authentication File

Automatic Storage Management

  • 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.

Flashback database

  • When to Use Flashback Technology
  • Configuring Flashback Database
  • Monitoring Flashback Database
  • Best Practices for the Database and Flash Recovery Area
  • Flash Recovery Area Space Usage
  • Flashback Database Examples

Monitoring and Managing Memory

  • Oracle Memory Structures
  • Automatic PGA Memory Management