elektrikçi şişli elektrikçi ataşehir elektrikçi üsküdar elektrikçi ümraniye deri mont

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

Rating