Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Real World Oracle SQL Queries Examples to your Wishlist.

Add to Wishlist

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
Last updated 12/2015
$10 $55 82% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
Have a coupon?

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
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.
Students Who Viewed This Course Also Viewed
What Will I Learn?
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
View Curriculum
  • You should have a sample database and connection to the database.We 'll cover this in section one of this course
Curriculum For This Course
Expand All 20 Lectures Collapse All 20 Lectures 02:10:17
Setting up Database Environment
8 Lectures 39:59

Unlocking Hr Schema

Installing Java JDK8

Oracle SQL Developer Download

Installing Oracle SQL Developer

Launching Oracle SQL Developer
Using real world SQL Examples queries on an Oracle Database
12 Lectures 01:30:18
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
About the Instructor
4.2 Average rating
855 Reviews
23,003 Students
57 Courses
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.

Report Abuse