Replies to this thread:

More by rea
What people are reading
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 Oracle DBA online training available
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:

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

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.



Within last 365 days
Recommended Popular Threads Controvertial Threads
What stocks to buy -- Any recommendation
yo sajha bros, anyone got any update on TPS?
🙏 दलाल स्ट्रिट 🙏
हेरेको तिमीलाइ आँखाले हैन।
जोडि त भाग्यले जुराउँछ - हिरोइन स्वेताले यसरि दोश्रो पटक बिहे गर्न लागिन
Conservative discussions
ॐ श्री स्वस्थानी ब्रत कथा
U.S State Dept for Nepal - Level 4: Do Not Travel Nepal #TPS
Love Letters From The Past--SITARA
Ushering in new era of communism ...
मरिसकेको माओबादि र एमालेलाइ ब्युँताइदियो सर्बोच्चले
सुष्मा ले 'कामी' भनेपछि यस्तो बबाल भएछ
सबै अवलोकन बिन्दु संगै
What are your first memories of when Nepal Television Began?
Visit Reeyas Kitchen for Nepali Food Recipes
The Facebook Surprise
Nepali guards in Afghanistan
सेक्सी कविता - पार्ट २
sarai chada vaye keti haru
नेपाल र अफगानिस्थानको टि पि एस रिडेजिकनेसन साथसाथै हने कुरो छ
is Rato Bangala school cheating?
विद्या तेरो सिन्दूर खोइ, केपी ओली तेरो पोइ ..
NOTE: The opinions here represent the opinions of the individual posters, and not of It is not possible for to monitor all the postings, since merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to 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. is a service please don't abuse it. - Thanks. Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters