[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
TRUMP 2016!!! Here is why?
कोमल ओलि र धिरेन्द्र बिचको अफेयर
Anyone renewed their passport through DC embassy lately?
बिहे गर्न अगाडी प्रियांकाले आफ्ना शुभेक्छुकहरुलाई यसरी आफ्नो पोल्ने धुंवादार शरीर (smoking hot body) देखाईन
अमेरिकामा नेपालीलाई दुःख छ, सकभर नजानुस
How to Apply for International Drivers Permit in Nepal?
पुन्टर पिन्कु र नाज ब्रो
आफू सवारी गाडि चालक साथीले रक्सी सेवन गरी महिलाको ज्यान गएको बारे नायिका पारमिता राज्य लक्ष्मी राणाले मुख खोलिन
US upcoming recession --- is it good time to buy house when rates are low or is it good time to wait recession?
Advance parole reason
अनभिज्ञ तिमी
थुतुनो र मुतुनो ठिक ठाउँमा भएन भने life damage !!!
रामकृष्णको बिचल्ली, ८ करोडको ऋण अनि divorce
is it good to marry girl who are already in US or go back to Nepal and do arrange marriage?
नेपाली समुदायको भारी समर्थन Iowa caucus मा Bernie Sanders लाई - PHOTOS
अब नसुध्रि शुख - आस्था राउतले डण्ठे भन्दै गालि नगरेको भए कसैले सुन्थेन ....
पिउनको सम्पत्ति ९ करोड ७३ लाख
Question on getting advance parole for tps holder.
काइदाका फाइदा .. .. प्रचण्डलाइ
Presidential rights to assassination rights?
TRUMP 2016!!! Here is why?
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