Do you have theoretical knowledge on Core Oracle DBA concepts? Then, you are looking at the right course to make you a better Oracle DBA.

Get hands-on real time activities experience on standalone Oracle Database environment now.

  • Install and Implement yourself.
  • Simple and easy to understand.
  • Improve your skills with Real-Time activities.
  • Meet industry standards.

System requirements:

  • Laptop/Desktop with at least 3GB RAM.
  • Minimum of Dual Core processor.
  • 40 GB of disk space.

Training details:

  • 30 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

Demo Video:

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

  1. Installation
  • Architecture 11g – Overview
  • OS installation
  • Oracle Software installation
  • Oracle network and database installation
  1. DP Activities
  • Table refreshes – multiple possibilities
  • Backup Options and best methods – Various scenarios
  • Schema restore to same database – multiple possibilities
  • Schema refreshes – Scenarios
  • Monitoring DP jobs and resolve the issues
  • EXCLUDE options and its needs
  • Transportable tablespaces activities
  1. Listener activities
  • Adding service to listener
  • Changing service names at TNS
  • Check connection from which service
  • configuring password to listener
  • IP based access restriction to the database
  1. Activities 1
  • Control file backups
  • Handling LOCKS, BLOCKS and DEADLOCKS
  • Cleaning up sessions in Oracle
  • Monitor and analyze a session activity
  • Password file issues and management
  • SPFILE – Static and Dynamic
  • PFILE – Static and Dynamic
  • Archivelog mode and Seting FRA
  1. DB rename
  • Using NID
  • Using Control file
  1. RMAN Activities
  • Monitor backup details.
  • Methods of backing up database.
  • Options in backing up database.
  • Optimize backup size.
  • Optimize backup time.
  • Mutil file backup strategies.
  • Configure, Administer and Maintain Recovery catalog.
  • Block change tracking issues and handling.
  • Handling block and datafile corruptions.
  • Restoration scenarios
  • Recovery scenarios
  • Cloning a database – Partial
  1. Cloning activities
  • Migrate database from one server to another
  • RMAN Duplication from backups NO Target connection
  • RMAN Duplication from backups with Target connection
  • RMAN Duplication from active database same database
  • RMAN Duplication from active database remote database
  • Clone ORACLE HOME same server
  • RMAN duplication to fresh remote server
  • Clone ORACLE HOME different server
  1. Tablespace management
  • Check tablespace utilizations
  • Understand AUTOEXTEND option
  • Understand difference between SMALLFILE AND BIGFILE datafile
  • Moving datafile to different mount point
  • Check and action on TEMP tablespace
  • TEMP datafile errors
  • OMF/ NON OMF datafiles
  • Check UNDO utilization and appropriate actions
  • Create and insert huge data into table and delete all rows.
  • Datafile fragmentation and defragmentation methods
  • ORA 01555 error on UNDO and reasons
  1. User Management
  • Check user default tablespace
  • Give Quota to different TBS
  • Check profiles
  • Check SYSTEM/ROLE/TABLE privileges
  • Password management of a user
  • User privileges on TBS
  1. Patching Activities
  • Introduction to Patches
  • Apply bug fixes to database
  • Apply CPU/PSU patch to the database
  • Apply PSU patch
  1. Performance tuning Activities
  • Generate explain plan and analyze
  • Explain plan with index
  • Explain plan with data deletion
  • Explain plan and statistics
  • Options in DBMS_STATS.GATHER_table_stats
  • Schema stats and does it make any difference
  • Rebuilding indexes
  • Gathering Index stats
  • Generate AWR report and analyze
  • Generate ADDM report and analyze
  • Generate ASH report and analyze
  • Run SQL tuning advisor and analyze
  1. Flashback activities
  • Flashback query
  • Flashback to original table
  • Flashback to new table
  • Flashback database
  • Flashback database to restore point
  1. Tablespace point in time recovery
  • TBSPITR to same existing database
  • RMAN Duplication for PITR of a tablespace
  • To AUXIL instance
  1. Triggers
  • Create startup trigger
  • Create shutdown trigger
  • Create logon trigger
  • Create trigger on oracle error
  1. Log miner
  • Configure dictionary file
  • Add archivelog file to log miner
  • Start logminer, Analyse and stop log miner
  1. Activities 2
  • Oracle database DB Links
  • Configure
  • Usage
  • SQL Loader
  • Create control file
  • Data in text file
  • Load data to table
  • Enable compression on table
  • Table partitioning
  • Use External table
  • use of V$resource_limit
  1. Scheduling jobs
  • Create program
  • Run RMAN script via DBMS_SCHEDULER
  • Create JOB
  • Create job to run a procedure
  • drop a job, program
  1. AUDITING
  • Concepts
  • Fine grain auditing
  • Standard auditing
  • Select table
  1. Silent Installation
  • Deinstall oracle DB, Oracle SW
  • Detach oracle home from inventory
  • Silent installation of Software
  • Silent installation of Network/Listener
  • Silent installation of database
  1. Scripting
  • COPY tables in SQLPLUS
  • Scripting and CRONTAB
  • RMAN backup example
  • Gathering stats example
  • Housekeeping example
  1. Upgradataions
  • Upgrade database from 11.1.0.6 to 11.2.0.3
  • Upgrade database from 10.2.0.1 to 10.2.0.4
  • Upgrade database from 10.2.0.4 to 11.1.0.6
  • Upgrade database from 11.1.0.6 to 11.2.0.1
  • Upgrade database from 11.2.0.1 to 11.2.0.3
  1. DBA daily activities summary