Oracle DBA

Learn to master Oracle DBA step-by-step in 30 days.
Hindi, English

What Will I Learn?

Introduction.

  • Different types of oracle products and features.
  • New features in oracle 11g
  • Differences among oracle9i, oracle 10g and oracle 11g features along with its importance.
  • Installing oracle database 10g software.

  • System requirements.
  • Redhat Linux 5.0 Installation (with and without Vmware workstation).
  • Installation of multiple oracle servers and multiple oracle databases on Vmware workstation (features and advantages for RAC implementation with Vmware configuration).
  • Install software with the Oracle Universal Installer on Linux Platform.
  • Creation of an oracle database.

  • Oracle Database 11g Architecture.
  • Oracle instance architecture.
  • Oracle Read Consistency and Concurrency.
  • Controlling the database

  • Start and stop the enterprise manager database console.
  • Start and stop the listener.
  • Startup and shutdown the database.
  • Database Creation.

  • Manual.
  • Database Configuration Assistant(DBCA)
  • 6. Storage Structures and architecture of Oracle 11g DBA.

  • Logical structure Vs Physical structure
  • Defining the tablespaces and data files
  • Create tablespaces  Manage tablespaces
  • Obtain tablespace information
  • Managing Undo Data
  • File Management.

  • Control File Management
  • Redo Log File Management
  • Parameter File Management
  • Obtain tablespace information
  • User Management.

  • Create and manage database user accounts
  • Roles
  • Privileges
  • Control resource usage by using Profiles
  • 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
  • Testing Oracle Net connectivity
  • Shared Server: Connection pooling
  • 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
  • Oracle Backup & Recovery (User Managed).

  • Introduction  Design, Testing, Implementation Strategies
  • Offline(cold)/Online(hot) backups
  • Performing Complete Recovery
  • Performing Incomplete Recovery
  • Oracle Backup & Recovery (System Managed: RMAN).

  • Introduction
  • RMAN Architecture
  • Configuration
  • Setting up Catalog
  • Online/Offline Backup using RMAN
  • Backups Options
  • Incremental Backups
  • Complete Recovery
  • Incomplete Recovery
  • Table Space Point in Time Recovery (TSPITR)
  • Disaster Recovery

    Cloning.

  • RMAN
  • Manual
  • Logical Backup & Transporting data between databases.

  • Introduction Data pump (expdp, impdp) Utilities
  • Exporting/Importing Tables
  • Exporting/Importing Schemas
  • Exporting/Importing Table space
  • Exporting/Importing Database
  • Transportable Table space within & across the database and platforms
  • High Availability (HA).

  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation
  • Oracle Enterprise Manager and Performance tuning

  • New features and its analysis of statistics on performance Tuning
  • Proactive Maintenance

  • Contents
  • Optimizer statistics
  • Automatic Workload Repository
  • Flashback.

  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points
  • Automatic Storage Management.

  • New features and implementation
  • Oracle Grid Control.

  • Introduction
  • Architecture
  • Managing the multiple database nodes using OEM grid control
  • Data Replication and Integration·

  • Oracle database 11g streams features overview·
  • Oracle database 11g streams (Data Replication and Integration)
    •   Call Us : +91-9030-9451-88
                        : +91-8801-1055-44
    •   Email :demo@padhoonline.com

    Login For Demo

    COURSE FEATURES

    •   Practical Training
    •   Assignments
    •   Live project
    •   Lifetime Access
    •   Get Certified

    About the Instructor


    The world is awash in oceans of data. Structured or unstructured, generated internally or created by others, stored in the data centre or the cloud, data sits at the core of cognitive business. Leveraging vast quantities of data to uncover patterns and pursue breakthrough ideas, a cognitive business enables lightning-fast decisions by quickly converting data into insights.
    IBM Storage solutions provide the speed and performance of ready data access with the agility and efficiency of hybrid cloud and software-defined storage.