Joining Data in SQL

via

DataCamp

Course Features

Duration

5 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

5 hours

Course Description

Once you've completed the Introduction to SQL course and have a good understanding of the basics of SQL, it's time to improve your queries with joins or relational set theory. This course will teach you about the power and benefits of joining tables, as well as the unique characteristics of cities around the world. Learn inner and outer joins as well as self, semi, and anti joins. Cross joins are a vital tool in any PostgreSQL wizards' toolbox. After you've mastered intersections, exception clauses, and unions using simple diagrams and examples you won't have to worry about setting it up theory. You will also learn about subqueries. These ideas can also be visualized using Venn diagrams or other linking illustrations.

Course Overview

Virtual Labs

Job Assistance

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Introduction to SQL is recommended to take first

What You Will Learn

Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL

You will be able to visually grasp these ideas by using Venn diagrams and other linking illustrations

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

You'll be introduced to the challenging topic of subqueries

Course Content

Expand all sections

Module 1: Introduction to joins

Module 2: Outer joins and cross joins

Module 3: Set theory clauses

Module 4: Subqueries

Course Instructors

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 Spreadsheet...