How to Extract Data from Multiple Oracle Tables Using SQL
4.8 (4 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,095 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to Extract Data from Multiple Oracle Tables Using SQL to your Wishlist.

Add to Wishlist

How to Extract Data from Multiple Oracle Tables Using SQL

Learn to use Table Joins to extract data from multiple tables
4.8 (4 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,095 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $105 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Download and Install Oracle Database
  • Download and install TOAD
  • Unlock Sample Schema and Tables
  • Understand Database Concepts
  • Extract data from multiple tables using Equi -Join
  • Extract data from multiple tables using Non-Equi Join
  • Extract data from multiple tables using Cartesian Join
  • Extract data from multiple tables using Self Join
  • Extract data from multiple tables using Outer Join
View Curriculum
Requirements
  • You should be able to use a PC at beginner level
  • You should have a basic understanding of database concepts
  • You should know how to connect to a database
Description

There are times when the data you need to extract from a database are spread across multiple tables and the way to combine  the required data from multiple tables is via table joins. This beginners course will explain some of the types of table joins available in Oracle .

A join is a query that combines rows from two or more tables or views. Oracle Database performs a join whenever multiple tables appear in the FROM clause of the query. The select list of the query can select any columns from any of these tables. If any two of these tables have a column name in common, then you must qualify all references to these columns throughout the query with table names to avoid ambiguity.

There are certain conditions that has to be met before Joins can be implemented.
Most join queries contain at least one join condition, either in the FROM clause or in the WHERE clause. The join condition compares two columns, each from a different table. To execute a join, Oracle Database combines pairs of rows, each containing one row from each table, for which the join condition evaluates to TRUE. The columns in the join conditions need not also appear in the select list.

To execute a join of three or more tables, Oracle first joins two of the tables based on the join conditions comparing their columns and then joins the result to another table based on join conditions containing columns of the joined tables and the new table. Oracle continues this process until all tables are joined into the result. 

The types of joins we will cover include:

  •    Extracting data using Equi Join
  •    Extracting data using Non- Equi Join
  •    Extracting data using Cartesian Join
  •    Extracting data using Outer Join
  •    Extracting data using Self Join
Who is the target audience?
  • Beginner Database Administrators
  • Beginner Data Analyst
  • Beginner Data Scientist
  • Beginner Data warehouse Engineeers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
01:48:13
+
Database Setup
11 Lectures 01:04:24



Unlock Sample Schema and Tables
03:30

Download TOAD
05:29

Install TOAD
03:33

Connecting to Database
08:11

Database Concepts - Part 1
04:31

Database Concepts - Part 2
10:16

Viewing the structure of a table
03:18

Understanding Views
11:02
+
Extracting Data from multiple tables using Table Joins
6 Lectures 43:49
Introduction
04:11

Equi Join
07:46

Non -Equi Join
07:26

Catesian Join
06:19

Outer Join
08:14

Self Join
09:53
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,733 Reviews
38,515 Students
91 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.