Homeßßß

Overview / Oracle

UltimolEarning

Database 11g AdministrationDATABASE 11G ADMINISTRATION

[Back]






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


Registration Information

download pdf registration form

Fax to 408.904.5180

Click to download the above UltimoLearning Course Registration Form to register. Please fill out one application per participant.


Training Location

Ultimo Software Solutions, Inc.

2860 Zanker Rd, Suite 203

San Jose, CA 95134


CLIENT-SITE TRAINING

We also provide On-Site Training at your company location for a group of employees.


For More Information

Tel: 408.907.8666
Email: oracletraining@ultimosoft.com


CANCELLATION POLICY

Customer will be fully charged (100%) if cancellation is NOT received by UltimoSoft in writing at least five business days in advance of the training class start date. There is no cancellation of an UltimoLearning course once the course is launched.

Cancellation Liability - We reserve the right to cancel classes for any reason. Liability is limited to the return of payment only. We will not reimburse registrants for any travel or hotel cancellation fees or penalties.

Men's Denver Broncos New Era Gray/Black NFL Gray Collection Cuffed Knit Hat with Pom,Mens Denver Broncos Gray Kickoff Pullover Hoodie,Mens Tampa Bay Buccaneers '47 Brand Black Breakaway Cuffed Beanie http://www.buffalobillsnfljerseys.com.Arizona Cardinals Carbon Small Over Small Metal Acrylic Cut License Plate Frame,Green Bay Packers 27" x 37" Throwback Helmet Vertical Banner.Men's Denver Broncos Split Color Slippers,Minnesota Vikings Infant Team Logo T-Shirt - Purple,plain women soccer jerseys wholesale,cheap nfl clothing vouchers Buffalo Bills Jerseys for Sale.Men's Pro Line Buffalo Bills Jim Kelly Retired Player Jersey,Men's Washington Redskins Majestic Burgundy Critical Victory Pullover Hoodie.Women's Green Bay Packers G-III 4Her by Carl Banks White Option Full-Zip Hoodie,Women's Houston Texans Brian Hoyer Nike Navy Game Jersey.Women's New Orleans Saints Majestic Gray Better Believe Raglan T-Shirt,Men's Indianapolis Colts Nike Heather Gray Legend Staff Practice Long Sleeve Performance T-Shirt Cheap Buffalo Bills Custom Football Jersey.Denver Broncos WinCraft 8'' x 8'' Color Car Decal,Dallas Cowboys 28" x 44" Burlap House Flag,Mens Indianapolis Colts Andrew Luck Majestic Royal Blue Eligible Receiver II Name & Number T-Shirt.Preschool Denver Broncos Orange Fan Gear Primary Logo Pullover Hoodie,Women's Baltimore Ravens C Choice Of The Buffalo Bills' Jersey.J. Mosley Majestic Purple Fair Catch V Name & Number T-Shirt,wholesale nfl online us,cheap nfl helmets riddell,authentic jerseys cheap nfl The Buffalo Bills As The Favourite Team