Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am currently a College Student and am taking an introduction to Oracle 10G. I cannot seem to make it to class all of the time and am curious to ask if there is any Virtual Oracle Server or something along those lines that would allow me to have a (in a nutshell) Virtual Database in which I can connect to via SQL* Plus and enter commands that I am learning? I am running Windows 7 Home Premium.

2 Answers
2

You can download and install the Oracle Database XE. It's free and has a default database that will be useful for your tests. You could search for an online SQL simulator, but it's not as useful as your own machine.

Good luck with school and stop skipping classes. At least database classes, skip others :-).

My teacher didn't explain to well on how we would be able to work from home if the time ever came... Which is why I am asking. But thank you very much, I appreciate the help.
–
iamaaronFeb 21 '12 at 20:17

1

No worries, mate. From my part you could learn even from the pub. As long as you're curious and want to learn I don't even care why and I hope you'll find enough help here or on StackOverflow (there you'll find more help with SQL problems) :). Try some simple video tutorials from youtube, like this one - for installation.
–
MarianFeb 21 '12 at 20:35

If you don't want to do an installation directly on you PC, Oracle provide pre-built VM images which contain an 11g database, SQL Developer and other tools; more info here.

They are very quick and easy to set up - no DBA knowledge required; can run on any machine and O/S that runs VirtualBox; and best of all, if (or when) you really mess something up you can trash it and start again.

Incidentally, not sure why you are being introduced to 10g when it is already out of support. Don't think you'll notice much difference with 11g at this stage though, the basics don't change much.