Courses Images

Course Details

Oracle Database Administration is ideal for enterprise grid computing. Database Administrators are required for each database.

Oracle DBA is responsible for Availability, Recoverability, Integrity, and Performance and Assists Programmers. It helps generate data warehousing, complex database workloads and online transaction processes. It upgrades the technical skills of DBA Administrators by preventing repetitive and low-value works of administration.

We provide the best professional Oracle Database Administration Training In Chennai, in which you get advanced training sessions and hands-on projects by Experts.

Lessons 1: Introduction

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



Vikapri Training WhatsApp