Sale Date Ended
Contact:learnchase@gmail.com
phone: 8123930940
Website: http://learnchase.com
Oracle 11g DBA Training Concepts :
INTRODUCTION TO 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
✔0.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
Contact:learnchase@gmail.com
phone: 8123930940
Website: http://learnchase.com
