Book a Free Demo

Need help?

+91-9441803173 info.svtechhub@gmail.com
Reviews (24)
Avatar

Best Oracle DBA Online Training

DBA (Database Administrator) is responsible for design, implementation, support and maintenance of databases. SV Tech Hub training will make you an expert in managing Oracle DBA Training. By the end of the course you will get hands on experience on creating, installing and managing database administrator. Oracle DBA Online Training is foundation for building database administration. After completion of DBA Course trainee will be able to implement planned logical structure database.

Following audience can take Oracle DBA Online Training in Hyderabad database administrators, computer scientists, end users, security professionals, information system professionals, graduates who want to start their career in Oracle DBA and professionals who are looking to extend their knowledge towards advanced technologies.

The are no specific requirements for Oracle Database Training for Beginners functional knowledge on database systems and computers is added advantage and meet requirements of installing Oracle Data base software. Oracle DBA Course materials are developed in a way that even fresher can learn the course on his own. Best Oracle DBA Online Training classes will be delivered by Oracle DBA working professionals who have more than 10+ years of industry working experience.

All our trainers will train you all the essentials you needed to kick start your career. Our training makes you expert with Oracle DBA Training. All our training classes will be delivered with hands on experience. We provide flexible batch timings, students can pick their own schedule according to their availability. We offer free demo sessions to students to asses trainer knowledge and then join course. We offer excellent course materials and also share real time use cases and projects which are very helpful to learners to start their career in corporate environment. We share recording of all sessions so to view and review them later. The sessions delivered by experts to make learners easier to learn.

BASIC UNIX COMMANDS:

Getting started to UNIX:

  • Different versions and flavours of Unix operating system with their features
  • Comparison between windows & Unix

Unix Structures:

  • Operating system
  • File system
  • Unix directories files and inodes

Shell:

  • types of shell's in unix
  • features of shell

Basic Unix Commands:

  • Creation and Deletion of Files with different options
  • Working with Directories
  • Making/Deleting /Renaming of Directories
  • Copying Files & Directories
  • Special Directory Names

Listing of Files & Directories:

  • Searching of files & Directories using find command
  • Wild card characters
  • Investigation of the system
  • Files access permission'absolute/numeric method
  • Symbolic method (both at file level and directory level)

VI-Editor:

  • Introduction
  • Different modes in Vi(command mode, insert mode,escape mode)
  • Vi command reference

Linking Files:

  • Soft link
  • Hard link
  • Removing a link

Creating/Deleting of user accounts:

  • Contents of user account
  • Password Tips
  • Change Password

Types of Filters:

  • Simple Filters(more,less,head,tail,sort,paste,wc,tr,diff,cut,comm.)
  • Adv. Filters(sed,grep,find & awk)

Process scheduling:

  • System process
  • Killing the process
  • Background process
  • Foreground process

Communication Options(write,talk,mesg, wall & mall)

Other usefull commands

Evolution of RDBMS

DB Computing Architecture

Data Definition Language(DDL)

  • Create
  • Alter
  • Drop
  • Recreate
  • rename

Manipulating Data using DML:

  • Insert
  • Delete
  • Update
  • Merge

Transaction Control Language(TCL)

  • Commit
  • Rollback
  • Save point

Data Control Language(DCL):

  • Grant
  • Revoke

Writing basic SQL select statements:

  • Select all columns
  • Select specified columns
  • Columns alias names
  • Column concadination
  • Using wherer
  • Order by arc
  • Order by disc
  • Nulls first
  • Nulls last
  • Distinct clauses
  • Describing the SQL select capabilities

Operators

  • Arthematical Operators *,-,+,?
  • Logical AND, OR & NOT
  • Relational <,>,<2,>2,!

Special Operators:

  • IN
  • NOT IN
  • LIKE
  • BETWEEN
  • NOT BETWEEN
  • IS NILL
  • IS NOT NILL

FUNCTIONS

  • SINGLE ROW FUNCTION
  • Character
  • Numeric
  • Date
  • Data conversion
  • Multiple row function
  • Aggregative function

Special Function

Aggregating Data using Group Functions

  • Group by clauses
  • Having clauses
  • Cube
  • Rollup

Subqueries

  • Single-Row
  • Multiple-Row

Formatting output using

  • Sqlplus
  • Column format
  • Set command
  • Spool
  • Sqlplus commands(save, insert,append & change)

ORACLE 11g R2 DBA

Level – 1

ORACLE ARCHITECTURAL COMPONENTS:

DATABASE COMPONENTS:

  • Storage Device
  • Physical structure
  • Logical structure
  • Memory Structure
  • Program Global Area (PGA)
  • System Global Area (SGA)
  • SQL Statement Execution
  • User Session
  • Process Structure
  • Client Process
  • Oracle Server Process
  • Server Process
  • Background Process
  • Understanding about Database instance

INSTALLATION OF ORACLE 11G:

  • HARDWARE REQUIREMENTS FOR INSTALLATION
  • INSTALLATION OF Oracle 11g on REDHAT LINUX MACHINE

ORACLE 11g ARCHITECTURE:

  • Understanding about Oracle database components with Update Statements
  • Understanding about all Background process while updating a transaction
  • Log Switch Mechanism

CREATING A DATABASE:

  • Creating a command line Database with pfile
  • Creating a DBCA database with spfile
  • Creation of OMF Database
  • Creation of ASM Database

MANAGING PFILE & SPFILE:

  • Understanding and Modification of PFILE (INIT.ORA)
  • Creating & Managing pfile & SPfile
  • Difference & adv. Of Pfile & SPFile
  • Creation of spfile from pfile

DATABASE STARTUP & SHUTDOWN PROCEDURES:

  • STARTUP Nomount, Mount, Mount Restrict Open, Force, Upgrade & Migrade
  • Shutdown Normal immediate, Transactional and Abort

DATA DICTIONARY STATIC & DYNAMIC TABLES / VIEWS (VS & DBA)

UNDERSTANDING & MANAGING TABLESPACE AND DATAFILES:

  • Types of tablespaces
  • Permanent, Temporary & Undo
  • Create, Alter and Drop tablespace
  • Offline and Online tablespace
  • Read write & Read only mode Tablespace
  • Resizing a Datafile Manually
  • Adding a Datafile in to the existing Tablespace
  • Deleting a Datafile
  • Creation of Bigfile Tablespace & Default Tablepsace
  • How to move a datafile
  • How to Renaming a Datafile & Tablepsace
  • How to reuse a datafile drop a tablespace
  • Managing Autoextend ON and OFF

STORAGE MANAGEMENT:

  • Types of Tables
  • Dictionary Managed
  • Locally Managed (Autoallocate, Uniform)
  • Segment Management
  • Extent Management

MANAGING SYSAUX TABLESPACE

CREATION OF TEMPORARY TABLESPACES & GROUPS

MANAGING DATABASE USERS WITH PRIVLEGES & ROLES:

  • Creating a new user
  • Alter and drop existing database users
  • Obtaining user information'
  • Lock and unlock user accounts
  • System privileges
  • Granting system privileges
  • Revoking system privileges
  • Object privileges advantages of Roles
  • Creating the roles
  • Assigning Roles to users
  • Establishing Default Roles
  • Removing Roles from users

MANAGING ONLINE REDOLOG FILES AND ARCHIVE MODE:

  • Creation of lof members and groups
  • Dropping log members and groups
  • How to switch log sequence manually
  • Purpose of checkpoints

ARCHIVE LOG MANAGEMENT:

  • Changing the database from no archive mode to archive mode
  • Config. Of multiple archive destinations
  • Archive files format & destinations multiple archive process

MANAGING CONTROL FILES:

  • Control files contents
  • Multiplexing the control files by using PFILE (INIT.ora)

MANAGING UNDO SEGEMENTS & TABLESPACE:

  • Creating and maintaining Rollback
  • Segemnets & undo segments (online & offline)
  • Types of undo segments
  • a)system b) Non-system
  • Automatic undo management
  • Understanding Retetion time policy
  • Undo tablespace with Guarantee and Non guarantee
  • Deferred roleback segment & pending offline undo segment

FLASHBACK TECHNOLOGIES :

Flashback Query:

  • We can recover lost records which done by DML statement But not DDL

Flashback version query:

  • Flashback versions Query providesa way to audit the rows of a table & retrieve information about the transactions that changed the rows
  • Flashback Transaction Query:

  • The flashback Transaction Query is a diagnostic tool to view the changes made to the database at the transaction level.
  • Flashback Recyclebin:

  • A table can recover from recyclebin
  • Flashback Database:

  • This feature useful to recover droped along with tables & records from flashback directory
  • BACKUP AND RECOVERY

    PHYSICAL BACKUPS:

    • Online,offline, hot & cold backups
    • Backups, Restore and Recovery scenario's with complete, incomplete, instance and media recovery
    • Before you create an oracle database,decide how to protect the database,against potential media failures
    • If you do not develop a backup strategy before creating your database, then you may not be able to perform recovery if a disk failure
    • damages the datafiles, online redo log

    files, or control files

    • A database can become unusable because of hardware or software failures or both.
    • You may at one time or another, encounter storage problems, power interruptions or applications failures
    • Each failures scenario requires a different recovery action
    • Protect your data against the possibility of loss by having well recovery strategies.

    CASE STUDIES:

    • Recovery loss of non system data file
    • Recovery loss of system data file
    • Recovery loss of undo datafile
    • Recovery loss of online redlog files
    • Recovery loss of control files by using backup control files
    • Recovery loss of datafile without having backup
    • Recovery damaged database while online backup

    LOGICAL BACKUPS"

    Traditional Backups

    • Full database level
    • User level
    • Table level
    • Incremental, cumulative & complete backups by using exp & imp tools

    ORACLE DATA PUMP:

    • Introduction to data pump
    • Advantages of data pump
    • Logical backups using expdp & impdp tools

    TRANSPORTABLE TABLESPACES:

    • Moving a tablespace from one database instance to another database instance
    • CONFIG.OF ORACLE NET PROTOCOL FOR CLIENTS/SERVER & DISTRIBUTED DATABASE ENVIRONMENT:

    • Simple network
    • Configuration oracle net protocol
    • Configuration of TNSNAMES.ORA at clent machine by using NETCA Tool
    • Configuration of LISTENER.ORA at server by using NETCA Tool

    CONFIGURATION OF ORACLE 11g SITE REPLICATION:

    • Complex network
    • Creation of database links & materialzed views for distributed databases

    CONFIG. OF DISPATCHERS & SHARED SERVER PROCESS (MTS):

    CONFIGURATION OF RMAN :

    • Configuration of RMAN Tool for remote backups
    • Maintaining the database backups using commands and scripts
    • Recovery loss of datafiles, Redolog files and control files by using RMAN
    • Repository, channels allocation, complete & incomplete recovery
    • Compressed backups, incremental backups with block change tracking

    ADV.RMAN ENHANCEMENTS:

    • Understanding & cinfigutayion of virtual private catalogs
    • Data recovery advisor
    • Listing the failures
    • Determining repair options
    • Repairing failures
    • Block level recovery
    • Parallel backup of same datafiles
    • Duplicate DB or DB Refresh(cloning)

    CLOINING DATABASE:

    • In every oracle development and production environment there is a nedd to transport the entire database from one physical machine to another. This copy may be used for production testing etc.,

    ACTIVE STANDBY DATA GARD:

    • Providing high data availability and maximum security and performance
    • Configuration of Fail over and switch over mechanisms
    • Oracle active data guard enables read-only access to a physical standby database for queries, sorting,reporting and web-based access.
    • Understanding & config. Of snapshot standby

    DATABASE PERFORMANCE & ADV. PERFORMANCE TUNNING

    OVERVIEW OF TUNNING:

    • O/S level tuning & Database level tuning
    • Buffer (PGA & SGA Components)
    • Application Tunning

    TUNNING ORACLE MEMORIES:

    • When to tune memories & how to tune?
    • Tuning P.G.A & S.G.A components
    • Database buffer b)log buffer
    • shared pool size
    • Dynamics SGA & Enable Oracles

    Paralle Querey Option

    • Config. Of multiple DB writers
    • TUNING MEMORY_TARGET
    • MEMORY_MAX_TARGET
    • DB_CACHE_SIZE
    • SHARE_POOL_SIZE
    • LOG_BUFFER
    • PGA BUFFER

    ROW CHANGING & MIGRATION:

    • How to identify and avoid row migration & row chaining
    • Migrated rows affect OLTP systems
    • Enabling TIMED_STATISTICS parameters

    PARTITIONING TABLES:

    • Introduction to Partitioning
    • Partitioning methods

    OPTIMIZATION MODES AND STATISTICS & EXPLAIN PLAN:

    • Optimization methods (RBO & CBO)
    • Advantages of CBO
    • Why statistics required?
    • How to find stats are available or not?
    • Gathering table, column, schema, index & system STATS

    SEGMENT TUNING:

    • How to find out segment fragmentation & how to resolve
    • Table caching, Table Reorg, Index Reorg.(index Rebuild)

    CONFIGURATION OF ORACLE TRACCING:

    • Trace the user session using TKPROF

    HOW TO USE OPTIMIZER HINTS EFFICIENTLY:

    • What is hint? How it improves query performance
    • ALL_ROWS B)FIRST_ROWS C)CHOOSE D)RULE E)FULL F)INDEX G)NOPARALLEL H)PARALLEL I)APPEND

    REPORTS:

  • HOW TO CONFIGURE STATSPACK, AWR,ASH,ADDM,ASMM
  • HOW TO READ & ANYLYZE THE PROBLEMS
  • APPLICATION TUNNING:

    Indexing:

    • What is an index & types of indexes?
    • Purpose of indexing
    • How to measure index selectivity
    • Btree
    • Bitmap
    • Composite
    • How to create index
    • Why to create index
    • Which column are suitable for indexing?

    Enhancements & Additional Features of 11g & 12c

    • Table can be converted as read only
    • Transportable tablespace for single partition
    • Flashback data archive
    • Performance tuning results cache
    • Oracle patch installation
    • Config. Of ASM database with GRID
    • Database Migration
    • Database upgradation from 10g to 11g
    • Dataguard snapshot standby
    • RMAN Enhancements
    • Online migration of an active data file
    • Invisible coloumn
    • Multiple indexes on the same coloumn
    • DDL Logging
    • Temporary undo in-and-outs
    • New backup user privlegs
    • How to execute SQL Statements in RMAN
    • Restricting PGA size
    • How to create CDB
    • How to Create PDB

    MISCELLANEOUS TOPICS

    • SQL LOADER
    • MULTIPLE BLOCK SIZE
    • AT TABLESPACE LEVEL
    • RESIZING ONLINEIREDOLOG FILES
    • RENAME THE DATABASE
    • HOW TO DROP A DATABASE FROM SQL PROMPT
    • MONITORING DATABASE ACTIVITIES
    • HOW TO CRETAE CONTROL FILES
    • BY USING TRACE FILES
    • CREATION OF USER PROFILES
    • ORACLE MANAGED FILES (OMF)
    • DESCRIBING BACKGROUND PROCESS
    • DATABASE AUDTING

    Reviews

    5
    60% Complete
    60% Complete
    60% Complete
    60% Complete
    60% Complete

    Manasa
    I have completed Oracle DBA course from SV Tech Hub and I am happy to say it is best for Oracle DBA Course. My sincere thanks to trainer. If you are thinking to learn Oracle DBA then I would recommend SV Tech Hub.

    Vishnu
    I took Oracle DBA course from SV Tech Hub. Experienced trainer, provided all class recordings and explained all concepts in easy manner. I have to say one thing this is best platform to learn. Kudos to whole team.

    Sonali
    I am happy to join Oracle DBA course from SV Tech Hub, Mr. Srinivas provided all information about Oracle certification. Thanks to him. I can say it is best place for beginners and advanced experienced ones. Trainer is knowledgeable and he always ready to provide 24x7 assistance.