Oracle DBA

Oracle Database Administration Training In Chennai

Vikapri course png
About Oracle Database Administration

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

Oracle DBA is responsible for Availability, Recoverability, Integrity, Performance and Assists Programmers. It helps to generate data warehousing, complex database workloads and online transaction process. 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.

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

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