Joining Data in SQL

Name: Joining Data in SQL
Brand: Careervira
Price: 74 USD
Availability: InStock
Rating: 1 (1 reviews)

via

DataCamp

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.

Visit Course Report

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