Oracle DBA Classroom Training

Oracle DBA Training program with 100% COMPLETE PRACTICAL and REAL-TIME subject. Course starts from the Basics of SQL to Intermediate concepts like ARMAN Backups to Advanced concpets like RAC and Indepth Tuning Techniques. Course includes Resume Guidance, Interview and Certification Guidance. Register Today

Schedules for Oracle DBA Classroom Training

Regular Schedules (Mon - Sat)

Start Date Location Trainer Register
1 8 AM - 9:30 AM Jan 29th SR Nagar Mr. Mishra Register
2 9 AM- 10 AM Jan 22nd SR Nagar Mr. Subhash Register

Weekend Schedules (Sat, Sun)

1 8 AM - 11 AM Jan 20th SR Nagar Mr. Mishra Register

Total Course Fee: INR 10000/-
Course Fee payable in two equal installments.

Duration: 7 Weeks / 9 Weekends

Training Highlights

Daily Tasks Weekly Interviews
Real-time Project Resume Guidance
Certification Guidance Placement Services

Who can take this Course?

This Oracle DBA Course is helpful for aspiring RAC DBAs, ORacle Golden Gate, Data Analysts, Data Scientits, and more..!

Oracle DBA Training Course Contents:

Oracle DBA Course

CHAPTER 1 : Overview of Oracle DBA tasks

  • Oracle as a flexible, complex & robust RDBMS
  • The evolution of hardware and the relation to Oracle
  • Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter)
  • The changing job role of the Oracle DBA
  • Environment management (network, CPU, disk and RAM)
  • Instance management (managing SGA regions)
  • Oracle table and index management

CHAPTER 2 : Instance Architecture

  • Instance vs. database
  • Components of an instance
  • Creating the OFA file structure ($DBA, bdump, udump, pfile)

CHAPTER 3 : Oracle Instance Internals

  • SGA vs. PGA
  • Background processes
  • Interfaces with server and disk I/O subsystem

CHAPTER 4 : Using SQL*Plus for DBA management

  • Connecting and executing SQL
  • Using the “as sysdba” syntax
  • Overview of SQL*Plus DBA commands (startup, etc.)

CHAPTER 5 : Control file, UNDO and REDO management

  • Explaining the use of control files
  • Listing the Contents of the control File
  • File locations for control Files
  • Obtaining Control File Information
  • Listing control file contents
  • Displaying and Creating Undo segments
  • Altering Undo Segments
  • Determining the Number and Size of Undo segments
  • Understanding flashback technology
  • Troubleshooting Undo – snapshot too old
  • Redo log concepts for recovery
  • Online redo log (log_buffer) online redo logs and archived redo logs
  • Oracle ARCH and LGWR background processes
  • Redo log dictionary queries
  • Redo log switch frequency and performance
  • Multiplexing the Online Redo Log Files
  • Archiving the Oracle Redo Logs
  • Recovery using the redo log files

CHAPTER 6 : User and privilege management

  • The three security methods (VPD, Grant security/role-based security, grant execute)
  • Creating New Database Users
  • Using pre-spawned Oracle connections
  • Auditing User activity
  • Identifying System and Object Privileges
  • Granting and Revoking Privileges
  • Creating and Modifying Roles
  • Displaying user security Information from the Data Dictionary

CHAPTER 7 : Overview of instance management

  • Parameter files (init.ora, listener.ora, tnsnames.ora)
  • Rules for sizing SGA components
  • Automated Oracle memory management (AMM)

CHAPTER 8 : Initialization file management

  • Creating the init.ora file
  • Using spfile
  • Displaying init.ora values with v$parameter

CHAPTER 9 : Oracle*Net configuration

  • Creating the listener.ora file
  • Creating the tnsnames.ora file

CHAPTER 10 : Data buffer configuration & sizing

  • Inside the Oracle data buffers
  • Using the KEEP pool
  • Monitoring buffer effectiveness
  • Using multiple blocksizes (multiple buffer pools)

CHAPTER 11 : Shared pool and PGA configuration & Sizing

  • Shared pool concepts and components
  • Understanding the library cache
  • Relieving shared pool contention
  • Overview of PGA for sorting and hash joins
  • Using sort_area_size, hash_area_size and pga_aggregate_target

CHAPTER 12 : Troubleshooting network connectivity

  • Verifying network connectivity with ping and tnsping
  • Testing database links

CHAPTER 13 : Oracle tables, views and materialized views

  • Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables)
  • Oracle Views
  • Oracle materialized views

CHAPTER 14 : Oracle indexes

  • Types of Oracle indexes (b-tree, bitmap, bitmap join index)
  • Creating B*-Tree, bitmap and function-based Indexes
  • Function-based indexes
  • Finding indexing opportunities
  • • Index maintenance

CHAPTER 15 : Oracle constraints

  • Costs & benefits of constraints
  • Types of Oracle indexes constraints (check, not null, unique, PK, FK)
  • Cascading constraints

CHAPTER 16 : Schema, File & tablespace management

  • Describing the relationship between data files, tablespaces and table
  • Understanding Oracle segments
  • Creating Tablespaces – using the autoextend option
  • Changing the Size of Tablespaces – alter database datafile command
  • Defining a TEMP tablespace
  • Changing the default storage Settings for a tablespace
  • Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists).
  • Monitoring Chained rows (fetch continued rows)
  • Monitoring Insert and Update performance (pctused, APPEND)

CHAPTER 17 : Database Maintenance

  • Reason for reorgs – chained rows, imbalanced freelists
  • Reorganizing Tables using Export and Import
  • Using CTAS to reorganize data
  • Index rebuilding
  • Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking)

Chapter 18 : Oracle DBA Utilities

  • Data pump (Imp and exp utilities)
  • SQL*Loader
  • LogMiner
  • Flashback
  • DataGuard
  • Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
  • Replication (Streams, multimaster, materialized views)

CHAPTER 19 : Dictionary and v$ views

  • The dba_, all_ and user_ structures
  • Querying the tables, indexes, and segments views
  • Querying the AWR (STATSPACK) tables

CHAPTER 20 : 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
  • Monitoring table & index growth
  • Monitoring index usage
  • Monitoring index fragmentation
  • Locating un-used indexes
  • Identifying IOT candidates
  • Reorganizing Indexes with alter index rebuild
  • Dropping Indexes
  • Getting Index Information from the Data Dictionary

CHAPTER 21 : workload & trend monitoring

  • Oracle automated workload tools
  • Using v$bh to monitor buffer activity
  • Using v$sql and v$sql_plan

CHAPTER 22 : Instance monitoring

  •  Monitoring with the AWR and STATSPACK
  • Creating a time-series performance report
  • Using
  • Scripts for AWR and STATSPACK
  • Plotting performance data (Ion, Excel)
  • Finding performance trends and signatures

CHAPTER 23 : 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

CHAPTER 24 : 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

CHAPTER 25 : Bottleneck performance analysis

  • Drill-down into AWR reports
  • Top-5 timed events
  • External Server Bottlenecks (Network, I/O, RAM, CPU)
  • Network troubleshooting 

CHAPTER 26 : Instance Tuning

  • Changing init.ora optimizer parameters (index_optimizer_cost_adj, optimizer_mode)
  • Managing region parameters (shared_pool_size, db_cache_size)
  • Understanding instance contention (e.g. Buffer busy waits, library cache contention)

CHAPTER 27 : SQL and CBO behavior

  • Introduction to cost-based optimization
  • Changing the default optimizer modes
  • Optimizer parameters
  • Dynamic sampling
  • Collecting table and index statistics (dbms_stats)
  • Using column histograms and skewonly

CHAPTER 28 : Tracing SQL Execution

  • Using “set autotrace”
  • Interpreting EXPLAIN PLAN Output
  • Using TKPROF / SQL*Trace

CHAPTER 29 : SQL Execution Internals

  • Review of Basic joining methods
  • Merge join
  • Hash Join
  • Nested Loop join
  • Advanced SQL operators
  • Between operator

CHAPTER 30 : SQL Tuning

  • Using hints to improve SQL performance
  • Using parallel query to improve performance
  • SQL reusability within the library cache
  • Table high-water mark
  • Table striping and table partitions
  • Using indexes to improve performance
  • Identifying full-table scans
  • Re-writing SQL queries
  • Tuning sub-queries

CHAPTER 31 : Oracle High Availability tools

  • Continuous availability and disaster recovery
  • Quantifying the cost of unplanned downtime
  • Oracle multi-master replication
  • DataGuard
  • Oracle Streams
  • Real Application Clusters 

CHAPTER 32 : Backup & Recovery

  • OS-level backups
  • Hardware-level backup & recovery
  • Block-level change tracking
  • Disk mirroring
  • Backup & recovery and RAID level
  • Oracle-level backups (expdp & RMAN)
  • Hot vs. Cold backups 

Sample Oracle OCP exam questions 

OCP Final Exam Review 

Full sample OCP DBA exam

OCP testing techniques for success

Testing tips and secrets

*Above course curriculum applicable for registrations from Oct 20th, 2017

24x7 Support with Real-time Databases. Course includes Real-time Database Cases. Register Today
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 Support.

Oracle DBA Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
  • Detailed Oracle Architecture
  • Query Tuning, Cloning and ARMAN Tools
  • Oracle High Availability Tools
  • Routine DBA Activities, Emergency DBA Activities
  • Schema, File & Tablespace Managements
  • Tracing SQL Executions and Exec Plans