Real World Oracle SQL Queries Examples

Create reports and solutions using oracle SQL
0.0 (0 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.
66 students enrolled
73% off
Take This Course
  • Lectures 20
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
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 12/2015 English

Course Description

Data is so vital and we interface with it in our daily lives.

Data is stored in databases which in turn stores the data in tables that contains rows and columns.

There are several database applications available to handle the storage and management of data examples include Oracle, Microsoft SQL and MySQL. We need a way to communicate with these database applications and the language used in doing that is SQL which stands for structured query language.

This course is a hands-on practical course that will build your confidence using SQL. All the queries used in this course are from a real world live production environment except that the table’s database and schema are different.

This course is video based and under 2 hours long with easy to follow real world query examples.

The example real world queries in this course includes:

  • Creating various reports using SQL
  • Creating a new table in a schema
  • Performing count operations on a table
  • Adding new record into a database
  • Deleting records from a database
  • Sorting query results in descending or ascending order
  • Reading and filtering data from a database

What are the requirements?

  • You should have a sample database and connection to the database.We 'll cover this in section one of this course

What am I going to get from this course?

  • Create reports using SQL
  • Add a new record into a database
  • Delete a record from a database
  • Perform a count operation on a table
  • Sort data in ascending or descending order
  • Create a new table in a schema

Who is the target audience?

  • This course is meant for students who already have a basic working knowledge of how to use sql to get information into and from a database.

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: Setting up Database Environment
Download Oracle Database
Installing Oracle Database
Unlocking Hr Schema
Installing Java JDK8
Oracle SQL Developer Download
Installing Oracle SQL Developer
Launching Oracle SQL Developer
Section 2: Using real world SQL Examples queries on an Oracle Database
How to get the total count of employees in a company
How to update employee salaries in a company after a pay increase
How to produce a report of unique salaries in a company
How to produce a report of people with same job titles in a company
How to produce a report with a specified criteria
How to produce a salary report
How to produce a report of employees with no managers
Adding new record into a database
Creating a new Table
Deleting a record from a table
How to determine number of employees
How to produce a report of hire date

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bluelime Learning Solutions, Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Ready to start learning?
Take This Course