• +91-7299675747
  • contactus@dhyaninfosolution.com
  • Home
  • CourseDetails
course duration
Flexible Time
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

    • 4.9 (1769)
    • 578
    Digital Marketing

    course details
    • 4.7 (457)
    • 368

    Quick Enquiry !!!

    Softlogic Systems