Retrieving Data from Oracle Database with SQL
4.0 (13 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.
1,673 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Retrieving Data from Oracle Database with SQL to your Wishlist.

Add to Wishlist

Retrieving Data from Oracle Database with SQL

Learn to use Oracle SQL
4.0 (13 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.
1,673 students enrolled
Last updated 5/2017
English
Curiosity Sale
Current price: $10 Original price: $110 Discount: 91% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Retrieve Data from multiple tables using table joins
  • Retrievie Data with Analytic Functions
  • Retrieve Data with SET Operators
  • Retrieve data using GROUP BY and HAVING clause
  • Retrieve data using Sub-Queries
  • Restrict and Sort Data
  • Use Distinct to eliminate duplicate data
  • Create views and retrieve data from them
  • Use WHERE Clause for filtering data
  • Use SELECT Statements to retrieve data
  • Use ORDER BY Clause to sort data
  • Use FROM clause to specify what table data is retrieved from
  • Use LIKE Operator and wild cards to search data patterns
  • Use Describe to view table structure
  • Use NOT and IS NULL operators
View Curriculum
Requirements
  • You should be able to use a computer effectively
  • You should understand basic database concepts
  • You should have a basic working knowledge of SQL
  • You should have Oracle database installed (We will cover that in the course)
  • You should have TOAD installed (We will cover that in the course
Description

Oracle database is one of the top and most widely used relational database management systems in the world .
This beginners course will teach you how to retrieve data from an oracle database.

We will start off by downloading and installing oracle  database 11g express which is free to use. Then we will install TOAD which is a tool we will be using to connect to the oracle database and retrieve data.

Topics we will cover in this course includes:

Retrieving Data 
Using SELECT Statements
Using FROM clause
Using WHERE Clause for filtering data
Using NOT Operator
Using the LIKE Operator
Using IS NULL
Using ORDER BY Clause
Using DISTINCT
Using Describe
Using and creating views
Using Sub-Query
Restricting and Sorting Data
Using ORDER BY Clause
Using GROUP BY and HAVING Clause


Retrieving Data with Aggregate Functions 
Introduction to aggregate functions
Using AVG function
Using COUNT function
Using MAX function
Using MIN function

Retrieving Data with Table Joins
Introduction to Table Joins
Using Equi Joins
Using Non Equi Joins
Using Cartesian Join
Using Outer Join
Using Self Join


Retrieving Data with Analytic Functions 
Introduction to Analytic Functions
The Syntax
Partition By Clause
First and Last Function
Row number Functions
Dense Rank Function
Lag Function
LEAD Function
RANK Function

Retrieving Data with SET Operators 
Using UNION ALL SET Operator
UNION SET Operator
Using INTERSECT Operator
Using Minus Operator


 By the end of this course you will have enough skill to retrieve data from an oracle database.


Who is the target audience?
  • Beginner Database Administrators
  • Beginner Data Analyst
  • Beginner Data warehouse administrators
  • Beginner Database Administrators
Students Who Viewed This Course Also Viewed
Curriculum For This Course
45 Lectures
04:09:29
+
Setting Up Oracle Database
7 Lectures 31:40



Unlock Sample Schema
05:09

Download TOAD
03:36

Install TOAD
04:08

Connecting to databse
05:21
+
Retrieving Data
14 Lectures 01:25:50
Using SELECT Statements
09:15

Using FROM clause
02:51

Using WHERE Clause for filtering data
05:22

Using NOT Operator
02:49

Using the LIKE Operator
09:18

Using IS NULL
02:42

Using ORDER BY Clause
05:48

Using DISTINCT
05:52

Using Describe
03:18

Using and creating views
11:02

Using Sub-Query
08:38

Restricting and Sorting Data
07:18

Using ORDER BY Clause
04:02

Using GROUP BY and HAVING Clause
07:35
+
Retrieving Data with Aggregate Functions
5 Lectures 15:39
Introduction to aggregate functions
01:38

Using AVG function
03:20

Using COUNT funcction
04:40

Using MAX function
03:13

Using MIN function
02:48
+
Retrieving Data with Table Joins
6 Lectures 43:49
Introduction to Table Joins
04:11

Using Equi Joins
07:46

Using Non Equi Joins
07:26

Using Cartesian Join
06:19

Using Outer Join
08:14

Using Self Join
09:53
+
Retrieving Data with Analytic Functions
9 Lectures 59:37
Introduction to Analytic Functions
06:43

The Syntax
04:07

Partition By Clause
08:04

First and Last Function
08:56

Row number Functions
09:26

Dense Rank Function
05:57

Lag Function
03:37

LEAD Function
06:43

RANK Function
06:04
+
Retrieving Data with SET Operators
4 Lectures 12:54
Using UNION ALL SET Operator
02:53

UNION SET Operator
05:23

Using INTERSECT Operator
02:50

Using Minus Operator
01:48
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,562 Reviews
35,130 Students
85 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.