Contact Premier Online Trainings Today
Premier Online Trainings

Oracle DBA 12C & 19C

  • Home
  • Oracle DBA 12C & 19C
Courses Overview
Premier Online Trainings Institute provides best Oracle DBA 12C & 19C training in Hyderabad, Banglore by our Highly Professional certified trainers.

We are offering a world class oracle database administration(DBAs) training programme for interested college students and professionals. For those who are already in IT and would like to jump into the world of Database Administration. Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance activitys.

* We also provide Online Training for Normal Track, Fast Track and Weekend Batches
Course Curriculum
  • What is DBA?
  • Why a Company needs a DBA?
  • Roles & Responsibilities of DBA
  • Identify the oracle product
  • Oracle Database Architecture
  • Physical and Logical Phase of Database
  • System requirements
  • Redhat Linux Installation (OEL)
  • Using real time tools like Putty, winscp, VNC viewer
  • Install software with the Oracle Universal Installer on Linux Platform
  • Identify System Requirements
  • Optimal Flexible Architecture (OFA)
  • Discuss Oracle Base and Oracle Home
  • Configure Ms Windows Installation
  • Prerequisite Checks and Fixup Utility
  • Oracle Database Server Architecture
  • Oracle Database Instance Configurations
  • Connecting to the Database Instance
  • Oracle Database Memory Structures and background process
  • Discuss about Control files
  • How to manage the Control files
  • Multiplexing the Control files
  • Brief about online redo log files
  • More About Datafiles concepts
  • Brief About Parameter files
  • Discuss about Password files
  • How to create spfile and pfile
  • What is spfile?
  • Difference between spfile and pfile
  • Database Configuration Assistant (DBCA)
  • Create a New Database
  • Configure an Existing Database
  • Drop a Database
  • Manually Create A Database
  • More About the Database Files
  • Connecting to an Oracle Database Instance
  • Oracle Database Tools
  • SQL*Plus
  • Oracle SQL Developer
  • Database Configuration Assistant (DBCA)
  • Oracle Enterprise Manager Database Express
  • Tools used for Create Database (DBCA,SQL*Plus & SQL Developer)
  • Data Dictionary Views (DBA_xxx, CDB_xxx, V$xxx Views)
  • Create New PDB from PDB$SEED
  • Plug a Non-CDB into CDB(Container Database)
  • Clone a PDB into the same CDB
  • Plug Unplugged PDB in to CDB
  • Working with Initialization Parameters
  • Connect to a CDB and to a PDB
  • Starting Up, Mounting and Opening a CDB
  • Opening & Closing a PDB
  • Shutting Down a CDB Instance
  • Changing PDB Mode
  • Alert log and trace files
  • Oracle Net Services
  • Oracle Net Listener
  • The Default Listener
  • Establishing Oracle Network Connections
  • Connecting to an Oracle Database
  • Database links, materialized views
  • Database User Accounts
  • Oracle-Supplied Administrator Accounts
  • Creating Oracle Database Users in a Multitenant Environment
  • Schema-Only Account
  • Authenticating Users
  • System Privileges for Administrators
  • Object Privileges
  • Granting Privileges in a Multitenant Environment
  • Granting and Revoking System Privileges
  • Granting and Revoking Object Privileges
  • Create and manage roles & Profiles
  • Creating Tablespaces
  • Creating Permanent Tablespaces
  • Altering and Dropping Tablespaces
  • Viewing Tablespace Information
  • Space Management Features
  • Block Space Management
  • Row Chaining and Migration
  • Types of Segments
  • Allocating Extents
  • Managing Data Files
  • Managing Temp Files
  • Enable Oracle-Managed Files (OMF)
  • Renaming a data file
  • Temporary Groups
  • About Undo Space Management
  • Configure Undo Management
  • Undo Management
  • Undo Tablespace
  • Undo Retention
  • Guarantee Undo Retention
  • Monitor Undo Space
  • Introduction Data pump (expdp, impdp) Utilities
  • Exporting/Importing Tables
  • Exporting/Importing Schemas
  • Exporting/Importing Table space
  • Exporting/Importing Database
  • Discuss New features concept 19c
  • Understanding COLD & HOT backup
  • Using COLD backup and Recovery
  • Using HOT backup and Recovery
  • Types of Failures
  • Instance Recovery
  • Automatic Instance Recovery or Crash Recovery
  • Using the MTTR Advisor
  • Complete Recovery Process
  • The Point-in-Time Recovery Process
  • Configuring for Recoverability
  • Redo Log Files
  • RMAN Backup
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points
  • Using COLD backup Refresh the environment
  • Using HOT backup Refresh the environment
  • Using RMAN backup Refresh the environment
  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation
  • Upgrading lower versions to 19c
  • Why Tuning required?
  • Types of Tuning
  • Proactive Vs Reactive Tuning
  • Tuning through effective DB Configurations
  • Health Management/Periodical Checkup
  • Database Tuning
  • Gather stats
  • Application Tuning
  • SQL Tuning
  • Memory Tuning
  • Network Tuning
  • Tuning Memory, Disk I/O
  • AWR/ASH/ASMM/ADDM
  • Resource Intensive SQL
  • Managing the DB Statistics ( for CBO)
  • Managing the AWR Snapshots
  • Generating/ Interpreting the AWR Report
  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches