Home > Ask the Oracle Experts > (Archive) Database Installation and Upgrade Questions & Answers > Which version of Oracle should I install on my laptop to practice for OCP exams?
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Which version of Oracle should I install on my laptop to practice for OCP exams?

Dan Norris EXPERT RESPONSE FROM: Dan Norris

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 05 October 2004

I intend to take the OCP Oracle certfication exams. I intend to take the IZO-007 exams next month. I am new to Oracle even though I have three years of experience using MySQL on Linux.

I have a laptop Compaq AMD Athlon processor +2800, 398 MHz, 40G, 512 RAM with Windows XP Home installed on it. Can I install Oracle on it, and if so, which type of Oracle can I install on it for practice purposes? Also, now that 10g is out does it still make sense to study for 9i exams? I would appreciate a prompt response to these.


>
EXPERT RESPONSE

There have been many changes recently to the OCP program and the 10g OCP DBA program is now available. If you're just getting started, I'd encourage you to follow the 10g OCP path.

As for a test bed, I'd take your laptop and install Linux on it first and then use the Oracle 10g for Linux database available from otn.oracle.com/software. Of course, you don't have to install Linux -- Oracle 10g also runs on Windows (though I'm not sure about XP Home edition). Check the certification matrix to determine if XP Home is supported.

Unfortunately, your experience with MySQL won't probably help too much with Oracle DBA tasks except that you'll already know some of the ANSI standard SQL. I find that one of the most difficult things about working on other database platforms (after having worked with Oracle for so long) is determining what SQL is "standard" and which parts are Oracle-specific. Unless you've worked on other databases in addition to MySQL, you may have the same problems. The SQL reference guide is very good and complete, so I'd imagine you'll make it a frequently used reference in your studies.

Good luck on your certification!


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
(Archive) Database Installation and Upgrade
Starting database automatically
Database Upgrade Assistant error
9.2 versus 9i
Empty error dialog window from the Database Configuration Assistant after install
Looking for 8.1.7 as stepping stone to 9.2
Command-line installation of 8.1.7?
Oracle 10g migration guide
Oracle 7.0 vs. higher Oracle versions
Export and import
Connection error with Oracle 8.1

Oracle training and certification
Oracle certifications to get an Oracle DBA job
What should I study after Oracle 9i training?
Confused about Oracle certification exams
Difference between Oracle Forms and E-Business Suite
Becoming a DBA with no experience
Oracle 10g study materials
Complete guide to becoming an Oracle database administrator
The power of Oracle certification
Switching to Oracle from Indian RDBMS
Oracle 9i or 10g OCP exams?

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsTipsAsk the ExpertsWebcastsWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts