ORACLE DBA

Oracle 11g DBA Course Contents

Introduction to Database

  • 1. Different Types of Databases
  • 2. Oracle 9i/10g/11g Features
  • 3. Responsibilities of a DBA

Oracle Architecture

  • 1. Physical Structure
  • 2. Logical Structure
  • 3. Instance
  • 4. System Global Area - SGA
  • 5. Program Global Area - PGA
  • 6. Background Processes

Database Creation

    • 1. DB creation steps
    • 2. SYSAUX Tablespace

Tablespace Management

  • 1. Additional Tablespaces
  • 2. Advantages of having different tablespaces
  • 3. Types of tablespaces
  • 4. Bigfile tablespace
  • 5. Temporary tablespaces

Storage Parameters

  • 1. Automatic Segment Space management
  • 2. Data Dictionary Views

Undo Management

  • 1. Rollback Segments
  • 2. Undo Management
  • 3. Undo retention
  • 4. Steps to create and maintain Undo tablespace
  • 5. Retention Guarantee

Managing Redo log files

  • 1. Introduction
  • 2. Mirrored Redo Logs
  • 3. Log Switches
  • 4. Data Dictionary Views

Managing Control Files

  • 1. Introduction
  • 2. Managing the Size of Control File
  • 3. Data Dictionary Views you can query

Archived Redo Log Files

  • 1. Introduction
  • 2. Converting Database into Archive Log Mode
  • 3. Oracle managed files - Introduction
  • 4. Main Benefits of the OMF

Managing Users and Resources

  • 1. Managing database Users
  • 2. Creating Users
  • 3. Managing Resources and Profiles
  • 4. Session and User Licensing
  • 5. User Authentication

Managing User Privileges and Roles

  • 1. Identifying User Privileges
  • 2. Categories of Privileges
  • 3. Managing User Roles
  • 4. Listing Privilege and Role Information

Schema Management

  • 1. Visible and Invisible Indexes
  • 2. Read Only Tables
  • 3. DDL Wait Option
  • 4. Virtual Columns
  • 5. Table Compression
  • 6. Basic Compression
  • 7. OLTP Compression

Security

  • 1. Tablespace Encryption
  • 2. Create wallet
  • 3. Create directory structure
  • 4. Creating Wallet Key
  • 5. Case Sensitive Passwords

Auditing

  • 1. Introduction
  • 2. Parameters for Auditing
  • 3. Types of Auditing
  • 4. Data dictionary views for Auditing

Managing Oracle Networking - Net Manager

  • 1. Introduction
  • 2. Configuring Listener.ora,tnsnames.ora
  • 3. Database Links
  • 4. Materialized Views

Managing Exports and Imports

  • 1. Main Tasks of Export and Import
  • 2. Incremental, Cumulative and Complete Exports
  • 3. Import Parameters
  • 4. Introduction to Data pump
  • 5. Export by using Data pump
  • 6. Import by using Data pump

Managing Backups and Recovery

  • 1. Cold Backup
  • 2. Hot Backup Types
  • 3. Various Recovery scenarios

Recovery Manager

  • 1. Introduction
  • 2. RMAN Commands
  • 3. Types of RMAN backups - Full, Incremental Backups
  • 4. Compressed Backups
  • 5. Various Recovery scenarios by using RMAN

RMAN Enhancements

  • 1. Data Recovery advisor
  • 2. Proactive health checks
  • 3. Virtual private catalog
  • 4. Configuring the backup compression Algorithm
  • 5. Duplicate Command

Memory Management

  • 1. Introduction
  • 2. Dynamic System Global Area (SGA)
  • 3. Buffer Cache Advisory
  • 4. Automatic Memory Management
  • 5. Execution Plan Steps
  • 6. Types of Traces
  • 7. Automatic Workload Repository (AWR)

Tuning - The performance of the Database

  • 1. Introduction
  • 2. Goals of Tuning
  • 3. Tuning Process steps
  • 4. Tuning Memory, I/0, Contention,Parallel Query Option
  • 5. Online Segment Shrinking

Shared Servers, Partitioned Tables and Indexes

  • 1. Managing Partitioned Tables
  • 2. Advantages of Partitioned Tables
  • 3. Types of Partitioned
  • 4. Managing Partitioned Tables
  • 5. Client Process, Server process
  • 6. Dedicated server Process
  • 7. Shared server process

Flash Back Technology

  • 1. Flash Recovery Area
  • 2. Flash back query, Table
  • 3. Flash Back Database
  • 4. Drop a table and Undo by using flashback database

Dataguard

  • 1. Types of Stabdby
  • 2. Configuration of Dataguard
  • 3. Active dataguard
  • 4. Steps to create and maintain Standby

Automatic Storage Management(ASM)

  • 1. Introduction to ASM
  • 2. Disk group
  • 3. Fast Mirror Resync
  • 4. Oracle ASMCA
  • 5. ASMCA Commands and options

Others

  • 1. Introduction to Real Application Clusters (RAC)
  • 2. Database Refresh Steps
  • 3. Introduction to Unix Commands
  • 4. Managing Databases for SAP Applications
  • 5. Steps for Interview
  • 6. Incident Management, Change Management
  • 7. Interview questions
  • 8. Steps for Resume preparation

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

ORACLE DBA

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.