Joining Data in SQL

Course Description

Now that you've learned the basics of SQL in our <a href="https://www.datacamp.com/courses/intro-to-sql-for-data-science">Intro to SQL for Data Science</a> course, it's time to supercharge your queries using joins and relational set theory. In this course, you'll learn all about the power of joining tables while exploring interesting features of countries and their cities throughout the world. You will master inner and outer joins, as well as self joins, semi joins, anti joins and cross joins—fundamental tools in any PostgreSQL wizard's toolbox. Never fear set theory again after learning all about unions, intersections, and except clauses through easy-to-understand diagrams and examples. Lastly, you'll be introduced to the challenging topic of subqueries. You will be able to visually grasp these ideas by using Venn diagrams and other linking illustrations.

In the following tracks

Data Science for EveryoneData Analyst Data Analyst SQL FundamentalsSQL Server Fundamentals

Datasets

CountriesLeadersDiagrams

Collaborators

Filip SchouwenaarsColin Ricardo

Prerequisites

Introduction to SQL

Chester Ismay

Data Science Evangelist at DataRobot

Chester leads data science, machine learning, and data engineering in-person workshops for DataRobot University with DataRobot. He built (and helped instructors build) R, Python, SQL, and Spreadsheets courses for DataCamp first as a Curriculum Lead and then as Head of Content Development. He obtained a PhD in Statistics from Arizona State University and has taught courses and led workshops in mathematics, computer science, statistics, data science, and sociology. He is co-author of the fivethirtyeight R package and author of the thesisdown R package. He is also a co-author of ModernDive, an open-source textbook for introductory statistics and data science students using R.

See More