ORACLE DBA

    • Online Oracle 11g DBA Training
    • About ORACLE DBA
    • 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
  • HOW TO USE SAS MACROS IN SQL
    • How dictionary table and views can simplify programming SQL options
    • How to retrieve Raw data different from DATABASES to SAS environment using SQL 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
  • FLASHBACK FEATURES
    • Flashback Database
    • Flashback Archive(11g)
  • MISCELLANEOUS
    • Oracle 11g Installations
    • Comparison between Oracle 10g and Oracle 11g
    • New features Introduced in Oracle 10g
    • Upgradation from Oracle 10g to Oracle11g
    • More about Oracle 11g DBA Online Training :
    • About  Oracle 11g DBA Trainer :
    • Oracle 11g DBA Online Training batch information: