Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

EssentialSQL: Join Together Now, Write Complex Queries

Name: EssentialSQL: Join Together Now, Write Complex Queries
Rating: 4.6 (138 reviews)

Learn INNER, OUTER, LEFT, RIGHT, SELF, & CROSS JOINS | use JOIN and ON clauses | SQL Query for Multiple Tables | T SQL

Highest Rated

Created byKris Wenzel, Essential Sql

Last updated 2/2024

English

What you'll learn

Completely revamped course, fully reproduced videos, new exercises, and more!
Understand the different types of joins available in SQL Server, including inner joins, outer joins, and cross joins.
Know how to use the JOIN clause to combine rows from multiple tables based on a common column.
Understand how to use the ON and clause to specify join conditions.
Know how to use self-joins to join a table to itself.
Create queries using either MySQL, PostgreSQL, or SQL Server.
Learn to simplify complex SQL statement with table aliases
Overcome one of the major stumbling blocks stopping you from mastering SQL.

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

8 sections • 24 lectures • 2h 13m total length

Welcome to the Course1:47
Welcome to Join Together Now. Let's learn how to build queries using Inner, Outer, and Full Joins.
Why You Should Learn SQL Joins3:13
When databases are normalized the data is spread across several tables. Being able to recombine that data back into a single result is important. We can do that using database joins.
What Flavor of SQL Should I Choose?5:03
Understanding whether use MySql, Postgress, Sql Server, or Oracle is important. There are several consideration to take into account. Watch this video to get my take.
How to Take the Course5:57
Tools Used and Database Setup6:38
Watch this video to learn how where to get and install MySql, PostgresSQL, and SQL Server.

Introduction Quiz
Introduction to Relational Databases7:13
Before diving into joins, it's crucial to establish a solid foundation on relational databases. In this lesson, you are introduced to relational database concepts. I'll explain to you how they organize data into tables with rows and columns, and discuss the primary keys and foreign keys that establish relationships between tables. This will help you understand why joins are necessary and how they facilitate data retrieval across related tables
Making Changes to a Join Query
Do you have any questions?0:24

Inner Join Basics7:21
An inner join matches two or more table’s columns. A common pattern is to join two tables by their primary and foreign keys. Rows from tables that fail to match aren’t included in the result.
Inner Join Quiz
Inner Joins Basics - Examples5:51
Examples using an inner join to match two or more table’s columns. A common pattern is to join two tables by their primary and foreign keys. Rows from tables that fail to match aren’t included in the result.
Inner Joins - Foreign Key Gone Wrong!
Inner Join - Last Order Date
Inner Join - Join Two Tables Together
Table Aliases5:48
After completing this lesson you'll know what a table alias is, appreciate the need to use table aliases in your joins.
Multi-Table Joins2:56
Learn to join three or more tables in your query. You going to see it isn't too much different than using one. We'll use an ERD (Entity Relationship Diagram) to help "navigate" the database.
Multi-Table Joins - Examples8:12
Look at examples of joining many tables using SQL.
Add a Join to an Existing Query
Joining Three or More Tables

Joining Two or More Columns2:25
Learn how to use Boolean operators to join one or more columns in a join condition.
Joining Two or More Columns Examples9:29
We'll look at using two or more join conditions in a select statement and the impact of using the incorrect Boolean operator.
Joining Two Columns
Non-Equi Joins2:49
Learn to use joins whose join conditions use conditional operators other than equals.
Working with Non-Equi Joins
Working with Non-Equi Joins (advanced)

Introduction4:36
Learn about outer joins and how row are matched from one table to the next using the join condition.
Introduction to Outer Joins
Find Orphan Records Using an Outer Join
Right versus Left Outer Joins4:26
Learn about the left and right table and the huge difference there is between a RIGHT versus as LEFT outer join!
Right versus Left Outer joins
Full Outer Joins7:01
By the time you've watched this lesson, you'll know that an full outer join is a LEFT and RIGHT outer join in one.
Full Outer Joins - Examples9:03
Lets look at the difference between Left and Right outer joins and learn how to convert a "left" join into a "right" join.
Full Outer Joins
Left, Right, and Full Outer Joins.

Requirements

If you can write a simple GROUP BY statement with HAVING, then you are ready for this course.
No special equipment needed, all exercises are done online.
Optional: Install a MySQL, PostgreSQL, or SQL Server learning lab on your own computer.

Description

In this Course you will Learn to:

Write join statements that work with MySQL, PostgreSQL, SQL Server, Oracle, and SQLite.
Write Inner Joins.
Learn to write outer joins, and know the difference between a right and left outer join.
Understand when and how to use a full outer join. You even be able to reproduce the result of a full outer join using other statements!
Learn about other types of joins such as self joins, cross joins, non-equi joins, and outer joins, and when it is appropriate to use them.
Use different types of joins to solve real-world query problems.
Understand the key differences between inner and outer joins.
Use non-equi joins to solve interesting problems such as calculating running totals.
Combine columns from two or more tables into a single result.
Know when to use an outer join.

Learning SQL Should Not Be Out of Your Reach

With so much information available on the Internet it's easy to get confused. You want to continue learning SQL but don't know where to start. SQL is deceptive, mysterious, especially if not explained well.

But it doesn’t have to be this way!

Nothing is worse than

Being excited to learn something new but not knowing where to start.
Wasting time learning the wrong features.
Being overwhelmed with options and not know which to use.

Imagine Having

Knowledge - Knowing how to quickly use joins to take your SQL to the next level.
Confidence - Feeling good that you’re on the right track.
Accomplishment - Having a sense of accomplishment that you've learned something most cannot.
Fun - Having fun learning SQL inner and outer joins!

By the time you’ve completed this course you’ll have an appreciation of joins, overcome your fear, and able to write queries combining data from multiple tables.

Now that’s cool!

Who this course is for:

Beginner SQL query authors curious about combining data from multiple tables using SQL joins.
If you're struck writing joins or baffled by outer joins, then this course is for you!
Business analysts looking more ways to write queries.
If you're having a hard time understanding the ins and outs of SQL joins, then this course is for you as I explain it to you in simple to understand English.

EssentialSQL: Join Together Now, Write Complex Queries

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction5 lectures • 23min

Warmup2 lectures • 8min

Inner Joins5 lectures • 30min

SQL Cross Joins2 lectures • 9min

Join Conditions3 lectures • 15min

Outer Joins4 lectures • 25min

Self Joins2 lectures • 23min

Wrap-up1 lecture • 1min

Requirements

Description

Who this course is for: