Oracle DBA 11g Administration

You learn the skills and knowledge to install, configure, and maintain the database. Once you learn the essentials of administering a database, you can develop advanced knowledge in any of the focus areas.Oracle Database 11g makes database infrastructure far more efficient, resilient, and manageable.

INTRODUCTION TO ORACLE DBA
    1.What is DBA ?
    • 2.Why a Company needs a DBA?
    • 3.Roles & Responsibilities of DBA
    • 4.Oracle Architecture
    • 5.Physical and Logical Phase of Database
    • 6.Types of files(Control file, Redolog file and Datafile)
    • 7.Different types of Datafiles
    • 8.Instance
    • 9.SGA(System Global Area) and Background Process

DATABASE CREATION
    1.Different Startup Modes
    • 2.Different Shutdown Modes
    • 3.Types of Database Creation
    • 4.Manual Method of Creation

TABLESPACE MANAGEMENT
    1.Introduction to Table space
    • 2.Types of Table space(BIG & SMALL)
    • 3.Temporary Table space
    • 4.Altering/Renaming a Table space
    • 5.Renaming a data file
    • 6.Temporary Groups
    • 7.Table space Encryption(11g)

STORAGE PARAMETERS
    1.What are segments?
    • 2.What are extents?
    • 3.What is Blocks?
    • 4.Oracle Blocks
    • 5.Estimation of Extents
    • 6.Dictionary Managed Table space
    • 7.Locally Managed Table space
    • 8.Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT
    1.Who are Database Users?
    • 2.Why to create a User?
    • 3.Creation of Users
    • 4.Assigning Privileges
    • 5.Creating and granting Roles
    • 6.Allocating table space Quotas to Users
    • 7.Assigning default table space for the Users
    • 8.Setting Profiles for the Users
    • 9.Levels of Authentication
    • 10.Schema Management(11g)
    • 11.Security(11g)

UNDO MANAGEMENT
    1.What is Undo?
    • 2.Why Undo required?
    • 3.Pending offline status
    • 4.Brief idea about Rollback segments
    • 5.Flashback Features
    • 6.Flashback Table
    • 7.Flashback query
    • 8.Flashback Version query

SPFILE & OMF
    1.What is spfile?
    2.Difference between spfile and pfile
    • 3.Advantages of spfile
    • 4.What is OMF?
    • 5.Advantages of OMF
    • 6.Files conventions of OMF

NETWORKING IN ORACLE
    1.Introduction to Oracle Networking
    • 2.Network default location
    • 3.Editing Network file
    4.Listener.ora
    5.Tnsnames.ora
    1.Introduction to Database Links
    • 2.Types of Database Links
    • 3.Introduction to Materialized views
    • 4.Advantages of Materialized view
    • 5.Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT
    1.Introduction to Redo log
    • 2.Status of Redo logs
    • 3.Multiplexing the Redo log files
    • 4.Re-creation of Control file
    • 5.Renaming the Database
    • 6.Multiplexing the Control file

LOGICAL BACKUP
    1.What is a logical backup
    • 2.Why it is required
    • 3.Export/import Utility
    • 4.Data Pump
    • 5.Difference between Data Pump and Traditional Export/import
    • 6.Impdp/expdp
    • 7.Transportable Table spaces

PHYSICAL BACKUP
    1.Introduction to Physical backup
    • 2.Types of Physical backup
    • 3.Cold & Hot backup
    • 4.Recovery scenarios
    • 5.RMAN backup
    • 6.RMAN Point in time recovery
    • 7.RMAN 11g new features

PEFORMANCE TUNING
    1.What is Performance Tuning?
    • 2.Why Tuning required?
    • 3.Types of Tuning
    • 4.Database Tuning
    • 5.Tuning
    • 6.SQL Tuning
    • 7.Memory Tuning
    • 8.Network Tuning
    • 9.Partitioning and Indexes
    • 10.Partitioning Enhancements
    • 11.AWR/ASH/ASMM/ADDM
    • 12.RAT(Real Application Testing)(11g)
    • 13.SQL Performance Analyses (11g)
    • 14.Row chaining and Row migration
    • 15.Resemble Table spaces

AVAILABILITY
    1.Introduction to Data Guard
    • 2.Types of Standby databases
    • 3.11g New features in Data Guard
    • 4.Types of Protection modes
    • 5.Active standby/snapshot standby(11g)
    • 6.Log Miner
    • 7.RMAN Point in time Recovery
    • 8.Introduction to Database Cloning
    • 9.RMAN Cloning
    • 10.Automatic Storage Management(ASM)

ADVANCED SQL Topics
HOW TO USE SAS MACROS IN SQL
    1.How dictionary table and views can simplify programming SQL options
    • 2.How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements
    • 3.To create table in different databases using SAS sql statement
    • 4.To manage in different databases using SAS Sql Statements

SQL-LOADER
    1.Introduction to SQL Loader
    • 2.Types of files
    • 3.Control file
    • 4.Infile
    • 5.Bad file
    • 6.Discard file
    • 7.Data file

AUDITING
    1.What is auditing?
    • 2.Why auditing performed?
    • 3.Types of Auditing
    • 4.Levels of Auditing

FLASHBACK FEATURES
    1.Flashback Database
    • 2.Flashback Archive(11g)

MISCELLANEOUS
    1.Oracle 11g Installations
    • 2.Comparison between Oracle 10g and Oracle 11g
    • 3.New features Introduced in Oracle 10g
    • 4.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