slot garansi kekalahan slot77 pkv games poker qq slot depo 5k slot depo 10k bandarqq dominoqq slot thailand pkv games bandarqq depo 25 bonus 25 dominoqq slot77 mix parlay slot thailand pkv games judi bola mix parlay poker qq slot depo 5k slot thailand slot77 dominoqq pkv games bandarqq poker qq dominoqq judi bola slot77 pkv games bandarqq dominoqq poker qq slot depo 5k pkv games bandarqq dominoqq poker qq slot depo 5k slot depo 10k slot thailand pkv games bandarqq dominoqq poker qq slot depo 5k slot depo 10k judi bola pkv games bandarqq dominoqq poker qq slot mpo pkv games bandarqq dominoqq slot depo 5k slot depo 10k bonus new member pkv games bandarqq poker qq dominoqq idn poker slot demo slot maxwin pkv games bandarqq poker qq dominoqq slot77 judi bola mix parlay pkv games bandarqq dominoqq poker qq slot depo 5k slot depo 10k pkv games bandarqq poker qq dominoqq scatter hitam pkv games bandarqq dominoqq poker qq slot mpo slot dana slot thailand depo 25 bonus 25 slot depo 10k slot dana slot maxwin slot77 bonus new member mix parlay scatter hitam pkv games pkv games bandarqq pkv games slot depo 5k poker qq depo 25 bonus 25 pkv games poker qq mix parlay pkv games bandarqq bonus new member pkv games bandarqq dominoqq poker qq pkv games dominoqq slot77 pkv games dominoqq depo 50 bonus 50 pkv games bandarqq slot maxwin pkv games slot depo 5k depo 25 bonus 25 dominoqq data hk 6d slot77 slot depo 10k paito hongkong slot thailand pkv games dominoqq bandarqq pkv games slot depo 10k slot hoki pkv games dominoqq bandarqq poker qq slot thailand slot gacor pkv games bandarqq slot depo 5k slot hoki pkv games bandarqq dominoqq slot77 pkv games dominoqq pkv games depo 50 bonus 50 judi bola pkv games bandarqq pkv games dominoqq slot garansi kekalahan judi bola pkv games bandarqq dominoqq slot thailand pkv games bandarqq dominoqq poker qq pkv games slot77 mpo pkv games bandarqq dominoqq slot depo 5k pkv games bandarqq judi bola slot77 slot garansi kekalahan pkv games bandarqq dominoqq poker qq depo 25 bonus 25 idn poker pkv games bandarqq poker qq dominoqq slot thailand pkv games bandarqq slot maxwin pkv games bandarqq dominoqq poker qq idn poker depo 25 bonus 25 pkv games pkv games pkv games bandarqq poker qq dominoqq bandarqq pkv games slot77 mix parlay pkv games bandarqq dominoqq pkv games bonus new member pkv games bandarqq slot thailand judi bola pkv games dominoqq rejekibet pkv games pkv games dominoqq poker qq slot thailand pkv games depo 25 bonus 25 pkv games bandarqq rejekibet robopragma slot depo 10k depo 50 bonus 50 pkv games slot garansi kekalahan dominoqq bandarqq slot garansi kekalahan idn poker slot77 slot thailand pkv games bandarqq pkv games bandarqq dominoqq poker qq pkv games pkv games poker qq slot77 depo 25 bonus 25 pkv games pkv games dominoqq depo 25 bonus 25 scatter hitam bandarqq poker qq slot depo 5k bonus new member bandarqq slot demo depo 25 bonus 25 bandarqq slot thailand poker qq pkv games poker qq bandarqq bandarqq pkv games dominoqq slot77 bandarqq dominoqq pkv games bandarqq slot depo 10k pkv games slot depo 5k slot depo 10k pkv games slot77 pkv games bandarqq judi bola pkv games dominoqq pkv games bandarqq dominoqq poker qq slot depo 10k depo 25 bonus 25 mpo depo 50 bonus 50 slot dana pkv games bandarqq slot depo 10k mpo pkv games bandarqq judi bola robopragma pkv games bandarqq poker qq dominoqq slot depo 10k depo 25 bonus 25 idn poker robopragma slot77 pkv games bandarqq dominoqq judi bola idn poker slot depo 10k slot dana slot gacor slot depo 5k pkv games idn poker slot gacor slot depo 10k idn poker bandarqq dominoqq pkv games bandarqq slot hoki pkv games bandarqq poker qq dominoqq pkv games bandarqq poker qq pkv games bandarqq dominoqq poker qq pkv games bandarqq poker qq dominoqq slot77 judi bola pkv games bandarqq poker qq dominoqq rejekibet pkv games dominoqq poker qq bandarqq pkv games bandarqq poker qq dominoqq pkv games bandarqq dominoqq pkv games bandarqq dominoqq poker qq idn poker pkv games bandarqq slot hoki slot demo pkv games pkv games bandarqq judi bola rejekibet bonus new member slot hoki pkv games bandarqq dominoqq poker qq idn poker pkv games bandarqq poker qq pkv games bandarqq dominoqq poker qq pkv games bandarqq idn poker poker qq pkv games bandarqq dominoqq idn poker poker qq pkv games bandarqq mix parlay pkv games depo 50 bonus 50 bandarqq slot depo 5k poker qq dominoqq depo 25 bonus 25 pkv games judi bola mix parlay bandarqq pkv games bandarqq poker qq dominoqq depo 25 bonus 25 pkv games slot depo 10k mpo pkv games dominoqq depo 50 bonus 50 slot depo 10k pkv games bandarqq poker qq slot thailand pkv games dominoqq poker qq slot depo 5k pkv games bandarqq poker qq dominoqq depo 25 bonus 25 pkv games dominoqq poker qq slot depo 5k pkv games slot depo 10k depo 25 bonus 25 slot garansi kekalahan slot depo 10k slot thailand bonus new member depo 50 bonus 50 pkv games bandarqq dominoqq poker qq mix parlay slot depo 5k idn poker slot77 pkv games bandarqq poker qq dominoqq dominoqq pkv games mix parlay slot depo 5k slot hoki dominoqq pkv games bandarqq slot depo 10k pkv games idn poker bandarqq depo 25 bonus 25 mpo pkv games bandarqq poker qq dominoqq slot77 pkv games bandarqq slot thailand poker qq pkv games bandarqq poker qq slot77 idn poker pkv games bandarqq poker qq pkv games slot depo 5k judi bola slot depo 5k pkv games bandarqq judi bola slot demo depo 50 bonus 50 poker qq dominoqq pkv games parlay slot thailand slot mpo depo 50 bonus 50 dominoqq poker qq slot depo 10k pkv games depo 50 bonus 50 slot77 pkv games bandarqq dominoqq poker qq slot depo 10k scatter hitam slot demo pkv games depo 25 bonus 25 poker qq slot77 bandarqq depo 25 bonus 25 dominoqq slot garansi kekalahan pkv games bandarqq dominoqq idn poker pkv games bandarqq poker qq dominoqq slot garansi kekalahan slot depo 5k pkv games bandarqq dominoqq poker qq pkv games bandarqq poker qq slot depo 5k slot mpo slot thailand pkv games slot demo slot dana bandarqq pkv games slot garansi kekalahan pkv games bandarqq dominoqq scatter hitam slot depo 10k pkv games bandarqq slot77
Database 11G Administration – Ultimosoft

Database 11G Administration

Value Beyond Technology

Ultimo Software Solutions is a valued Enterprise Application service provider that assists leading business organizations to deploy IT solutions ensuring long-term success in SOA, EAI, B2B, BPM, AJAX Rich Internet Applications, and User Interfaces.

This is an introductory course for Oracle Database Administrators. This course begins with the Installation and Configuration of Oracle Database. It covers the different database objects and the data dictionary which provides information about the database. It offers details about several Dynamic Performance views that the DBA’s use to perform their day to day tasks. It gives a quick review of Data Access with SQL and PL/SQL.

This course presents the details of Physical and Logical Storage Structures and gives hands-on experience to manage the storage structures. It helps the participant to gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. It explicates the User Management that aids in creating user accounts and granting privileges to those accounts by restricting the access to the database to ensure security. It focuses on Backup and recovery techniques which will permit the reconstruction of your database. It gives an outline of Data Guard and RAC concepts.

Prerequisites

Good Knowledge of SQL and PL/SQL

Objectives
  • Installing Oracle Database Software
  • Creating Oracle databases
  • Starting and shutting down the database instance
  • Managing the Database storage structures
  • Managing database objects, such as tables, indexes, and views
  • Managing users and security
  • Perform backup and recovery of a database
  • Monitor, troubleshoot, and maintain a database
Course Content

Database Installation and Configuration

  • Quick Installation
  • Advanced Installation
  • Using DBCA for Configuration

Database Objects

    • Overview of Schema Objects
    • Managing Schema Objects
    • Understanding Non Schema Objects
    • Managing Non Schema Objects

Data Dictionary

    • Introduction to the Data Dictionary
    • How the Data Dictionary is used
    • Dynamic Performance Tables
    • Database Object Metadata
    • Dynamic Performance Views

Transaction Management

    • Introduction to Transactions
    • Managing Transactions
    • Overview of Autonomous Transactions

Database Storage Structures

    • Managing Logical Storage Structures
    • Understanding Physical Storage Structure
    • Working with Control Files
    • Managing Online Redo Log
    • Managing Undo Data

Security and User Management

    • Managing Users and Resources
    • Learning about user Privileges and Roles
    • Auditing Database Use

Oracle Database and Instance

    • Overview of Instance and Instance Management
    • Initialization Parameters

Oracle Database Architecture

    • Memory Architecture
    • Process Architecture
    • Application Architecture

Backup and recovery

    • Consistent and Inconsistent Backup
    • Whole Database and Partial Database Backup
    • RMAN and User Managed Backup
    • Types of Oracle Recovery
    • Recovery Techniques
    • Flash Recovery Area

Performance and Tuning Concepts

    • Oracle Database Performance Method
    • Proactive Database Tuning
    • Reactive Database Tuning

Memory Management

      • Automatic Memory Management
      • Automatic Shared Memory Management
      • Automatic PGA Memory Management

Data Guard Concepts for High Availability

    • Introduction to Data Guard
    • Data Guard Broker Concepts
    • Data Guard Configurations
    • Protection Modes
    • Switchover and Failover Operations

RAC Concepts

    • Installing Oracle Grid Infrastructure and RAC
    • Administering Cluster Databases
    • Monitoring the Clusterware Components
Course Duration

2 days