Oracle 11g DBA online training | Oracle 11g DBA certification

1
Oracle DBA Online Training

• By
• SMARTMINDONLINE TRAINING

2
Oracle 11g DBA Online Training Course Content

• INTRODUCTION TO ORACLE DBA
• 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
• DATABASE CREATION
• Different Startup Modes
• Different Shutdown Modes
• Types of Database Creation
• Manual Method of Creation

3
Oracle 11g DBA Online Training Course Content

• TABLESPACE MANAGEMENT
• 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)
• STORAGE PARAMETERS
• What are segments?
• What are extents?
• What is Blocks?
• Oracle Blocks
• Estimation of Extents
• Dictionary Managed Table space

4
Oracle 11g DBA Online Training Course Content

• USER MANAGEMENT
• 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

5
Oracle 11g DBA Online Training Course Content

• REDO-LOG CONTROLFILE MANAGEMENT
• 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
• LOGICAL BACKUP
• 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

6
WHY US SMARTMIND ONLINE TRAINING Smart Mind
Online Training following a succeeding career in
IT sector.  Smart Mind Online is a global leading
IT Training provider. We specialized in providing
Online Training services on hadoop, java, oracle
and sap all modules. We teach students and train
them for IT profession. Also, we will provide job
support by  IT professionals for job. Smart
Mind Online Training offers Virtual room coaching
as a accomplished and efficient to site-based and
sophistication Online Training. Virtual class
room could be a web-based setting that enables
you to participate in live coaching events while
not the necessity to travel. Our Passion is to
teach every student in real time.
7
About us

• Smart Mind Online Training is one altogether the
  leading IT work Institutions, established in
  Hyderabad with the target of providing Training
  services for various requirements in IT business.
  We deliver company Trainings as per the scholar
  requirements colonize and ground breaker of
  worldwide e Learning solutions and providing
  technology enabled Online Training for
  individuals and company educators.
• We have extraordinarily talented faculty in
  their individual courses. we have a tendency to
  tend to furnish with Online work given North
  Yankee country a grip on varied Technologies. Our
  team trainers expertise in every part of the e
  Learning modules.

8
 
INDIA 91 9949599844 USA 1-347-606-2716 contac
t_at_smartmindonlinetraining.com