Oracle SQL for beginners
3.6 (90 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
591 students enrolled

Oracle SQL for beginners

Learn how to query and manage data in the Oracle Database Using SQL. Practical, concept-building examples and quizzes.
3.6 (90 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
591 students enrolled
Last updated 11/2016
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 1 article
  • 12 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand the different components of an Oracle Database and how it works
  • Connect to an Oracle Database and run queries from different tools or from a file
  • Write basic queries involving Select, where, group by and other constructs
  • Write complex queries involving multiple tables, joins, subqueries and other techniques
  • Manage data using DML (insert, delete, update) and transaction control statements
  • Answer most of the frequently asked questions that are asked in interviews :)
Course content
Expand all 40 lectures 08:16:48
+ Setting up the environment
4 lectures 39:01

In this video, we take a look at some of the commonly used software that are used when working with the Oracle Database. Here's the list.

Oracle Database Server

Command line client tools (SQL*Plus)

IDEs (SQL Developer, Quest for Oracle, SQL Navigator and so on.

We also discuss a new term (Client-Server) which you might hear many times in the future when working with Database development or when working with a lot of other software like web servers.

Tools of the trade - Introduction

Which of these components is the server in our database environment?

Client Server
2 questions

In this video, we look at a new interesting way to set up your development environment using Oracle Virtual box and Developer VM.

virtual box :

Database application development VM :

Oracle virtual box and developer VM

In this video, we go through the steps to set up the accounts in the database. We'll look at 2 accounts. An administrative account called "SYS" and a "normal" database user account called "SCOTT"

Setting up the database in the VM

In this video, we look at a couple of alternatives to installing the virtual machine. (download links are present in the slide attached to the first video)

1) Installing each component individually


Alternatives to Virtual Machine
3 questions
+ (Select part 1) Let's write some SQL! Selecting data
3 lectures 39:36

In this chapter, we start writing very basic queries. Just the column list and the table. We also recap how to run scripts or SQL statements and see how you can see the structure of a table in any of the client tools.

Select statement : The very basics

Basic Select and Describe

Basic Select and Describe
3 questions
Data types Quiz
2 questions

In this chapter we complete our understanding of the basic select statement by understanding a few more important concepts such as primary keys and column aliases. We also unlock a few other sample accounts that come with the Oracle Database, to be used in the upcoming chapters.

Aliases, Primary keys and unlocking other accounts
Chapter 3 Quiz
5 questions
+ (select part-2) Grants, Filters, Groups and more.
5 lectures 01:43:08

In this chapter we learn that each database object is owned by one (and only one)database user. We discuss grants, privileges and how one user can access another's objects. We complete our schema set up by making sure each user in our sample database has read access on all the other users' tables.

Grants/Privileges - Accessing someone else's objects

In this video, we focus on filtering the data based on our needs, using the "where clause" in SQL. Programming exercises are in the materials section.

Preview 36:02

In this section, we discuss how to group and aggregate data and the in-built functions oracle provides that helps you group data.

Groups and aggregates - part 1

In this chapter, we discuss some common errors and best practices when it comes to grouping and aggregating data. We complete the section by discussing how to filter on groups using the "HAVING" clause inside sql.

Groups and Aggregates - Part -2

In this section, we learn how to sort data in Oracle using the order by clause.

We discuss the different ways possible and finally some good practises to keep in mind when sorting.

Sorting Data - "Order by" Clause in Oracle
+ (select part-3) Oracle functions and SQL
7 lectures 01:44:58

This video has a brief overview of Oracle functions and how they are generally used.

We also take a look at the dummy table DUAL, which can be used to test out expressions/calculations.

Introduction to Oracle functions

In this video, we discuss two of Oracle's most frequently used function types, Character(string) and Numeric functions.

Character and Numeric functions in Oracle

In this section, we discuss some of the most commonly used Oracle date and time functions. We also understand how "function overloading" practically works. At the end, we look at two real-world examples of how we often need to use multiple functions together to achieve the desired result.

Preview 21:32

In this section, we discuss various oracle functions that help us easily convert data from one data type to another and functions that help us format data.

List of Oracle 11gr2 conversion functions

Conversion Functions in Oracle

In this section, we discuss Oracle's functions that are used to deal with nulls. We look at three of the most commonly used functions. NVL, NVL2 and COALESCE.

Null handling functions in Oracle

We complete our discussion of Oracle functions by looking at DECODE and CASE functions, which help us write conditional logic in SQL

Conditional Logic functions in Oracle
Oracle Functions - Programming exercises
4 pages
+ (Select part-4) Joins, Sub queries and more advanced SQL
8 lectures 01:32:49

This video has a brief overview of Normalization and the problems that would occur when data is not normalized in a database.

More information here.


In this video, we start learning about joins. We look at how to identify the join columns and discuss inner-joins, which you can use to get matching data from 2 or more tables.

Preview 17:35

In this video, we continue our discussion of inner joins and understand how to identify the right join columns. We also take a look at two special types of joins, the self-join and the cartesian-join.

Inner joins (Contd..), Self joins, and Cartesian Joins

In this section, we discuss the three kinds of inner joins (left outer join, right outer join and full outer join) and understand when we need to use full outer joins, instead of inner joins.

Outer Joins

In this video, we'll take a look at ANSI syntax for inner joins, left and rigt outer joins and understand why the choice for this course was to explain joins using Oracle syntax.

ANSI vs Oracle Syntax

This quiz tests you on one of the most important parts of SQL - JOINS

Joins Quiz
4 questions
Joins programming exercises
2 pages

In this section, we discuss oracle subqueries, which help us combine results from two or more queries. The section might remind you of sets in mathematics :)

Set Operators
+ Creating and modifying objects (DDL commands)
4 lectures 31:05

In this section, we look at a brief overview of DDL (Data definition language) statements in Oracle and what they are used for.

Introduction to DDL statements
CREATE tables (and other objects)

In this section, we take a look at the MODIFY statement in SQL and learn how to use it to modify attributes at the table level and column level.

Preview 07:59

In this section, we discuss how to drop objects from the database. We continue to use tables as the example object for our dicussion.

Dropping objects (DROP Command)
+ Data Manipulation - Basic DML
6 lectures 01:15:27

Transactions are one of the main features that seperate a database from a file system. In this section, we take a look at transactions and the two most used transaction control statements in Oracle : COMMIT and ROLLBACK.

Transaction Control in Oracle

Oracle's delete statement is used to delete data from a table. In this section, we look at the syntax and a few examples of the delete statement.

the INSERT Statement

In this section, we look at how to use the UPDATE clause in oracle to make changes to existing data in a table. We discuss different possible scenarios and how you can control which columns to update and which rows to update.

Preview 17:53

What do you do when you want to update or insert date in a table based on the input data? You use the "MERGE" command in oracle. It's a very interesting and powerful SQL Command.We'll take a look at a couple of reasonably advanced use cases and see how merge makes it so easy to implement them.

the MERGE statement

Oracle's delete statement is used to delete data from a table. In this section, we look at the syntax and a few examples of the delete statement.

the DELETE statement

Deleting large amounts of data or all data from a table has to be often done with care.In this chapter, we'll take a look at the TRUNCATE command in oracle and see why you would want to use it instead of DELETE, when you want to delete all the data in a table

Oracle's TRUNCATE statement
+ Common Errors
1 lecture 01:39

If you are using a VM or if your database instance is in IDLE state, you might see this error when trying to connect. This short video shows how you can fix it.

Preview 01:39
+ Extra Resources
1 lecture 00:08
Big Data Pocket Reference
  • Access to a computer with 2-4 GB of RAM is preferred
  • any knowledge of prior programming would help, though not required
  • Basic knowledge of installing/unintsalling software and other usual system tasks

Course Summary

This introductory course teaches you how to work with data in your Oracle Database using Oracle's proprietary SQL language. It starts with the basic overview of what SQL is all about and then covers basic queries and common things you might be expected to do on a job. We then proceed to learn complex queries and data management such as inserting/updating/deleting data.

All the SQL examples and the power point slides are available for download and there are a few exercises/queries at the end of each chapter for you to test your understanding. I'll try and add more each week. At the end of the course, we also discuss some of the frequently asked questions in Oracle SQL to assess our understanding of the course and various topics and to understand some of the frequently asked interview questions.

The course should take about 2 weeks to complete, with 2-3 hours dedicated each day to go through the examples and work them out yourself.

Who this course is for:
  • Oracle Database developers
  • Data analysts
  • Software developers (java/.net/python) interacting with the Oracle Database
  • BI and ETL developers