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.
62 students enrolled
$19
$55
65% 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

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.

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

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

Curriculum

Section 1: Setting up Database Environment
Introduction
Preview
04:59
Download Oracle Database
Preview
04:58
Installing Oracle Database
Preview
04:47
Unlocking Hr Schema
05:09
Installing Java JDK8
05:24
Oracle SQL Developer Download
04:55
Installing Oracle SQL Developer
06:07
Launching Oracle SQL Developer
03:40
Section 2: Using real world SQL Examples queries on an Oracle Database
How to get the total count of employees in a company
03:27
How to update employee salaries in a company after a pay increase
11:07
How to produce a report of unique salaries in a company
06:24
How to produce a report of people with same job titles in a company
07:42
How to produce a report with a specified criteria
08:53
How to produce a salary report
09:40
How to produce a report of employees with no managers
04:49
Adding new record into a database
09:12
Creating a new Table
07:42
Deleting a record from a table
05:11
How to determine number of employees
03:27
How to produce a report of hire date
12:44

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