Oracle 11g R2 Core DBA Online Training

  • (25 REVIEWS )

Oracle 11g R2 Core DBA was included many new features in database administrators and developers to adapt quickly to changing business requirements by simplifying the infrastructure and using automating tasks wherever possible. Compare to previous releases of Oracle, Oracle 11g is a having new features in relational database with object and Extensible Markup Language (XML) capabilities

Description

Oracle Database 11g technology and the relational database concepts and the powerful SQL programming language. This course will give you complete overview on how to insert, modify, and delete data; control data sharing and locking; debug and use error report procedures and develop database triggers, stored procedures and future reuse functions.

Pre-requisites

Students must be familiar with concepts in Oracle PL/SQL Basics and SQL Plus.

How will I perform the practical sessions in Online training?

For online training, US GlobalSoft provides a virtual environment that helps in accessing each other’s system. The complete course material in pdf format, reference materials, course code is provided to trainees. US GlobalSoft conductes online sessions through any of the available requirements like Skype, WebEx, GOTOMeeting, Webinar, etc.

Oracle 11g R2 Core DBA Course Syllabus

1. Introduction

    1. What is DBA?
    2. Why a Company needs a DBA?
    3. Roles & Responsibilities of DBA
    4. Identify the oracle product
    5. Oracle Architecture
    6. Physical and Logical Phase of Database

2. Installing oracle database 11g software

    1. System requirements.
    2. Redhat Linux Installation
    3. Install software with the Oracle Universal Installer on Linux Platform
    4. Identify System Requirements
    5. Discuss Oracle Base
    6. Discuss Oracle Home
    7. Configure Ms Windows Installation
    8. Prerequisite Checks and Fixup Utility

3. Exploring The Oracle Database  Architecture: General

  1. More About Database Instances
  2. What is Instance and SGA
  3. General Database Architecture
  4. Instance Background Processes
  5. Discuss about New Feature Parameters
  6. About PGA and Server Process

4. Exploring The Oracle Database Physical Architecture:

    1. Discuss about Control files
    2. How to manage the Control files
    3. Multiplexing the Control files
    4. Multiplexing the online redo log files
    5. Brief  about online redo log files.
    6. More About Datafiles concepts
    7. Brief About Paramter files
    8. Discuss about Password files.
    9. How to create spfile and pfile
    10. What is spfile?
    11. Difference between spfile and pfile

           
5. Create an oracle database

    1. Database Configuration Assistant(DBCA)
    2. Create A New Database
    3. Configure An Existing Database
    4. Drop A Database
    5. Manually Create A Database
    6. More About The Database Files

6. Manually Starting and Stopping Database Services

  1. Starting and Stopping Database Control
  2. Different Startup Modes
  3. Different Shutdown Modes
  4. Starting and Stopping The Listener
  5. Sysdba

7. Manage Database Storage Structures: Tablespaces

    1. What are segments?
    2. What are extents?
    3. What is Blocks?
    4. Estimation of  Extents
    5. Dictionary Managed Table space
    6. Locally Managed Table space
    7. About Tablespaces
    8. Tablespace Management
    9. Autoextend Options
    10. Drop Tablespace
    11. Alter Tablespace
    12. Tablespace Encryption

8. Manage Database Storage Structures: Advanced Tablespaces

    1. More About Temporary Tablespaces
    2. Using V$Sort_Segment
    3. About Temporary Tablespace Groups
    4. Temporary Groups
    5. More About Permanent Tablespaces
    6. About Database_Properties
    7. More About Bigfile Tablespaces
    8. More About The Sysaux Tablespace

9. Manage Database Storage Structures:

    1. Managing Data Files
    2. Managing Temp Files
    3. Enable Oracle-Managed Files (OMF)
    4. Renaming a data file
    5. Temporary Groups

10. Managing Undo Data

    1. About Undo Space Management
    2. Configure Undo Management
    3. Undo_Management
    4. Undo_Tablespace
    5. Undo_Retention
    6. Guarantee Undo Retention
    7. Monitor Undo Space
    8. Use The Undo Advisor

11. Security: Administering User Security

    1. Create and manage database user accounts
    2. Create and manage roles
    3. Grant and revoke privileges
    4. Control resource usage by using Profiles
    5. Auditing Of Database Activity
    6. Audit_Trail Parameter
    7. Enhanced Default Security Settings
    8. Create and Manage Database Accounts
    9. Grant and Revoke Database Privileges
    10. Resource Limits Via Profiles
    11. Alter Profile
    12. Drop Profile

12. Oracle Net Services

    1. Understand Oracle Net concepts
    2. Use Oracle Net Manager to create and configure listeners
    3. Use the listener control utility to control the Oracle Net Listener
    4. Start and stop Listener concepts
    5. Listener.ora
    6. Tnsnames.ora
    7. Concept about Database Links
    8. Use the Oracle Net Manager to configure client and middle-tier connection
    9. Use TNSPING to test Oracle Net connectivity

13. Logical Backup

    1. Introduction Data pump (expdp, impdp)  Utilities
    2. Exporting/Importing Tables
    3. Exporting/Importing Schemas
    4. Exporting/Importing Table space
    5. Exporting/Importing Database
    6. Transportable Table space within & across the database and platforms
    7. Discuss New features concept 11g

14. Oracle Backup & Recovery (User Managed)

    1. Introduction
    2. Design, Testing, Implementation Strategies
    3. Offline(cold)/Online(hot) backups
    4. Performing Complete Recovery
    5. Performing Incomplete Recovery

15. Oracle Backup & Recovery (System  Managed: RMAN)

    1. Introduction
    2. RMAN Architecture & Rman commands
    3. Configuration
    4. Setting up Catalog
    5. Online/Offline Backup using RMAN
    6. Backups Options
    7. Incremental Backups,
    8. Scripts,
    9. Complete Recovery
    10. Incomplete Recovery
    11. Table Space Point in Time Recovery (TSPITR)
    12. Disaster Recovery
    13. Recovery of Corrupted DB-Blocks
    14. RMAN 11g new features

           
16. Cloning & Refresh

    1. Database Refresh Using RMAN
    2. Database refresh Using Manual
    3. DB refresh Using Expdp and Empdp
    4. Migration Using Expdp and Impdp
    5. Migration Using Rman

17. Patching Activity

    1. Database Patch Management Introduction
    2. Applying Interim and Patch set Patches
    3. Patch History & Documentation

18. Oracle Performance Tuning

    1. Why Tuning required?
    2. Types of Tuning
    3. Proactive Vs Reactive Tuning
    4. Tuning through effective DB Configurations
    5. Health Management/Periodical Checkup
    6. table Defragmentation

19. Introduction to Oracle Real Application Clusters

    1. What is a cluster?
    2. Types of clustering Technologies
    3. Advantages of RAC over the standalone databases

Certification

Certification assistance provided with proper guidance and certification notes.