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

View by Category
About This Presentation
Title:

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

Description:

Oracle 11g DBA Online training certification bring forth the aspirants' amount of knowledge and skills to create and maintain databases, move and manipulate data, database backup & recovery, database surroundings that is prepare, etc. This is hence, can be looked at as truly one of the feasible and highly commendable Oracle certification in the industry. – PowerPoint PPT presentation

Number of Views:175

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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
About PowerShow.com