Oracle database admin course content traning at learning hub - 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