Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Get started using the free Oracle Express Edition database, SQL Developer, and TOAD in this beginner's walkthrough.
Once complete, you'll have a fully functioning database and be able to connect to a sample schema, view its objects, and examine the data held within.
This boot camp style course gives you the very basics needed (in just under 2 hours!) to get your foot in the door - whether you're an application developer who's just been christened App DBA, or you're a report developer who'd like to get your own sandbox together to play.
Best of all, we're using FREE tools!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Nuts and Bolts :: Get up and running. Fancy!|
|Who's this course intended for? What will you be able to do? To whom will you be able to do it?|
|Download and install the free Oracle 11g Express Edition database. It's free! No, really. Also, it's a real database. Seriously. Also, see a snafu!|
|Part deux - recovery, regain, and after reboot, a nice triple axel followed by a curtsy.|
|The free(!) and powerful SQL development tool from Oracle - SQL Developer - download, install, configure and connect.
Did I mention it's free!?
|The freeware equivalent to SQL Developer is TOAD. Download and install, configure and connect.|
|Connecting to a "real" database requires a TNS connection. here's how to do that.
Make sure a DBA is nowhere around, they'll get suspicious.
|Let me explain. No, that will take too long. Let me sum up.|
I've spent the last years as a travelling consultant for major US companies and universities. My experiences are across a broad array of technologies and requirements, and now I'm here to help you get going.
All feedback is most appreciated; I am willing to consider specific subject matters and am working on many topics for publication in the near future.