Introduction to Oracle SQL

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.
4.3 (39 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,482 students enrolled
Instructed by Ben Brumm Development / Databases
Take This Course
  • Lectures 37
  • Length 4 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 9/2013 English

Course Description

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures to teach you Oracle SQL, covering database topics such as:

  • Setting up your Oracle environment
  • Basic terminology
  • Reading data using a SELECT statement
  • What can be done using a SELECT statement
  • Functions
  • Data types
  • Joins, set operators, subqueries
  • Inserting, updating and deleting data
  • Creating tables

The course materials run for approximately 4 hours and are split into multiple sessions.

It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

  • You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
  • Avoid paying thousands of dollars for training.
  • You can also study in your own time!
  • Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.

What are the requirements?

  • Access to an Oracle database - a test database or somewhere you can install Oracle yourself

What am I going to get from this course?

  • In this course, you will learn how to write basic SQL statements to view data, insert data, update existing data and delete data in a database.

What is the target audience?

  • Those who have some knowledge about IT but minimal SQL knowledge
  • University or college students
  • Those who need to use a database at work, but don't know how

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: Introduction and Setup

An introduction to this course, who I am, and what will be covered.


Explains key concepts used in Oracle and this course, as well as what tools are needed for this course.


Demonstration of how to download the Oracle Client.


Demonstration of how to install the Oracle Client.

How To Install Oracle On A Mac

Demonstration of how to download the Java Development Kit.


Demonstration of how to install the Java Development Kit.


Demonstration of how to download the Oracle SQL Developer software.


Demonstration of how to setup the Oracle SQL Developer software.


Demonstration of how to setup the connections inside the Oracle SQL Developer software.

Section 2: Viewing Data

Covers the basics of an SQL statement and how to run it on SQL Developer.


Demonstrates how to create a new user in SQL Developer.


Demonstrates how to create and populate the tables required for this course.


Includes how to run SELECT statements on the data in this database.


Explains the concepts of operators, as well as the DISTINCT and NULL keywords.


Covers some of the data types used in Oracle SQL.


Part one of how to restrict the data and sort it in a SELECT statement.


Part two of how to restrict the data and sort it in a SELECT statement.

Section 3: Functions

Explains some of the string functions in Oracle SQL.


Explains some of the number functions in Oracle SQL.


Covers how to work with dates and times in Oracle.


Explains some of the date functions in Oracle SQL.


Explains some of the conversion functions in Oracle SQL.


Covers the aggregate functions used in Oracle.

Section 4: More SELECT Concepts

Explains what table aliases are, as well as how to use joins.


Part two of using joins on tables in Oracle.


This session covers the concept of set operators and how to use them.


Covers three concepts inside Oracle - Translate, Decode and Case.


Explains the concept of a subquery, focusing on those that work with single rows.


Explains the concept of a subquery, focusing on those that work with multiple rows.

Section 5: DML - Data Manipulation Language

Introduces the INSERT statement for inserting data into a table.


Covers the UPDATE statement for updating data in a table.


Covers how to delete data from a table.

Section 6: Objects

Explains several of the object types used in Oracle.


Looks at how to create a table, as well as how constraints are used.


Covers how to alter and drop a table in Oracle.

Section 7: Conclusion

The course conclusion and next steps.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ben Brumm, IT Software Consultant

I'm a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.

I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!

I'd like to teach others about databases and database topics, such as SQL, database design, and performance.

Ready to start learning?
Take This Course