EssentialSQL: Join Together Now, Write Complex Queries
- Descrição
- Currículo
- FAQ
- Revisões
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!
-
1
Welcome to the CourseWelcome to Join Together Now. Let's learn how to build queries using Inner, Outer, and Full Joins.
-
2
Why You Should Learn SQL Joins
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.
-
3
What Flavor of SQL Should I Choose?
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.
-
4
How to Take the Course
-
5
Tools Used and Database Setup
Watch this video to learn how where to get and install MySql, PostgresSQL, and SQL Server.
-
6
Introduction Quiz -
7
Introduction to Relational Databases
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
-
8
Making Changes to a Join Query
-
9
Do you have any questions?
-
10
Inner Join Basics
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.
-
11
Inner Join Quiz
-
12
Inner Joins Basics - Examples
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.
-
13
Inner Joins - Foreign Key Gone Wrong!
-
14
Inner Join - Last Order Date
-
15
Inner Join - Join Two Tables Together
-
16
Table Aliases
After completing this lesson you'll know what a table alias is, appreciate the need to use table aliases in your joins.
-
17
Multi-Table Joins
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.
-
18
Multi-Table Joins - Examples
Look at examples of joining many tables using SQL.
-
19
Add a Join to an Existing Query
-
20
Joining Three or More Tables
-
21
What is a Cross Join?
After completing this lecture you'll know the difference between a cross join and an inner join.
-
22
Cross Join Examples
We'll do some example SQL Cross Joins and you can learn how to create combinations of rows from two or more database tables.
-
23
Cross Join Quiz
-
24
Cross Join Assignment
-
25
Joining Two or More Columns
Learn how to use Boolean operators to join one or more columns in a join condition.
-
26
Joining Two or More Columns Examples
We'll look at using two or more join conditions in a select statement and the impact of using the incorrect Boolean operator.
-
27
Joining Two Columns
-
28
Non-Equi Joins
Learn to use joins whose join conditions use conditional operators other than equals.
-
29
Working with Non-Equi Joins
-
30
Working with Non-Equi Joins (advanced)
-
31
Introduction
Learn about outer joins and how row are matched from one table to the next using the join condition.
-
32
Introduction to Outer Joins
-
33
Find Orphan Records Using an Outer Join
-
34
Right versus Left Outer Joins
Learn about the left and right table and the huge difference there is between a RIGHT versus as LEFT outer join!
-
35
Right versus Left Outer joins
-
36
Full Outer Joins
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.
-
37
Full Outer Joins - Examples
Lets look at the difference between Left and Right outer joins and learn how to convert a "left" join into a "right" join.
-
38
Full Outer Joins
-
39
Left, Right, and Full Outer Joins.
-
40
What is a Self Join?
Learn about joining a table to itself and the situations where it makes sense to do this.
-
41
Self Join Assignment
-
42
Self Join Quiz
-
43
Using an Inner Join as a Self Join
-
44
Using a Outer Join as a Self Join
-
45
Calculating a Running Total using Self Joins (Intermediate)
We’ll join the tables together to get combination of orders, this will allow us to then summarize the orders.
