www.oracletrainings.com
Oracle DBA Training
AT
Oracle Trainings
Email : [email protected] Contact : +91 8121 020 111
www.oracletrainings.com
Oracle DBA Training Course Content
Oracle Database Administration
•Relational Databases (RDBMS): Introduction
•What is SQL?
•Roles and Responsibilities of DBA
•Oracle_Architecture
•Process_ Architecture
•Physical & Logical structures of Database
•Types of files(Control file, REDO LOG FILE & Data file)
•Various types of Data files
•Instance
•SYSTEM GLOBAL AREA & Background Process
www.oracletrainings.com
Database Creation
•Using Of Oracle Universal Installer
•Installation_Prerequisites
•Setting Up Of Environment Variables
•Installing the Oracle Database Software: Steps
•Using the Database Configuration Assistant
•Different types of Start up Modes
•Different types of Shutdown Modes
•Different Types of Database Creation
•Introduction to Table_space
•Types of Table_space
www.oracletrainings.com
Configuring the Oracle Network Environment
•Tools for Configuring & Managing the Oracle Network
•Using the Listener Control_Utility
•Connecting to Oracle Database
•Oracle Net: Naming_Methods
•Using Oracle Net Manager to Configure Local Naming
•Tnsnames.ora
•Network default location
•Introduction to Database Links
www.oracletrainings.com
Managing the Oracle Instance
•Oracle_Instance Management
•Oracle-Processes
•Oracle_Memory Structures
•Starting the Instance & Opening the Database
•Shutting Down the Oracle Database Instance
•Viewing & Modifying Initialization Parameters
•Managing The Memory Components
•Viewing Alert Log
Storage Parameters
•Oracle Database_Structures
•Exploring the Storage Structure of an Oracle Database
•What are segments?
www.oracletrainings.com
•What are extents?
•What is Blocks?
•Dictionary Managed Table_space
•Locally Managed Table_space
•Storage Parameters like Initial, Next, Min Extents, Pctincrease
•Managing the Undo Data
User Management
•Who are Database Users?
•Why to create a User?
•Creation of the Users
•Assigning Privileges
•Creating & granting Roles
•Assigning default table space for the Users
•Setting Up Profiles for the Users
•Levels of Authentication
www.oracletrainings.com
SPFile and PFile Managment
•What is spfile?
•Differentiation between spfile & pfile
•Advantages of the spfile
Redo-Log & Control File Management
•Introduction to Redo log
•Status of Redo logs
•Multiplexing the Redo log files
•Introduction to Multiplexing the Control file
Logical Backup &Restore
•What is an logical backup
•Why it is required
•Export & import Utility
•Data Pump
•Difference b/w Data Pump &Traditional Export/import
www.oracletrainings.com
Managing Oracle Database & Software
•Managing the Oracle database –proactive checks
•Understanding The Software Management & Patch Releases
•Patching The Oracle Database Software
•Using the Database Upgrade Assistant to Upgrade the Database
Creating backups with RMAN
•Types Of RMAN backup
•Creating & Using the RMAN backups
•RMAN restore & recovery process
RMAN – Duplicating a Database
•Purpose & Methods of Cloning a Database
•Using RMAN to Create an Duplicate Database
www.oracletrainings.com
Performance Management
•Performance_Monitoring
•Managing The Memory Components
•Invalid & Unusable Objects
•Automatic Workload Repository Baselines
•V$ Views, Statistics and Metrics
Working with Oracle Support
•Use the Enterprise Manager Support Workbench
•Work with Oracle Support
•Log service requests
•Manage patches
www.oracletrainings.com
Mvoing Data , Data Migrations
•Describing ways to move data
•General_Architecture
•Use Data Pump export & import to move data
•Tools for data migrate
I
ntroduction to ASM & RAC
•Introduction to Oracle ASM.
About Oracle RAC
•Miscellaneous
•Database Best Practices and Scripts
•Oracle features
www.oracletrainings.com
Please Like Us On
Facebook : https://www.facebook.com/oracleonlinetraining
LinkedIn : https://www.linkedin.com/in/oracletrainings
Twitter : https://twitter.com/oracletrainigs
www.oracletrainings.com