Review and deepen your knowledge of SQL JOINs with 93 exercises. Practice common and less common ways of getting data from multiple tables.
JOINs are one of the most fundamental and commonly used features of the SQL language. It's safe to say that at least basic knowledge of querying data from more than one table is an absolute must for every SQL user.
This course covers all important types of SQL JOINs that are widely used by SQL programmers to query databases on a daily basis.
This course is intended for users who have very basic experience with SQL. We assume you know how to write simple queries to select data from a single table.
Just a web browser and an Internet connection.
You'll also delve into the interesting topic of non-equi JOINs.
86%
off
Reg. price
$1442
Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python
Bundle price $199
37 hours left at this price!
67%
off
Reg. price
$369
Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS
Bundle price $119
37 hours left at this price!
48%
off
Reg. price
$193
Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Tables in SQL
Bundle price $99
37 hours left at this price!
47%
off
Reg. price
$187
Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Statistics 101, Introduction to Python for Data Science
Bundle price $99
37 hours left at this price!
Review the most common types of JOINs. Practice JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN and others.
0% completed 0 of 21 exercises done
Refine your joining skills. Exercise joining more than two tables in one SQL query.
0% completed 0 of 13 exercises done
Learn how to join SQL table with itself.
0% completed 0 of 12 exercises done
Practice joins with less common conditions: non-equi JOINs and joins between non-key columns.
0% completed 0 of 29 exercises done
Check your knowledge in the challenge.
0% completed 0 of 18 exercises done
