Oracle :: Getting Started

Learn the basics of creating a local development database and interacting with it using free tools.
4.1 (76 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
4,258 students enrolled
Take This Course
  • Lectures 7
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


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.

About This Course

Published 1/2013 English

Course Description

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!

What are the requirements?

  • Internet connection and a brain

What am I going to get from this course?

  • Connect to your newly installed database using TOAD and/or SQL Developer

Who is the target audience?

  • Beginner

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Charles Cranfill, Code Monkey. Trainer. Consultant Extraordinaire.

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.

Ready to start learning?
Take This Course