Oracle 11g DBA Online training | Oracle 11g DBA Tutorial in USA,UK, Canada, Australia, Malaysia, Singapore.

1
Oracle DBA Online Training

• By
• HYDERABADSYS ONLINE 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 HYDERABADSYS ONLINE TRAINING
Hyderabadsys is one of the leading IT Online
Coaching in Hyderabad, India. We do not only
believe in training our trainees We believe in
real time knowledge and experience so that
students can land up job easily at the completion
of the course.     Hyderabadsys trains over 2000
students per every year in various IT
Technologies. Our Hyderabadsys headquarters in
Hyderabad, We provides 247 technical support ,
project support and job support by certified
Faculty.We have the best faculties who are highly
proficient skilled professionals in market and
also certified in their subjects and have gained
expertise with years of experience in software
training.
7
About us

• Hyderabadsys Online Training Institute ensuring
  accomplished carrier in IT Industry. We offer
  real time specialists with a successful track
  record in their field of expertise. Hyderabadsys
  introduced online training to reach worldwide
  students who wants to build their carrier by
  learning new technologies.
• We specialized in providing best quality online
  services on java, dotnet, data warehousing,
  oracle and sap modules and Hadoop Online
  Tutorials. Also, we provide project support to
  all IT Technologies. Learning online gives you
  the flexibility to set your study in free hours
  and save money on travel and accommodation. We
  offer 247 technical support and job support to
  the trainees even after the completion of course.

8
 
INDIA 91 9030400777 USA 1-347-606-2716 contac
t_at_Hyderabadsys.com