ORACLEDBA ONLINE TRAINING
Overview of Oracle Database Administration What is SQL? Roles & Responsibilities of DBA Oracle Architecture Process Architecture Physical and Logical structures of Database Types of files(Control file,Data file) Different types of Data files
Database Creation Using Oracle Universal Installer Installation Prerequisites Setting Environment Variables Installing the Oracle Database Software: Steps Using the Database Configuration Assistant (DBCA) Different Startup Modes Different Shutdown Modes Types of Database Creation
Configuring the Oracle Network Environment Tools for Configuring and Managing the Oracle Network Using the Listener Control Utility Connecting to an Oracle Database Oracle Net: Naming Methods Using Oracle Net Manager to Configure Local Naming Tnsnames.ora Network default location Introduction to Database Links
Managing the Oracle Instance Oracle Instance Management Oracle Processes Oracle Memory Structures Starting the Instance and Opening the Database Shutting Down an Oracle Database Instance Viewing and Modifying Initialization Parameters Managing Memory Components Viewing the Alert Log
Storage Parameters Oracle Database Structures Exploring the Storage Structure of the Oracle Database What are segments? What are extents? What is Blocks? Dictionary Managed Table space Locally Managed Table space Storage Parameters(Initial, Next, Min Extents, Pctincrease) Managing Undo Data
SPFile & PFile Managment What is sp file? Difference between sp file and p file Advantages of sp file
CONTACT: INDIA:8121311133 http://www.ithubonlinetraining.com/oracle-dba-online-training/ CONTACT@ITHUBONLINETRAINING