Oracle :: Getting Started

Learn the basics of creating a local development database and interacting with it using free tools.
  • Lectures 7
  • Video 2 Hours
  • Skill level beginner level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

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.

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?

  • Over 7 lectures and 1.5 hours of content!
  • Connect to your newly installed database using TOAD and/or SQL Developer

What 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.

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.

Join the biggest student community


Hours of video content


Course Enrollments




Average Rating
  1. 5 Stars
  2. 4 Stars
  3. 3 Stars
  4. 2 Stars
  5. 1 Stars
    • Bernal Calderón

    Simple para empezar

    Bien explicado, muy básico pero interesante

    • Jeremy Bouchard

    Great Course!

    Course is a great walkthrough of the installation and startup for Oracle, SQL Developer, and Toad.

    • M. A. Farrar

    Too basic to be of any use

    While I understand that this is a "basic intro" course I expected a bit more detail based on the course description. For example, as others have commented, the instructor makes references to "schema" without explaining what a schema is. Perhaps I am being too harsh since I already have a bit of db experience (Oracle, Informix, MySQL) but the lack of content that I would expect from a basic intro course makes me suspect that any higher level courses would also be lacking in useful content.

    • Oleksandr Kravchuk

    thank you !

    • Manoj Kumar Thakur


    The course content is good for beginers to start with Oracle. Very useful

Show more reviews
Ready to start learning?
Preview this course