Oracle DBA Training

Course Detail
Oracle DBA Training
(500 Review)

ABOUT THE COURSE

  • After completion of training program on Oracle DBA , students and professionals will get the most and the best from their accounting skills.
  • Oracle DBA training from JAGJIT INSTITUTE Delhi is cost-competitive.
  • Course Completion Certificate to every student and carries global recognition.
  • Oracle DBA Training can be customized after analyzing the company-specific requirements
  • Industry Specific specially tailored Oracle DBA training modules.
  • Highly qualified and certified trainers on Oracle DBA with expertise in our instruction methods.
  • At no extra cost, the needy students can repeat the classes with prior permission.
  • For the students to get maximum benefit from the training, One-on-One attention is given to each student.
  • Well maintained Smart Labs with latest equipment where individual can flourish their practical knowledge with hands on practice.
  • To make students become well aware of the complex working scenarios in the work field, we establish strong practices in enhancing their technical skills and concepts on the subject.
  • PG Facilities available in the nearby vicinity for students coming from other states for Oracle DBA Training in Delhi.
  • Our Oracle DBA Course content is structured to cover all the modules within Oracle DBA. From basic to advance, we give Oracle DBA training in Delhi in a manner that is easy to understand.

Below is the detailed course content for Oracle DBA

Exploring the Oracle Database Architecture
  • Lecture 1:
    Oracle Database Architecture Overview
    30 Minute
  • Lecture 2:
    Oracle ASM Architecture Overview
    30 Minute
  • Lecture 3:
    Process Architecture
    30 Minute
  • Lecture 4:
    Memory structrues
    30 Minute
  • Lecture 5:
    Logical and physical storage structures
    30 Minute
  • Lecture 6:
    ASM storage components
    30 Minute
Installing your Oracle Software 
  • Lecture 1:
    Tasks of an Oracle Database Administrator
    30 Minute
  • Lecture 2:
    Tools Used to Administer an Oracle Database
    30 Minute
  • Lecture 3:
    Installation: System Requirements
    30 Minute
  • Lecture 4:
    Oracle Universal Installer (OUI)
    30 Minute
  • Lecture 5:
    Installing Oracle Grid Infrastructure
    30 Minute
  • Lecture 6:
    Installing Oracle Database Software
    30 Minute
  • Lecture 7:
    Silent Install
    30 Minute
Creating an Oracle Database
  • Lecture 1:
    Planning the Database
    30 Minute
  • Lecture 2:
    Using the DBCA to Create a Database
    30 Minute
  • Lecture 3:
    Password Management
    30 Minute
  • Lecture 4:
    Creating a Database Design Template
    30 Minute
  • Lecture 5:
    Using the DBCA to Delete a Database
    30 Minute
Managing the Oracle Database Instance
  • Lecture 1:
    Start and stop the Oracle database and components
    30 Minute
  • Lecture 2:
    Use Oracle Enterprise Manager
    30 Minute
  • Lecture 3:
    Access a database with SQLPlus
    30 Minute
  • Lecture 4:
    Modify database installation parameters
    30 Minute
  • Lecture 5:
    Describe the stages of database startup
    30 Minute
  • Lecture 6:
    Describe database shutdown options
    30 Minute
  • Lecture 7:
    View the alert log
    30 Minute
  • Lecture 8:
    Access dynamic performance views
    30 Minute
Manage the ASM Instance
  • Lecture 1:
    Set up initialization parameter files for ASM instance
    30 Minute
  • Lecture 2:
    Start up and shut down ASM instances
    30 Minute
  • Lecture 3:
    Administer ASM disk groups
    30 Minute
Configuring the Oracle Network Environment
  • Lecture 1:
    Use Enterprise Manager to create and configure the Listener
    30 Minute
  • Lecture 2:
    Enable Oracle Restart to monitor the listener
    30 Minute
  • Lecture 3:
    Use tnsping to test Oracle Net connectivity
    30 Minute
  • Lecture 4:
    Identify when to use shared servers and when to use dedicated servers
    30 Minute
Managing Database Storage Structures
  • Lecture 1:
    Storage Structures
    30 Minute
  • Lecture 2:
    How Table Data Is Stored
    30 Minute
  • Lecture 3:
    Anatomy of a Database Block
    30 Minute
  • Lecture 4:
    Space Management in Tablespaces
    30 Minute
  • Lecture 5:
    Tablespaces in the Preconfigured Database
    30 Minute
  • Lecture 6:
    Actions with Tablespaces
    30 Minute
  • Lecture 7:
    Oracle Managed Files (OMF)
    30 Minute
Administering User Security
  • Lecture 1:
    Database User Accounts
    30 Minute
  • Lecture 2:
    Predefined Administrative Accounts
    30 Minute
  • Lecture 3:
    Benefits of Roles
    30 Minute
  • Lecture 4:
    Predefined Roles
    30 Minute
  • Lecture 5:
    Implementing Profiles
    30 Minute
Managing Data Concurrency
  • Lecture 1:
    Data Concurrency
    30 Minute
  • Lecture 2:
    Enqueue Mechanism
    30 Minute
  • Lecture 3:
    Resolving Lock Conflicts
    30 Minute
  • Lecture 4:
    Deadlocks
    30 Minute
Managing Undo Data
  • Lecture 1:
    Data Manipulation
    30 Minute
  • Lecture 2:
    Transactions and Undo Data
    30 Minute
  • Lecture 3:
    Undo Data Versus Redo Data
    30 Minute
  • Lecture 4:
    Configuring Undo Retention
    30 Minute
Implementing Oracle Database Auditing
  • Lecture 1:
    Describe DBA responsibilities for security
    30 Minute
  • Lecture 2:
    Enable standard database auditing
    30 Minute
  • Lecture 3:
    Specify audit options
    30 Minute
  • Lecture 4:
    Review audit information
    30 Minute
  • Lecture 5:
    Maintain the audit trail
    30 Minute
Database Maintenance
  • Lecture 1:
    Manage optimizer statistics
    30 Minute
  • Lecture 2:
    Manage the Automatic Workload Repository (AWR)
    30 Minute
  • Lecture 3:
    Use the Automatic Database Diagnostic Monitor (ADDM)
    30 Minute
  • Lecture 4:
    Describe and use the advisory framework
    30 Minute
  • Lecture 5:
    Set alert thresholds
    30 Minute
  • Lecture 6:
    Use server-generated alerts
    30 Minute
  • Lecture 7:
    Use automated tasks
    30 Minute
Performance Management
  • Lecture 1:
    Performance Monitoring
    30 Minute
  • Lecture 2:
    Managing Memory Components
    30 Minute
  • Lecture 3:
    Enabling Automatic Memory Management (AMM)
    30 Minute
  • Lecture 4:
    Automatic Shared Memory Advisor
    30 Minute
  • Lecture 5:
    Using Memory Advisors
    30 Minute
  • Lecture 6:
    Dynamic Performance Statistics
    30 Minute
  • Lecture 7:
    Troubleshooting and Tuning Views
    30 Minute
  • Lecture 8:
    Invalid and Unusable Objects
    30 Minute
Performing Database Backups using RMAN
  • Lecture 1:
    Backup Solutions: Overview
    30 Minute
  • Lecture 2:
    Oracle Secure Backup
    30 Minute
  • Lecture 3:
    User-Managed Backup
    30 Minute
  • Lecture 4:
    Terminology
    30 Minute
  • Lecture 5:
    Recovery Manager (RMAN)
    30 Minute
  • Lecture 6:
    Configuring Backup Settings
    30 Minute
  • Lecture 7:
    Backing Up the Control File to a Trace File
    30 Minute
  • Lecture 8:
    Monitoring the Flash Recovery Area
    30 Minute
Performing Database Recovery
  • Lecture 1:
    Opening a Database
    30 Minute
  • Lecture 2:
    Data Recovery Advisor
    30 Minute
  • Lecture 3:
    Loss of a Control File
    30 Minute
  • Lecture 4:
    Loss of a Redo Log File
    30 Minute
  • Lecture 5:
    Data Recovery Advisor
    30 Minute
  • Lecture 6:
    Data Failures
    30 Minute
  • Lecture 7:
    Listing Data Failures
    30 Minute
  • Lecture 8:
    Data Recovery Advisor Views
    30 Minute
Data Replication
  • Lecture 1:
    Describe ways to move data
    30 Minute
  • Lecture 2:
    Create and use directory objects
    30 Minute
  • Lecture 3:
    Use SQL*Loader to move data
    30 Minute
  • Lecture 4:
    Use external tables to move data
    30 Minute
  • Lecture 5:
    General architecture of Oracle Data Pump
    30 Minute
  • Lecture 6:
    Use Data Pump export and import to move data
    30 Minute