I am guy who just graduated with a MS degree. I want to practice Oracle DBA tasks on my personal computer. I have Oracle on Linux installed. Can you tell me in detail what tasks I can do on my personal computer? There are not a lot of companies who want to hire a junior DBA. I guess I am of the view that I will practice whatever I can.
The answer is you can do anything and everything! The only restrictions you have are based on the version of Oracle you installed (Personal, Standard or Enterprise).
I think what you're really asking is what to do to learn more about Oracle. For this, I'd suggest reading some of the Oracle documentation (you can find the entire set of product documentation at technet.oracle.com). The Oracle Concepts, Oracle Reference and Oracle SQL Reference are several good places to start.
This site is also another good starting point for locating resources to help you learn more about Oracle. Check out the Books, Training and Research section as well as doing general searches for 'SQL Tutorial' and the like.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.