10 Types of Joins in Data Analysis (SQL & Python)

Focused View

Ajmal Ali

33:05

503 View

1. Introduction

1. Introduction.mp4

02:15

2. Joins in SQL

1.1 SQL JOIN script.txt

1. Joins in SQL.mp4

16:21

3. Joins in Python

1. Joins in Python.mp4

10:12

4. Quiz

1. Joins in SQL & Python Quiz.mp4

03:57

5. Thanks & Congrats

1. Thanks & Congrats!!!.mp4

00:20

Description

Mastering the JOIN operation in Data Analysis

What You'll Learn?

Detailed knowledge about Joins in data analysis
Different types of joins, when to use them?
Joins in SQL and their equivalent in Python
Coding practice on all types of Join operations

Who is this for?

Data Analysts, Computer Science students.

What You Need to Know?

No Application/ software set up Needed, knowledge about SQL/Python NOT mandatory; but will be helpful

More details

Description
Detailed course about various joins in data analysis. The course includes hands-on session for each type of the join.
Joins are one of the most important operation in data analysis, to perform analysis based on multiple data sources.
There are various types of joins; but, sometimes it is confusing to decide which join to be used for a given scenario.

This course explains the 10 types of joins in SQL and their equivalent syntax in python.

Each of them are explained clearly and a coding practice is also performed.

No software setup or costly registration required. All coding practice is performed online.
The SQLÂ coding practice is performed using Oracle Live SQLÂ session; and all the code to set up the tables to practice the joins are shared with this course, To practice python, we use jupyter notebooks.

No prior knowledge is mandatory; If you have previous work experience in SQL or Python, that will be helpful; but, it is not mandatory.

This course will be helpful for computer science students , and also to data analysts.Â Many of the coding practice scenarios are based on real time work experience and job interview experience, Thus, it will be helpful to boost your career also to next level.
Who this course is for:
Data Analysts, Computer Science students.

User Reviews

Rating

average 0

Total votes0

Focused display

I am a data tech proferssional with more than a decade of experience in data analytics. Currently I work as a data engineer (AWS cloud technologies). I have practical experience in activities ranging from data analytics, data modeling & integration, SQL tuning, automated data extraction, data feed developments, machine learning. My technical stack includes- SQL, Python, AWS cloud technologies, Pyspark, Power BI etc; I am a continuous learner with below certifications:* Oracle Certified SQL Expert* AWS certified data analytics speciality* Google certified professional data engineerI love to learn and also to help others to learn. :)

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.