ORACLE DBA TRAINING IN CHENNAI

 Home    IT Training    ORACLE DBA TRAINING IN CHENNAI 

Oracle DBA Training in Chennai


Our Oracle DBA Training in Chennai aims to teach beginners and employees. Oracle, the term can be defined as trademark of RDBMS. We are the Best Oracle DBA Training Institute in Chennai in-terms of syllabus and expert teaching. Oracle rapidly converging all IT required solutions like middleware, storage and OS by acquiring leading core pioneers and technology players in market. It is providing very strong and unique supports to customers. Still now oracle has acquired around 40 companies and expands its wings around 90% on RDBMS and ERP tools and services and related technologies. Oracle DBA is a leading and demanding skill-sets in IT as well highly paid jobs since the role need to be handling the backbone of organization’s vital data management at large scale.

We are Velgro Academy and covering Oracle® DBA course at unique level in all aspects Technical as well real time oriented. Our core ideology is to nurture each Oracle® DBA aspirants should be much strong in concepts as well must be opt in handling real time issues. Our faculty has extensive year’s hands on experience in oracle installation, upgrade, data guard and RAC installation and strong knowledge in real time issues handling and consultant area.

Especially at Velgro Academy, students are being trained and educated by core people, therefore we declare with sense of pride that student technical aspects would be level of IT competence. We designed syllabus at unique level, our motto is especially the DBA course deliverance shouldn’t be level of certificate mode and must be level of real time focused. We keep ourselves align with IT new technology needs and empowering and enhancing our Course syllabus, since it is very strong base for us.

Oracle DBA Training Syllabus:


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

Instance Architecture

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

Oracle Instance Internals

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

Using SQL*Plus for DBA management

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

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

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

Oracle database management

Overview of instance management

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

Initialization file management

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

Oracle*Net configuration

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

Data buffer configuration & sizing

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

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

Troubleshooting network connectivity

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

Oracle Object Management

Oracle tables, views and materialized views

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

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

Oracle constraints

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

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)

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)

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)

Monitoring Oracle

Dictionary and v$ views

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

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

Workload & Trend Monitoring

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

Instance Monitoring

  • Monitoring with the AWR and STATSPACK
  • Creating a time-series performance report
  • Using www.statspackanalyzer.com
  • Scripts for AWR and STATSPACK
  • Plotting performance data (Ion, 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

Performance Management

Bottleneck performance analysis

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

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)

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

Tracing SQL Execution

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

SQL Execution Internals

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

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

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

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

Course Duration:  2  to  3 Month, 2 hpd

Contact:  +91  7092284244

Mail:  info@velgrotechnologies.com

Click here for Offer

Training Courses


  • Adobe Photoshop Training in Velachery
  • Adobe Flash Training in Velachery
  • Adobe Flex Training in Velachery
  • Adobe Dreamweaver Training in Velachery
  • Oracle Training in Velachery
  • Teradata Training in Velachery
  • Informix Training in Velachery
  • Sybase Training in Velachery
  • MongoDB Training in Velachery
  • Apache Cassandra Training in Velachery
  • Oracle DBA Training in Velachery
  • Advanced Oracle DBA Training in Velachery
  • Oracle Apps DBA Training in Velachery
  • Performance Tuning Training in Velachery
  • SQL Server DBA Training in Velachery
  • DB2 DBA Training in Velachery
  • Teradata DBA Training in Velachery
  • MySQL DBA Training in Velachery
  • MongoDB Admin Training in Velachery
  • Informatica Training in Velachery
  • DataStage Training in Velachery
  • OBIEE Training in Velachery
  • Microsoft BI Training in Velachery
  • Microstrategy Training in Velachery
  • Cognos Training in Velachery
  • Cognos TM1 Training in Velachery
  • SAS Training in Velachery
  • Hadoop Training in Velachery
  • Big Data Analytics Training in Velachery
  • R Programming Training in Velachery
  • Cognos TM1 Training in Velachery
  • Ab Initio Training in Velachery
  • Informatica Data Quality Training in Velachery
  • Informatica MDM Training in Velachery
  • Business Objects Training in Velachery
  • Qlikview Training in Velachery
  • Tableau Training in Velachery
  • Pentaho Training in Velachery
  • DataScience Training in Velachery
  • DataScience with R Training in Velachery
  • DataScience with SAS Training in Velachery
  • DataScience with Python Training in Velachery
  • Apache Spark Training in Velachery
  • HTML Training in Velachery
  • CSS Training in Velachery
  • PHP Training in Velachery
  • Mysql Training in Velachery
  • JavaScript Training in Velachery
  • DB2 DBA Training in Velachery
  • AngularJS Training in Velachery
  • Node.js Training in Velachery
  • AngularJS2 Training in Velachery
  • React.js Training in Velachery
  • Core Java Training in Velachery
  • J2EE Training in Velachery
  • Struts Training in Velachery
  • Hibernate Training in Velachery
  • Spring Training in Velachery
  • Manual Testing Training in Velachery
  • QTP Training in Velachery
  • LoadRunner Training in Velachery
  • JMeter Training in Velachery
  • Selenium Training in Velachery
  • ETL Training in Velachery
  • Mobile Application Training in Velachery
  • Complete Test Training in Velachery
  • SoapUI Training in Velachery
  • Big Data Testing Training in Velachery
  • Coded UI Training in Velachery
  • Dot Net Training in Velachery
  • Advanced .NET Training in Velachery
  • SharePoint Training in Velachery
  • SharePoint Admin Training in Velachery
  • Microsoft Dynamics Training in Velachery
  • SCCM Training in Velachery
  • Windows Server Administration Training in Velachery
  • MCSA Training in Velachery
  • MicroSoft - Excel Training in Velachery
  • Windows Azure Training in Velachery
  • MVC Training in Velachery
  • Oracle Apps Finance Training in Velachery
  • Oracle Apps SCM Training in Velachery
  • Oracle Apps HRMS Training in Velachery
  • Oracle Apps Technical Training in Velachery
  • PeopleSoft Finance Training in Velachery
  • PeopleSoft HCM Training in Velachery
  • Android Training in Velachery
  • iOS Training in Velachery
  • Objective-C Training in Velachery
  • PhoneGap Training in Velachery
  • Weblogic Server Training in Velachery
  • SOA Admin Training in Velachery
  • Oracle Identity Manager Training in Velachery
  • Oracle 11g Training in Velachery
  • Oracle ADF Training in Velachery
  • Forms & Reports Training in Velachery
  • Hyperion Planning Training in Velachery
  • Hyperion Financial Management Training in Velachery
  • ODI Training in Velachery
  • Oracle Essbase Training in Velachery
  • Amazon Web Services Training in Velachery
  • Workday Training in Velachery
  • Salesforce Admin Training in Velachery
  • Salesforce Developer Training in Velachery
  • VMWare Training in Velachery
  • OpenStack Training in Velachery
  • OpenNebula Training in Velachery
  • Citrix Training in Velachery
  • Mainframe Developer Training in Velachery
  • Mainframe Admin Training in Velachery
  • Websphere Training in Velachery
  • Websphere MQ Admin Training in Velachery
  • Websphere Message Broker Training in Velachery
  • Pega Training in Velachery
  • UNIX Training in Velachery
  • Linux Training in Velachery
  • C C++ Training in Velachery
  • CCNA Training in Velachery
  • CCNP Training in Velachery