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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

Curriculum

Section 1: Nuts and Bolts :: Get up and running. Fancy!
06:15
Who's this course intended for? What will you be able to do? To whom will you be able to do it?
23:23
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!
12:26
Part deux - recovery, regain, and after reboot, a nice triple axel followed by a curtsy.
25:07
The free(!) and powerful SQL development tool from Oracle - SQL Developer - download, install, configure and connect. 


Did I mention it's free!?

19:09
The freeware equivalent to SQL Developer is TOAD. Download and install, configure and connect.
10:19
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.
03:49
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.

Reviews

Average Rating
4.2
Details
  1. 5 Stars
    34
  2. 4 Stars
    15
  3. 3 Stars
    8
  4. 2 Stars
    2
  5. 1 Stars
    4
    • 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.

    • Manoj Kumar Thakur

    Review

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

    • Pete Rios

    helpful and very informattive....

    Very well presented and to the point.... thx

    • Elizabeth Rohan

    boring

    I thought they have more examples of using oracle

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,400,000

Hours of video content

21,000,000

Course enrollment

6,300,000

Students

Ready to start learning?
Preview this course