# 5/1, Rich Home, 3B (Third Floor),

Richmond Road, Bangalore - 560025

Tel: 080-4126000 /01 /02 /03

Mobile: +91-9243607538, +91-9886148509

CONTACT US

Oracle DBA

    Training Overview

    • Course Duration: 45 Days (Regular Program) / 25 Days (Fast Track) / 10 Weekends (Weekend Batch)

    • Who Should Join: Any graduate or postgraduate or professional having basic knowledge of computer and database 
    Oracle Database Course Objectives
    • Learning SQL/ SQL Plus to communication with Database
    • Learning to retrive data from database
    • Creating and Managing Tables and Other Database Objects
    • Performing Update, Insertion and Deletion Command on Database
    • Installing Oracle 11g Database on Server
    • Understaning Oracle Architecture
    • Learn to manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
    • Learn to monitor performance, troubleshoot problems, and resolve lock and conflict issues.
    • Learn to use the Oracle Enterprise Manager and SQL interfaces for administration tasks.
    • Learn about basic backup and recovery structures and strategies.
    Oracle 11g DBA Courseware
     

    Module 1: Introduction to Oracle 11g SQL

     

    • Retrieving Data Using the SQL SELECT Statement
    • Restricting and Sorting Data
    • Using Single-Row Functions to Customize Output
    • Using Conversion Functions and Conditional Expressions
    • Reporting Aggregated Data Using the Group Functions
    • Displaying Data from Multiple Tables
    • Using Subqueries to Solve Queries
    • Using the Set Operators
    • Manipulating Data
    • Using DDL Statements to Create and Manage Tables
    • Creating Other Schema Objects

    Module 2: Oracle 11g Database Administration Workshop-1

     

    • Exploring the Oracle Database Architecture
    • Preparing the Database Environment
    • Creating an Oracle Database
    • Managing the Oracle Instance
    • Configuring the Oracle Network Environment
    • Managing Database Storage Structures
    • Administering User Security
    • Managing Data and Concurrency
    • Managing Undo Data
    • Implementing Oracle Database Security
    • Database Maintenance
    • Performance Management
    • Intelligent Infrastructure Enhancements
    • Backup and Recovery Concepts
    • Performing Database Backup
    • Performing Database Recovery
    • Moving Data

    Module 3: Oracle 11g Database Administration Workshop-2

     

    • Database Architecture and ASM
    • Configuring for Recoverability
    • Using the RMAN Recovery Catalog
    • Configuring Backup Specifications
    • Using RMAN to Create Backups
    • Performing User-Managed Backup and Recovery
    • Using RMAN to Perform Recovery
    • Using RMAN to Duplicate a Database
    • Performing Tablespace Point-in-Time Recovery
    • Monitoring and Tuning RMAN
    • Using Flashback Technology
    • Additional Flashback operations
    • Diagnosing the Database
    • Managing Memory
    • Managing Database Performance
    • Space Management
    • Managing Resources
    • Automating Tasks with the Scheduler
    • Administering the Scheduler

    ON-DEMAMD OPTIONAL MODULES

     

    Module 4: Managing Oracle on Linux

     

    • Review of Linux Basis
    • Preparing Linux for Oracle
    • Installing Oracle on Linux
    • Managing Storage on Linux
    • Using Oracle ASM on Linux
    • Automating Oracle on Linux
    • Optimizing Oracle For Linux
    • Additional Linux Tips For DBAs
    • Troubleshooting Oracle Issues on Linux

    Module 5: Oracle 11g Database Suite Implementation on Linux or Windows Server

     

    • What is Virtualization Technology
    • Types of Virtualization
    • How Virtualization can help to cut the cost
    • Demonstration of Virtual Infrastructure
    • Assumption of Scenario
    • Database Designing for Scenario
    • Setting Up Windows 2008 Server Environment For Oracle Installation
    • Installing Oracle 11g R2 Software
    • Creating Database Without Sample Schema
    • Creating Schemas and Delegating Authorities with Roles and Privileges
    • Implementing Database Designing
    • Generating Runtime SQL statement for common tasks
    • Installing "TOAD For Oracle" for administrative jobs
    • Installing "NAVICAT For Oracle" on Client Devices
    • Implementing Clients and Server inside virtual private network to access each other
    • Setting up Backup procedures
    • Automating Backup

    Ph: +91- 080 - 41226000 / 01 / 02 / 03
    Email:  This email address is being protected from spambots. You need JavaScript enabled to view it.

     

    Query

    Email  
    Subject  
    Name  
    Phone  
    Message