Contact Premier Online Trainings Today

Oracle DBA 11g & 12c

  • Home
  • Oracle DBA 11g & 12c
Courses Overview
Premier Online Trainings Institute provides best Oracle DBA 11g & 12c 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
  • Explain user connects to database
  • Introduction to Instance and Database
  • Explain SQL statement's process in the database
  • Oracle data dictionary and its role
  • Oracle database memory components and background process
  • Advance Startup and Shutdown Scenarios.
  • 11g Features and 12c introduced features (CDB and PDBs)
  • Alert log and trace files
  • 11g and 12c installation using real time tools like Putty, winscp, VNC viewer
  • DBCA Configuration
  • Manual Database creation
  • Creation of Parameter file
  • Executing scripts
  • Multiplexing control files
  • Multiplexing redo log files
  • Renaming and relocating redo log files
  • Enable/disable archive log mode
  • Benefits of Multitenant Architecture
  • Configurations
  • Multitenant Container Database
  • Structure of Pluggable Database
  • Creating Multitenant Container Databases and Pluggable Databases
  • 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
  • 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
  • Overview of managing tablespaces
  • Local vs dictionary managed tablespaces
  • Bigfile tablespace
  • 12c Online datafile movement
  • Temporary tablespace and issues
  • Undo tablespace management and issues
  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles & profiles
  • Parameters (Resource and password)
  • Importance of Auditing
  • Enable/disable different levels of auditing
  • Configure listener.ora, tnsnames.ora and sqlnet.ora
  • Database user connectivity
  • Database links, materialized views
  • SQL*Loader
  • Export/import, Datapump
  • 12c datapump new features
  • Understanding COLD and HOT backup
  • Using COLD backup and Recovery
  • Using HOT backup and Recovery
  • Describe Flashback technology
  • Flashback Query & Flashback Transaction Query
  • Monitor Flashback Database
  • Using COLD backup Refresh the environment
  • Using HOT backup Refresh the environment
  • RMAN backup and recoveries
  • Recovery catalog
  • RMAN incremental backups
  • Tuning RMAN backup performance
  • 12c single table restore using RMAN
  • Duplicate a database with RMAN
  • Describe the benefits of using ASM
  • Implementing ASM for oracle database
  • Manage the ASM instance
  • Create and drop ASM disk groups
  • Extend ASM disk groups
  • Overview of Patching
  • Applying patch on the database
  • Upgrading lower versions to 12c
  • Explain different Phases of tuning
  • Gather statistics
  • Analyzing AWR, ADDM and ASH reports