[Show all top banners]

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 60 days
Recommended Popular Threads Controvertial Threads
What stocks to buy -- Any recommendation
Conservative discussions
What are your first memories of when Nepal Television Began?
When the news is bought for by vaccine corporations
तोर्पे लाई मडर्न बनाउने केही उपाय हरु
How to deal with anxiety
'Plan C' amnesty push for millions of illegal immigrants in Democrat reconciliation bill
Premier League Discussions
ढुककुर बढाउने घरेलु उपाए ...
भाते मुखियाबा
Diwali is here. Rangoli Ideas. Please let us know which one do you like ?
YouTube question ❔
King Mahendra's Alaska Visit
जेरी हैन जलेबी भन्नुस
5 questions to ask your friends who plan to get the Covid vaccine
TPS Holder with travel document
काखी मा घुँडो
What's up with US embassy Nepal Kathmandu?
मेरो ढुक्कुर सानो छ :(
उरन्ठ्यौला बोकाहरुको नाङो नाच
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