Mastering SQL Table Joins from scratch: Real World Examples

Practical Hands-on Real Wold Table Joins

3.65 (20 reviews)
Udemy
platform
English
language
Databases
category
Mastering SQL Table Joins from scratch: Real World Examples
2,548
students
5.5 hours
content
Jun 2021
last update
$39.99
regular price

What you will 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.

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.

Content

Getting Started

Introduction
Tools used to execute queries and scripts
Download and installation of Oracle
How to unlock sample oracle hr schema account
Download and install TOAD
Connect TOAD to Oracle database
Download and install Oracle SQL Developer
Connect SQL Developer to Oracle database
Introduction to database concepts
Introduction to ERD
How to generate ERD using SQL Developer
How to generate ERD using TOAD
Using Character Functions

Introduction to Table Joins

Introduction
Creating Equi Joins
Creating Non - Equi oins
Creating Natural Joins
Creating Self Joins
Creating Cartesian Join
Creating Outer Joins
Using Aliases
Keywords used in Join Operations

Some SQL Key Clauses

WHERE clause
FROM clause
ORDER BY clause
GROUP BY and HAVING clause

SQL Operators

Introduction to logical operators
ALL operator
ANY operator
NOT operator
IS NULL Operator
AND operator
IN operator
OR operator
Comparison Operators
LIKE operator

Practical Real World SQL Table Joins Examples

Introduction
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Exercise 6
Exercise 7
Exercise 8
Exercise 9
Exercise 10
Exercise 11
Exercise 12
Exercise 13
Exercise 14
Exercise 15
Exercise 16
Exercise 17

Charts

Price

Mastering SQL Table Joins from scratch: Real World Examples - Price chart

Rating

Mastering SQL Table Joins from scratch: Real World Examples - Ratings chart

Enrollment distribution

Mastering SQL Table Joins from scratch: Real World Examples - Distribution chart
1558718
udemy ID
2/17/2018
course created date
7/27/2019
course indexed date
Bot
course submited by