Oracle Dba Online Training

[oracledbatraining]

We are giving [b]Oracle DBA [/b]online training by real time experts.
If anybody insterested please send a mail us to attend for the demo.

[size=5][b][size=4]E-Mail [/size] : [color=#3366FF][email protected][/color][/b][/size]

[u][b]Syllabus:[/b][/u]
[color=#800000][b]INTRODUCTION TO ORACLE DBA[/b][/color]
• 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
[color=#800000][b]DATABASE CREATION[/b][/color]
• Different Startup Modes
• Different Shutdown Modes
• Types of Database Creation
• Manual Method of Creation
[color=#800000][b]TABLESPACE MANAGEMENT[/b][/color]
• 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)
[b][color=#800000]STORAGE PARAMETERS[/color][/b]
• 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)
[b][color=#800000]USER MANAGEMENT[/color][/b]
• 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)
[b][color=#800000]UNDO MANAGEMENT[/color][/b]
• What is Undo?
• Why Undo required?
• Pending offline status
• Brief idea about Rollback segments
• Flashback Features
• Flashback Table
• Flashback query
• Flashback Version query
[b][color=#800000]SPFILE & OMF[/color][/b]
• What is spfile?
• Difference between spfile and pfile
• Advantages of spfile
• What is OMF?
• Advantages of OMF
• Files conventions of OMF
[b][color=#800000]NETWORKING IN ORACLE[/color][/b]
• Introduction to Oracle Networking
• Network default location
• Editing Network file
o Listener.ora
o Tnsnames.ora
• Introduction to Database Links
• Types of Database Links
• Introduction to Materialized views
• Advantages of Materialized view
• Refresh Modes
[b][color=#800000]REDO-LOG & CONTROLFILE MANAGEMENT[/color][/b]
• 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
[b][color=#800000]LOGICAL BACKUP[/color][/b]
• 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
[b][color=#800000]PHYSICAL BACKUP[/color][/b]
• Introduction to Physical backup
• Types of Physical backup
• Cold & Hot backup
• Recovery scenarios
• RMAN backup
• RMAN Point in time recovery
• RMAN 11g new features
[b][color=#800000]PEFORMANCE TUNING[/color][/b]
• 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
[b][color=#800000]AVAILABILITY[/color][/b]
• 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)
[b][color=#800000]ADVANCED SQL Topics[/color][/b]
• 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
[b][color=#800000]SQL-LOADER[/color][/b]
• Introduction to SQL Loader
• Types of files
• Control file
• Infile
• Bad file
• Discard file
• Data file
[b][color=#800000]AUDITING[/color][/b]
• What is auditing?
• Why auditing performed?
• Types of Auditing
• Levels of Auditing
[b][color=#800000]FLASHBACK FEATURES[/color][/b]
• Flashback Database
• Flashback Archive(11g)
[color=#800000][b]MISCELLANEOUS[/b][/color]
• Oracle 11g Installations
• Comparison between Oracle 10g and Oracle 11g
• New features Introduced in Oracle 10g
• Upgradation from Oracle 10g to Oracle11g

[oracledbatraining]

[b][size=4]E-Mail [/size] : [color=#3366FF][email protected][/color][/b]