ORACLE DATABASE ADMIN COURSE CONTENT TRANING AT LEARNING HUB MAGARPATTA CITY /FC ROAD PUNE (+91 932 IN PUNE

ORACLE DATABASE ADMIN COURSE CONTENT
Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in

ORACLE DATABASE ADMIN COURSE CONTENT

1: Creating the Database

2: Starting Up and Shutting Down
• Viewing the Quiesce State of an Instance
• Suspending and Resuming a Database

3: Managing Oracle Database Processes
• Terminating Sessions
• Identifying Which Session to Terminate
• Terminating an Active Session
• Terminating an Inactive Session

4: Monitoring the Operation of Your Database
• Server-Generated Alerts
• Monitoring the Database Using Trace Files and the Alert Log
• Monitoring Locks
• Monitoring Wait Events
• Process and Session Views

5: Oracle Database Structure and Storage

• Managing Control Files
• Managing the Redo Log
• Managing Archived Redo Logs
6: Managing Table spaces
Transportable Table spaces

7: Managing Data files and Temp files

8: Managing the Undo Table space
undo retention, switching undo table space
9: User management
creation of users and roles, assign privileges
10:Automatic Storage Management
create ASM instance, create disk groups
11:Managing Schema Objects
• Tables, indexes, views, synonyms and sequence generator
• Space management
• Managing resumable space allocation, reclaiming wasted space
• Managing Tables
• adding, renaming and dropping of table columns
• Managing Indexes
• B*tree, bitmap
• Managing Partitioned Tables and Indexes
• Range, hash,list and composit partitioning
• Managing Clusters
• creation and altering of clusters
• Managing Views, Sequences, and Synonyms
• Oracle Network
• Listener and tnsnames
• Distributed Database Concepts
• Utilities
• Data pump , SQL*Loader
• Backup and Recovery
• Rman
• Performance Tuning
• Data Guard
• configuring physical standby database
• Miscellaneous

Please Contact-

Learning Hub,
S-12,Destination Centre,
2nd Floor, Above HDFC Bank,
Next to Noble Polyclinic,
MAGARPATTA CITY,
PUNE – 411013,
PH: +91- 93257-93756.
Skype id : learning.hub01
Email: learninghub01@gmail.com
www.learninghub.co.in
ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN Class Room Training, ORACLE DATABASE ADMIN Training in Magarpatta City, ORACLE DATABASE ADMIN Jobs and Placement, ORACLE DATABASE ADMIN Remote Support, ORACLE DATABASE ADMIN Online Help, ORACLE DATABASE ADMIN Videos training, ORACLE DATABASE ADMIN Training by Learning Hub, Fast track classes in ORACLE DATABASE ADMIN, Best ORACLE DATABASE ADMIN Training institutes in Pune, Best Faculty in ORACLE DATABASE ADMIN, Best online Faculty in ORACLE DATABASE ADMIN, Professional classroom training in ORACLE DATABASE ADMIN, Professional online training ORACLE DATABASE ADMIN, ORACLE DATABASE ADMIN Certification , ORACLE DATABASE ADMIN training in Dubai, ORACLE DATABASE ADMINTraining in Melbourne, ORACLE DATABASE ADMIN Training in Dubai, ORACLE DATABASE ADMIN Training, ORACLE DATABASE ADMIN Workflow Training ORACLE DATABASE ADMI Training, ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN certfication and support