Consolidate your knowledge of operating on two or more data tables in PostgreSQL database. This online practice set consists of 93 interactive exercises and will help you polish your SQL joining skills.
This online practice set is designed for users who already know the basics of PostgreSQL queries. It will be of interest to anyone who wants to polish or refresh their knowledge of JOIN clauses. Keep reading for more details.
PostgreSQL JOIN is one of the most commonly used clauses in relational databases. If you want to successfully process the data stored in multiple tables, learning PostgreSQL JOIN is a must. With this online practice set, you will learn all PostgreSQL JOIN types: LEFT JOIN, RIGHT JOIN, INNER JOIN, and FULL JOIN. You'll also get the hang of non-equi JOIN.
Are you someone who already knows how to write simple queries and wants to learn more? Then this online course is for you!
86%
off
Reg. price
$1512
Includes 41 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, Introduction to R, Tidyverse, Data Visualization 101, 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, Lists and Functions in R, Data Manipulation in R, 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
35 hours left at this price!
72%
off
Reg. price
$324
Includes 8 courses SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Creating Basic SQL Reports in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS
Bundle price $89
35 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
