Over View

About Oracle Database Administration Training Course

Oracle Database Administration training will help you master the Oracle DBA. As part of the training, you will master the Oracle Database architecture, the database processes, memory structures, schema objects, security, data recovery and backup through hands-on projects and case studies.

What will you learn in this Oracle DBA online training course?

  1. Core database concepts
  2. Role of a Database Administrator
  3. SQL and PL/SQL concepts
  4. Physical and logical structure of database
  5. Introduction to table space
  6. Configuring and managing the Oracle Network
  7. Database configuration and programming
  8. Installation, harnessing cloud and storage management
  9. Database best practices and scripts
  10. Preparing for the Oracle DBA Certification

Who should take up this Oracle DBA training course?

  • Software Developers and IT Professionals
  • Database Analysts and Administrators
  • SQL Programmers and Architects
  • Project Managers
  • Those aspiring for a career in Oracle DBA

What are the prerequisite for taking up this training course?

Anybody can take this training course. A basic knowledge of database can be helpful.

 

Oracle DBA Course Content

Architecture & Configuration

Overview of Oracle DBA tasks

  • Oracle as a flexible, complex & robust RDBMS
  • He 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

  • 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 data file 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
  • Introduction Data Guard
  • Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
  • Introduction 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

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

This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck.

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
  • Introduction to Data Guard

Backup & Recovery

  • OS-level backups
  • Hardware-level backup & recovery
  • Block-level change tracking
  • Disk mirroring
  • Backup & recovery and RAID level
  • Oracle-level backups
  • (exp, expdp & RMAN)
  • Hot vs. Cold backups
  • Additional Features:
  • Real time scenarios
  • Oracle dba navigation notes
  • Oracle dba Lab videos
  • Interview Questions
  • Introduction explanation on real tool in software industry
  • Information on ETL tools.

FAQ’S

What if I miss one (or) more class?

No need to worry about the classes you missed. We will definitely guide you by having optional classes or by having classes with other batches with the same topic you missed previous classes.

Who is my instructor?

IT professionals who have strong knowledge in technical know how to convey things with the real-time example. Even a layman could understand the concepts which given by our experts.

What are the modes of training offered for this course?

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

What are the system requirements to work?

Minimum 2GB RAM and i3 processor is required

Can I attend a demo session?

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

How about group discounts (or) corporate training for our team?

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Where do Our Online learners and Trainer’s come from

We are providing online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

I have more queries?

If you want to know More Details about Online Training Please Contact us. Or you can share your quires through info@monstercourses.com. Estimated turnaround time will be 24 hours for mails.

Contact us

Enquiry Now..!!

Contact Details :

    Address: # 4110 Rainy Creek Ln, Cedar Park, TX, 78613, USA.

    Contact us: +1(772)777-1557

    Email ID: info@monstercourses.com

     

    Popular Courses We Offered :

     

    4110 Rainy Creek Ln, Cedar Park,

    TX USA, 78613.

    Phone: +1(772)777-1557

    Email : info@monstercourses.com

     

    The Training Classes what i have attended from MonsterCourses was quite beneficial.Good way of diving modules and covering important topics in each module. Overall the training from MonsterCourses was very good and useful to me.

    Vijay Naresh…

    Raju K, Monster Courses

    I felt OBIEE online training was very informative as compared to other online training providers. The faculty of MonsterCourses are very efficient in their subject and gave quality training. They covered each and every topic clearly elaborated them with examples.

    Vinay K…

    Govardhan Bhaskar, Monster Courses

    We are very much benefited from Business objects online training program. Handouts are very useful and very nicely given so that at-least by seeing the handouts we can practice and get knowledge. We have been taught many topics from this Training, nice to getting trained from “MonsterCourses

    Govardhan Bhaskar….

    Vijay Naresh, Monster Courses