Call Us at: +1616-469-0394 | Email: info@hexissoft.com

Follow Us on: facebook_icon twitter-icon linkdein_icon

COURSES

QUICK ENQUIRY











aboutus_banner

ORACLE DBA

ORACLE DBA ONLINE TRAINING 

 Introduction

 

  • What is DBA ?
  • Why a Company needs a DBA?
  • Roles & Responsibilities of DBA
  • Oracle Architecture
  • Physical and Logical Phase of Database
  • Types of files(Control file, Redolog file and Datafile)
  • Different types of Datafiles
  • Instance
  • SGA(System Global Area) and Background Process
  • DATABASE CREATION
  • Different Startup Modes
  • Different Shutdown Modes
  • Types of Database Creation
  • Manual Method of Creation
  • TABLESPACE MANAGEMENT
  • Introduction to Table space
  • Types of Table space(BIG & SMALL)
  • Temporary Table space
  • Altering/Renaming a Table space
  • Renaming a data file
  • Temporary Groups
  • Table space Encryption(11g)

STORAGE PARAMETERS

  • What are segments?
  • What are extents?
  • What is Blocks?
  • Oracle Blocks
  • Estimation of Extents
  • Dictionary Managed Table space
  • Locally Managed Table space
  • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT

  • Who are Database Users?
  • Why to create a User?
  • Creation of Users
  • Assigning Privileges
  • Creating and granting Roles
  • Allocating table space Quotas to Users
  • Assigning default table space for the Users
  • Setting Profiles for the Users
  • Levels of Authentication
  • Schema Management(11g)
  • Security(11g)

UNDO MANAGEMENT

  • What is Undo?
  • Why Undo required?
  • Pending offline status
  • Brief idea about Rollback segments
  • Flashback Features
  • Flashback Table
  • Flashback query
  • Flashback Version query

SPFILE & OMF

  • What is spfile?
  • Difference between spfile and pfile
  • Advantages of spfile
  • What is OMF?
  • Advantages of OMF
  • Files conventions of OMF
  • NETWORKING IN ORACLE
  • Introduction to Oracle Networking
  • Network default location
  • Editing Network file
  • Listener.ora
  • Tnsnames.ora
  • Introduction to Database Links
  • Types of Database Links
  • Introduction to Materialized views
  • Advantages of Materialized view
  • Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT

  • Introduction to Redo log
  • Status of Redo logs
  • Multiplexing the Redo log files
  • Re-creation of Control file
  • Renaming the Database
  • Multiplexing the Control file

LOGICAL BACKUP

  • What is a logical backup
  • Why it is required
  • Export/import Utility
  • Data Pump
  • Difference between Data Pump and Traditional Export/import
  • Impdp/expdp
  • Transportable Table spaces

PHYSICAL BACKUP

  • Introduction to Physical backup
  • Types of Physical backup
  • Cold & Hot backup
  • Recovery scenarios
  • RMAN backup
  • RMAN Point in time recovery
  • RMAN 11g new features

PEFORMANCE TUNING

  • What is Performance Tuning?
  • Why Tuning required?
  • Types of Tuning
  • Database Tuning
  • Tuning
  • SQL Tuning
  • Memory Tuning
  • Network Tuning
  • Partitioning and Indexes
  • Partitioning Enhancements
  • AWR/ASH/ASMM/ADDM
  • RAT(Real Application Testing)(11g)
  • SQL Performance Analyses (11g)
  • Row chaining and Row migration
  • Resemble Table spaces

AVAILABILITY

  • Introduction to Data Guard
  • Types of Standby databases
  • 11g New features in Data Guard
  • Types of Protection modes
  • Active standby/snapshot standby(11g)
  • Log Miner
  • RMAN Point in time Recovery
  • Introduction to Database Cloning
  • RMAN Cloning
  • Automatic Storage Management(ASM)
  • ADVANCED SQL Topics

Statements

  • To create table in different databases using SAS sql statement
  • To manage in different databases using SAS Sql Statements

SQL-LOADER

  • Introduction to SQL Loader
  • Types of files
  • Control file
  • Infile
  • Bad file
  • Discard file
  • Data file

AUDITING

  • What is auditing?
  • Why auditing performed?
  • Types of Auditing
  • Levels of Auditing

 

Back to Top…