Follow Us:

Oracle Database Administration Training in Chennai

Course Duration

Sign in with Facebook Sign in with Facebook

About Oracle Database Administration

Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.

Course Contents

Oracle Database Administration
    • Introducing the Structured Query Language
    • Retrieving information from Database Tables
    • Using simple functions
    • Using SQL*plus
    • SubQueries & Advanced Queries
    • Creating Tables,Sequences,Indexes&Views
    • PL/SQL Programming
    • Database Objects
    Oracle Database 10g Architecture
    • Understand Oracle Architecture
    • Recognize the Instance Architecture
    • Installating and configuring Oracle Database 10g
    • Creating an Oracle Database
    • Create, Configure, and Delete a Database Using DBCA
    • Use DBCA to manage templates
    Managing Oracle 10g Instance
    • Enterprise Manager
    • Access the Oracle Database using SQL*Plus and iSQL*Plus
    • Database initialization parameters modifications
    • Stages of database startup and shutdown options
    • Viewing the database alert log
    Oracle Database Storage Structures
    • Usage of tablespaces and data files
    • Space management in tablespaces
    • Create tablespaces
    • Manage tablespaces
    • Obtain tablespace
    User Security in Oracle 10g
    • Creating database user accounts
    • Creating and managing roles
    • Grant and revoke privileges
    • Creating and managing profiles
    • Creating and modifying tables
    • Creating Views and sequences
    • Describe constraints and its states
    • Drop and truncate tables
    • Usage of B-Tree and Bitmap indexes
    Implementation of Database Security
    • Implementing principle of least privilege
    • Auditing database activity
    • Fine-Grained Auditing
    Oracle Data Concurrency
    • Data manipulation using SQL
    • Identify and administer PL/SQL objects
    • Define triggers and triggering events
    • Describe levels of locking
    • Lock conflict
    • Monitoring and resolving lock conflicts
    Managing Undo Data
    • Monitoring and administering undo
    • Configuring undo retention
    • Relationship between transactions and undo
    • Managing the undo tablespace
    Oracle Networking
    • Create listeners using Database Control
    • Create Oracle Net service aliases using Database Control
    • Controlling Oracle Net Listeners
    Performing Database Backup
    • Create consistent database backups
    • Back up your database without shutting it down
    • Create incremental backups
    • Automate database backups
    • Backup a control file to trace
    • Monitor flash recovery area
    Performing Database Recovery
    • Database Recovery
    • Control file
    • Redo log file
    • System-critical data file
    • Non system-critical data file
    Oracle Flashback Technologies
    • Flashback database
    • Flashback Table
    • Flashing Back Dropped Tables
    • Performing Flashback Query to view the contents of the database
    • Viewing transaction history
    Moving Data in Oracle
    • Architecture of Data Pump
    • Using Data Pump export and import
    • Load data with SQL Loader
    • Use external tables to move data
Register Now

You will Learn How To :

On completion of this course You will know
  • Deal with the DBMS and RDBMS related SQL Queries.
  • Access the Oracle Database using SQL*Plus and iSQL*Plus
  • User Security in Oracle 10g
  • Implementation of Database Security
  • Monitoring and resolving lock conflicts
  • Create Oracle Net service aliases using Database Control
  • Performing Database Backup
  • Performing Database Recovery
  • Moving Data in Oracle

  • Course Benefits :

    On completion of Diploma in Oracle Database Administration it will lead to the job role as follows:
  • Database Administrator
  • Support Analyst
  • Database Developer
  • Senior Database Administrator
  • Senior Database Developer
  • Register Now

    Please use the form below to make your career excellent.