Joining Data in SQL

Course Cover

5

(3)

compare button icon
Course Report - Joining Data in SQL

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Course Features

icon

Duration

5 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

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

projects-img

Virtual Labs

projects-img

Job Assistance

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

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

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

Course Instructors

Author Image

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

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover