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

Page 1

ORACLEDBA ONLINE TRAINING


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


DATABASE CREATION  Startup Modes  Shutdown Modes  Database Creation Types  Manual Method of Creation


TABLESPACE MANAGEMENT  Table space Introduction  Table space Types (BIG & SMALL)  Temporary Table space  Altering/Renaming a Table space  Renaming a Data file  Temporary Groups  Table space Encryption(11g)



STORAGE PARAMETERS  Segments Introduction  Extents Introduction  Blocks Introduction  Oracle Blocks  Dictionary Managed Table space  Locally Managed Table space  Storage Parameters


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



UNDO MANAGEMENT  Undo Introduction  offline status Pending  Rollback segments  Features of Flashback  Flashback Table  Flashback query  Flashback Version query


CONTACT: INDIA:8121311133 http://www.ithubonlinetraining.com/oracle-dba-online-training/ CONTACT@ITHUBONLINETRAINING


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.