Oracle DBA Training Online  

- Join Now

The Oracle DBA Training Course is designed for professionals who wants to enhance their skills. The Course, Oracle DBA Training, includes Slides, Handouts, Test Series, Lab Assignments and Interactive Videos make the learning more effective. The goal of this course is to cover the Oracle architecture and internal mechanisms such that the participant is able to perform all necessary tasks as Oracle DBA. The course also covers Oracle networking basics and the Oracle utility programs.

Target Audience

This course is designed for the computer professional who needs to understand the concepts and architecture of Oracle. This includes Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand the architecture of an Oracle database. The participants should understand basic relational database concepts such as SQL before enrolling in this training. By the end of this course the student will have a functional understanding of the roles and duties involved in Oracle database administration and be able to perform basic Oracle DBA tasks.

 

Why choose Oracle Training Online?

The oracle dba online training in India is considered the best course for people who are pursuing their careers in IT fields. The DBA certification makes you a certified Oracle Database Administrator. You will be provided the best mentors and guidelines for the course. All types of professionals can pursue the courses like software developers, Database operators, Architects, project managers, etc. The relational database management system is linked to the Oracle DBA qualification. Database administrators are responsible for managing massive amounts of data in large organizations. As a result, Oracle DBA specialists are in high demand. This training course will give you the abilities you need to work as a Database Administrator in a top company and earn a high salary. Learn Oracle online courses this will save your time and money. These short-term courses will help you in getting good salaries and add features to your resume. Demo Videos are available at Youtube.

  1. Oracle 19c Installation | SQL Developer Installation | oracle 13c oem installation on Linux
  2. Create Database with DBCA and command line
  3. Managing Database Storage Structures
  4. Administering User Security
  5. Managing Schema Objects

Oracle DBA Training Course Contents

Part 1. Oracle Introduction, Architecture and Configuration

  1. Oracle Overview and Installation

  • Popular database management systems and Oracle.
  • Oracle database market share
  • Tasks of a Database Administrator.

  1. Installing Oracle Database

  • Planning Oracle Database 19c Install
  • Reviewing the System Requirements
  • Oracle Inventory
  • Job Role Separation Using OS Groups
  • Directory Paths and Operating-System Variables
  • The Oracle Universal Installer
  • Unzipping Software and Starting the OUI

Lab 1. Installing Oracle 19c on Linux

  1. Oracle Database Architecture

  • Oracle database architecture.
  • Oracle database memory and process architecture.
  • Understand initialization parameter files
  • Configure Oracle Enterprise Manager (OEM) Database Express web based tool.

Lab 2. Configure OEM Express Web based Tool

Part 2. Oracle database and Security management

  1. Creating an Oracle Database

  • Planning for an Oracle database creation.
  • Creating a database using CREATE DATABASE SQL command.
  • Create a database with the Database Configuration Assistant (DBCA)
  • Create a database design template with the DBCA
  • Generate database creation scripts with the DBCA

Lab 3. Create and Explore Oracle Databases

  1. Managing the Oracle Instance

  • Start and stop the Oracle database and components
  • Advance Startup and Shutdown scenarios.
  • Use Enterprise Manager Express (OEM) Web based
  • Access a database with SQL*Plus and iSQL*Plus

  1. Getting Started with Oracle Database

  • Understand the stages of database startup
  • View the database alert log
  • The Oracle database job scheduler API (DBMS_SCHEDULER package)
  • Use the Data Dictionary

  1. Managing Database Storage Structures

  • Oracle tablespaces and allocation types.
  • How to create small file (default) and big file tablespaces.
  • How to create datafiles with fixed size and auto extend option.
  • What are control files and how to view control file content in a trace file.
  • How to rename datafiles in a control file.
  • Temporary tablespaces and temporary tablespace groups.
  • Managing Undo Data
  • Explain DML and undo data generation
  • How to add data files to undo tablespaces.
  • Configure undo retention.
  • Understand Oracle database read consistency

Lab 5 Working with Database Storage

  1. Administering User Security

  • Create and manage database user accounts.
  • Grant and revoke privileges.
  • Create and manage roles.
  • Create and manage profiles.

Part 3. Oracle object management

  1. Managing Schema Objects

  • Schema and Database Objects
  • Setting up the Environment
  • Create a Database Connection in SQL Developer
  • Viewing Tables, Creating a Table, Adding Columns to a Table
  • View Indexes, Create Index
  • Managing Views, Create View
  • Program Code Stored in the Database
  • Validating Invalid Schema Objects
  • Temporary Tables
  • Temporary Tables and Undo

  1. Standard Database Auditing

  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail

  1. Configuring the Oracle Network Environment

  • Oracle Net Services
  • Listener Control Utility
  • Net Configuration Assistant
  • Create additional listeners
  • Control the Oracle Net Listener
  • Naming Methods
  • Use tnsping to test Oracle Net connectivity
  • Connection Pooling
  • Identify when to use shared servers and when to use dedicated servers
  • Communication Between Databases

Part 4. Oracle Database Backup and Recovery

  1. Backup and Recovery Concepts

  • Identify the types of failure that can occur in an Oracle database
  • Flashback Technology
  • Understanding Instance Recovery
  • Describe ways to tune instance recovery
  • Importance of checkpoints, redo log files, and archive log files
  • Methods of Backup
  • Configuring for Recoverability
  • Configure the fast recovery area
  • Configure ARCHIVELOG mode

  1. Moving Data

  • Describe available ways for moving data
  • Create and use directory objects
  • Use SQL*Loader to load data from a non-Oracle database (or user files)
  • Explain the general architecture of Data Pump
  • Use Data Pump Export and Import to move data between Oracle databases
  • Use external tables to move data via platform-independent files

  1. RMAN Backup and Recovery

  • Advantages of RMAN method compared to the user-managed method.
  • Create consistent database backups using RMAN.
  • Create inconsistent database backups (without shutting it down) using RMAN.
  • Oracle database backup metadata.
  • How to create incremental backups using RMAN.
  • How to clone a database using RMAN backup based duplication.
  • How to restore and recover a full database from its RMAN backup.
  • Use Data Recovery Advisor to perform recovery of the control file and redo log file.
  • How to drop a database using RMAN
  • Oracle database backup retention policies and backups to Tape/offsite.
  • How to purge old backups using RMAN.

  1. Flashback

  • Flashback Database Architecture
  • Configuring and Monitoring Flashback Database
  • Backing Up the Flash Recovery Area
  • Using V$FLASH_RECOVERY_AREA_USAGE
  • Flashback Database Considerations
  • Using the Flashback Database RMAN interface
  • Managing and monitoring Flashback Database operations

  1. Recovering from Non-critical Losses

  • Recover temporary tablespaces
  • Recover a redo log group member
  • Recover from a lost index
  • Re-create the password file

  1. Dealing with Database Corruption

  • Identify the causes of database corruption:
    • Hardware
    • Software
  • Detect database corruption by using:
    • ANALYZE
    • DBVERIFY
    • DB_BLOCK_CHECKING
    • DBMS_REPAIR
  • Repair corruptions by using RMAN

 

Part 5. Monitoring Oracle

  1. Monitoring and Managing Storage

  • Database Storage Structures
  • Space Management Overview
  • Oracle-Managed Files (OMF)
  • Row Chaining and Migrating
  • Proactive Tablespace Monitoring
  • Managing Resumable Space Allocation
  • SYSAUX Tablespace
  • Monitoring table and index space usage
  • Automatic Undo Management
  • Redo Log Files
  • Table Types
  • Partitioned Tables
  • Index-Organized Tables (IOT)
  • Managing index space with SQL
  • Configure optimal redo log file size
  • View “Automatic Tuning of Undo Retention”

  1. Automating Tasks with the Scheduler

  • Scheduler Concepts
  • Creating a Job Class and a Window
  • Managing Jobs, Programs, Chains, Events, Schedules, priority
  • Viewing and Purging Job Logs
  • Creating a program and a schedule
  • Creating a job that uses a program and a schedule
  • Altering the program and schedule for the job and observing the behavior change of the job
  • Monitoring job runs

  1. Table & index monitoring

  • Monitoring table extents and fragmentation
  • Using the dba_tables and dba_segments views
  • Monitoring table CBO statistics
  • Monitoring table extents and fragmentation
  • Locating chained rows

  1. Monitoring with the AWR and STATSPACK

  • Creating a time-series performance report
  • Using www.statspackanalyzer.com
  • Scripts for AWR and STATSPACK
  • Plotting performance data (WISE, Excel)
  • Finding performance trends and signatures
  • Oracle environment monitoring
  • Displaying and managing Oracle sessions (v$session, v$process)
  • Using AWR to monitor disk, network and CPU consumption
  • Monitoring the alert log
  • Oracle trace/dump files
  • STATSPACK and AWR performance management
  • Installing STATSPACK
  • Running STATSPACK reports
  • Interpreting a STATSPACK report
  • Getting time series reports with STATSPACK
  • Finding performance signatures with STATSPACK

Part 6. RAC Administration

  • Grid Infrastructure Overview and Review
  • RAC Databases Overview & Architecture
  • Installing and Configuring Oracle RAC
  • Oracle RAC Administration
  • Managing Backup and Recovery for RAC
  • RAC Backup and Recovery
  • RAC Global Resource Management and Cache Fusion
  • RAC Database Monitoring and Tuning
  • Managing High Availability of Services in a RAC Environment
  • Managing High Availability of Connections
  • Application Continuity
  • RAC One Node
  • Multitenant Architecture and RAC
  • Quality of Service Management