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