- 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: