• +91-7299675747
  • contactus@dhyaninfosolution.com
  • Home
  • CourseDetails
course duration
40 DAYS
Method
one-to-one
Timing
Flexible Time
course-details
Oracle Database Administration Training In Chennai

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 Introduction
  • 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


  • apply now

    our courses

    dhyaninfosolution
    • 4.9 (1769)
    • 578
    dhyaninfosolution
    Digital Marketing

    course details
    • 4.7 (457)
    • 368

    Quick Enquiry !!!

    Softlogic Systems