Joining Data in SQL

Offered byDataCamp

Joining Data in SQL
at
DataCamp
Overview

Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries

Duration	4 hours
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

Joining Data in SQL
at
DataCamp
Highlights

Earn a certificate after completion of the course
Learn from the industry best faculty

Joining Data in SQL
at
DataCamp
Course details

Who should do this course?

Data Analysts and Scientists

Database Administrator

Business Analysts

Software Developers

What are the course deliverables?

This course provides a comprehensive understanding of various join operations, enabling learners to write efficient and effective queries that integrate data across different tables

In this comprehensive course on joining data, you'll delve into the intricacies of table joins and relational set theory, learning how to optimize your queries for efficient data retrieval
You will learn how to work with multiple tables in SQL by navigating and extracting data from various tables within a SQL database using various join types, including inner joins, outer joins, and cross joins

More about this course

The course will cover complex join operations, such as self-joins and non-equijoin conditions. Additionally, learners will understand how to use joins in conjunction with other SQL clauses and functions to create comprehensive and efficient queries

This course focuses on mastering various join techniques to enhance data analysis, reporting, and database management tasks

Joining Data in SQL
at
DataCamp
Curriculum

Introducing Inner Joins

The ins and outs of INNER JOIN

Your first join

Joining with aliased tables

USING in action

Defining relationships

Relationships in our database

Inspecting a relationship

Multiple joins

Joining multiple tables

Outer Joins, Cross Joins and Self Joins

LEFT and RIGHT JOINs

Remembering what is LEFT

This is a LEFT JOIN, right?

Building on your LEFT JOIN

Is this RIGHT?

FULL JOINs

Comparing joins

Set theory for SQL Joins

Joining Data in SQL
at
DataCamp
Faculty details

Maham Khan

Maham is a Data Scientist on a mission to make data skills accessible for everyone. She's worked on creating toolkits and exploring experimental applications of data science for urban analytics, disaster risk management, and climate change mitigation at the World Bank. She has a background in Experimental Psychology and Philosophy from the University of Oxford and Urban Data Science from NYU.