Mastering SQL Table Joins from scratch: Real World Examples
3.9 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,522 students enrolled

Mastering SQL Table Joins from scratch: Real World Examples

Practical Hands-on Real Wold Table Joins
3.9 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,522 students enrolled
Last updated 2/2018
English
English [Auto]
Current price: $90.99 Original price: $129.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Install Relational Database Management System
  • Install TOAD
  • Connect TOAD to Oracle database
  • Install SQL Developer
  • Connect SQL Developer to Oracle database
  • Create various types of table joins
  • Build real world table joins with SQL
  • Generate ERD
  • Use concatenation operator
  • Use comparison operators
  • Use various logical operators
  • Use Aliases in building quries
  • Use various Join clauses and keywords
  • Use GROUP BY clause to group data sets.
Course content
Expand all 54 lectures 05:21:56
+ Getting Started
13 lectures 01:30:29
Tools used to execute queries and scripts
08:39
Download and installation of Oracle
08:11
How to unlock sample oracle hr schema account
05:04
Download and install TOAD
07:09
Connect TOAD to Oracle database
06:38
Download and install Oracle SQL Developer
08:55
Connect SQL Developer to Oracle database
06:05
Introduction to database concepts
07:09
Introduction to ERD
05:32
How to generate ERD using SQL Developer
13:02
How to generate ERD using TOAD
03:59
Using Character Functions
07:50
+ Introduction to Table Joins
9 lectures 01:02:32
Introduction
01:49
Creating Equi Joins
04:49
Creating Non - Equi oins
10:27
Creating Natural Joins
07:04
Creating Self Joins
07:49
Creating Cartesian Join
06:47
Creating Outer Joins
08:03
Using Aliases
07:04
Keywords used in Join Operations
08:40
+ Some SQL Key Clauses
4 lectures 19:50
WHERE clause
05:22
FROM clause
02:51
ORDER BY clause
04:02
GROUP BY and HAVING clause
07:35
+ SQL Operators
10 lectures 45:00
Introduction to logical operators
00:40
ALL operator
04:01
ANY operator
04:01
NOT operator
02:49
IS NULL Operator
02:42
AND operator
04:46
IN operator
04:48
OR operator
04:12
Comparison Operators
07:43
LIKE operator
09:18
+ Practical Real World SQL Table Joins Examples
18 lectures 01:44:05
Introduction
01:41
Exercise 1
08:35
Exercise 2
08:46
Exercise 5
06:59
Exercise 7
04:48
Exercise 8
05:31
Exercise 9
05:43
Exercise 11
08:26
Exercise 12
07:05
Exercise 13
03:36
Exercise 14
05:57
Exercise 15
05:01
Exercise 16
05:39
Exercise 17
05:01
Requirements
  • You should be able to use a PC at beginner level
  • You should basic knowledge of SQL
  • You should basic knowledge of database concepts
Description

SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key; it specifies that the database management system is organised in such a way that there are clear relations defined between different sets of data. Join makes relational database systems relational.

Joins allow you to link data from two or more tables together into a single query result--from one single SELECT statement.

.When combining rows from multiple tables in one query, you need to use the JOIN command. There are a few different types of joins, and the following should help explain the differences between them.

The syntax will vary depending on which database type you are using. In this course i have used Oracle database.

The JOIN operations, which are among the possible Table Expressions in a FROM clause, perform joins between two tables.

Below is a brief description of the various types of joins used in Oracle.

  • INNER JOIN operation
  • Specifies a join between two tables with an explicit join clause.
  • LEFT OUTER JOIN operation
  • Specifies a join between two tables with an explicit join clause, preserving unmatched rows from the first table.
  • RIGHT OUTER JOIN operation
  • Specifies a join between two tables with an explicit join clause, preserving unmatched rows from the second table.
  • CROSS JOIN operation
  • Specifies a join that produces the Cartesian product of two tables. It has no explicit join clause.
  • NATURAL JOIN operation
  • Specifies an inner or outer join between two tables. It has no explicit join clause. Instead, one is created implicitly using the common columns from the two tables.

In all cases, you can specify additional restrictions on one or both of the tables being joined in outer join clauses or in the WHERE clause.

In this course there will be lots of hands-on real world examples of SQL table joins.

Who this course is for:
  • Beginner database administrators
  • Beginner data analyst
  • Anyone who wants to learn how to join tables