Best oracle DBA online training in india | oracle DBA online training in singapore

1
ORACLEDBA ONLINE TRAINING
2
ORACLE DBA INTRODUCTION

• DBA Introduction
• Responsibilities of DBA
• Oracle Architecture Overview
• Physical and Logical Phase of Database
• Types of files(Control file, Redolog file and
  Datafile)
• Datafiles Types
• Instance
• SGA(System Global Area) and Background Process

3
DATABASE CREATION

• Startup Modes
• Shutdown Modes
• Database Creation Types
• Manual Method of Creation

4
TABLESPACE MANAGEMENT

• Table space Introduction
• Table space Types (BIG amp SMALL)
• Temporary Table space
• Altering/Renaming a Table space
• Renaming a Data file
• Temporary Groups
• Table space Encryption(11g)

5
(No Transcript)
6
STORAGE PARAMETERS

• Segments Introduction
• Extents Introduction
• Blocks Introduction
• Oracle Blocks
• Dictionary Managed Table space
• Locally Managed Table space
• Storage Parameters

7
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

8
(No Transcript)
9
UNDO MANAGEMENT

• Undo Introduction
• offline status Pending
• Rollback segments
• Features of Flashback
• Flashback Table
• Flashback query
• Flashback Version query

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