Oracle DBA online training at MindMajix - Hyderabad

Introduction.
Types of Databases.
Duties of a DBA, Classifications of DBA.
Oracle Versioning and versions history.
Grid ? Advantages of Grid Computing.
What is Instance? What is Database? What is Database Server?
Users the DBA interacts with.
Supported OS.
Introduction to Linux OS.
Linux File Layout structure.
Installation of Linux OS.
OS Users.
Installation process.
Disk layout.
Different mount points used by oracle.
Swap Area.
Creation of User groups.
Oracle needed file layout.
Installation of Oracle Software
Fulfilling prerequisites for installation.
Setting up environment.
Installation.
Post Installation scripts.
Changes done to the OS files after installation is complete.
etc directory, /home/oracle directory, global inventory, oracle home.
Database Creation
Database files introduction.
Tablespaces and Schemas.
Control files introduction.
PFile Introduction, Creation and default parameters(10g/11g).
Instance States.
Database Creation Manually and Using DBCA.
Background processes and Different stages of Database.
Instance Start, Mount and Open states.
Dynamic views related to database.
Oracle memory layout.
Background processes.
Instance states more detailed.
How to look for background processes.
Database objects and Tablespaces.
Introducing putty and VNC server(How it works in realtime environment).
Sys owned objects.
Data Dictionary.
User Created objects.
Sys Tablespaces.
User Tablespaces.
Dictionary Managed Tablespace, Locally managed tablespace.
Bigfile tablespace.
Managing tablespaces.
Managing datafiles.
Datafiles layout, Internal organization.
Tables and Fragmentation.
Threads and Redo log groups
Archive log, No Archive log.
Threads and Groups concepts.
Multiplexing Redo logs.
Log switching.
Different stages of Log files.
Processes related to online Redo logs.
Adding Threads, Groups.
Dropping Threads, Groups.