best oracle DBA online training | oracle DBA training Tutorial

1
ORACLEDBA ONLINE TRAINING
2
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

3
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

4
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

5
(No Transcript)
6
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

7
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

8
(No Transcript)
9
SPFile PFile Managment

• What is sp file?
• Difference between sp file and p file
• Advantages of sp file

10
CONTACTINDIA8121311133 http//www.ithubonlinetr
aining.com/oracle-dba-online-training/ CONTACT_at_ITH
UBONLINETRAINING