[Show all top banners]

rea
Replies to this thread:

More by rea
What people are reading
Subscribers
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 Oracle DBA online training available
[VIEWED 5644 TIMES]
SAVE! for ease of future access.
Posted on 12-01-14 11:08 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

One of my colleague at work, who is also a very talented senior DBA, is looking to start an online class for people interested in Oracle database administration. He is basically looking to help out those who have recently started their first projects and need to brush up on DBA skills quickly. He is also willing to provide support during their project if needed.
Those who are interested can inbox me and I will provide the contact info of the instructor (This is an individual effort and not through any agency or consultancy). Below are some more details on the course format:

Basics:
1. Introduction to RDBMS.
2. Introduction to SQL (structured query language).
3. Data Defination language.
4. Data manipulation language.
5. Constraints.
6. Indexes.

Middle level:
1. Introduction to ORACLE DATABASE.
2. Internal Architecture of Oracle Database.
3. Memory Structure of Oracle Database.
4. Types of Database Files.
5. Types of Database parameters.
6. Introduction to Shutdown and Startup of database.
7. Introduction to logical storage of the database.(tablespaces,datafiles etc)
8. Database connectivity (Oracle Listeners)
9. Installation of Oracle Database
9. Logical backup of database (EXPDP) and EXPDP commands
10. Physical backup of databse (RMAN) and RMAN commands
11. Different types of databsae restore.
-> Logical Restore (using EXPDP)
-> Physical Restore
12. Introduction to Disaster Recovery and standby databases.

Advance Level:
1. Introduction to High Availabilty Architecture in ORACLE.
2. Internal RAC process and Introduction to VIP and Scan LISTENERS.
2. Introduction to Shared Storage in ORACLE (Automatic Storage Management).
3. Different Replication ways in ORACLE (Golden Gate).

Major Practical and Real Time Scenarios:
1. Installation of Database software and database creation.
2. Full database migration using EXPDP.
3. Database restore using RMAN.
4. Standby database creation and validating the switchover of the database.
5. setting up GOLDEN GATE replication.


 
Posted on 12-01-14 7:48 PM     [Snapshot: 113]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

HI Rea,
Good Evening,
I am very interested in ur training program. I have knowledge on the Oracle SQL When u r going to start ur training I want to join.
thank you
Dhanee

Last edited: 01-Dec-14 07:49 PM
Last edited: 01-Dec-14 08:24 PM

 
Posted on 12-02-14 8:43 AM     [Snapshot: 212]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Hi Rea,
I am also interested. I am Ms SQL DBA. I want to learn Oracle DBA. Please let us know when are you starting training? Thanks.
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 30 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
ढ्याउ गर्दा दसैँको खसी गनाउच
To Sajha admin
From Trump “I will revoke TPS, and deport them back to their country.”
wanna be ruled by stupid or an Idiot ?
How to Retrieve a Copy of Domestic Violence Complaint???
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters