SQL JOINS for beginners { Must Read }

Joins are the most fundamental concepts in SQL and having a clear understanding of Joins is very essential to write good SQL queries.

🧵
Topics -

✅What are JOINS in SQL
✅Inner Joins in SQL
✅Left Join in SQL
✅Right Join in SQL

✅FULL OUTER JOIN in SQL
✅ CROSS JOIN in SQL
✅ NATURAL JOIN in SQL
✅ SELF JOIN in SQL

📍Guys Please Connect on Linkedin For More Data Analyst Content

linkedin.com/in/sachintukum…

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Sachin Kumar

Sachin Kumar Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Sachintukumar

Mar 14
25 Advanced SQL Interview Questions for Data Scientists

🧵
Check out this collection of advanced SQL interview questions with answers.

kdnuggets.com/2022/10/25-adv…
Guys Check My Github Profile for Data Analyst Content

github.com/sachinkumar160…
Read 5 tweets
Mar 12
Top 25 SQL Interview Questions and Answers

🧵
There are certain SQL concepts which you should be familiar with if you plan to attend an #SQL interview. No matter which RDBMS you use wether it is MySQL, Oracle, Microsoft SQL Server, #PostgreSQL or any other, these SQL concepts are common for all of the popular RDBMS.
Read 5 tweets
Mar 12
Are you a wine enthusiast? If you are, then you’ve probably heard of Wine Magazine.

🔥Let us solve one of the Advanced SQL interview questions on RANK function.

🧵
❓ Question is taken from Wine Magazine that involves clauses like PARTITION BY, UNION ALL, CASE statements, and Window functions.

We will use a 3-step framework to solve the problem that can be used to solve any coding problem.
Find the cheapest and the most expensive variety in each region. Output the region along with the corresponding most expensive and the cheapest variety. Be aware that there are 2 region columns, the price from that row applies to both of them.
Read 6 tweets
Mar 10
How should you 𝐥𝐞𝐚𝐫𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈? 🚀

🧵
It's easy to be overwhelmed by how broad #PowerBI is😖

If you're starting out, here's the path I recommend⏬
📊 𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠
Begin by learning to organize data into tables, create relationships, and add calculated columns and measures.

This is the most important part of your journey, as understanding the #data is always the first step in Power BI development.
Read 13 tweets
Mar 10
▶️Practice Writing SQL Queries using Real
Dataset 💯

🧵
“The very first thing, we must do when writing #SQL queries, is to understand the underlying data. Once we understand the data and how this data is stored across different tables, it becomes much simpler to write SQL #Queries to retrieve any information from that data”
✅List of SQL Queries:

We shall write SQL #Queries using this data. For each of these queries, you would find the problem statement and then the screen shot of the expected output. Under each of these 20 problem statement
Read 9 tweets
Mar 8
👨‍💻 10 different ways to remove duplicate records in SQL

🧵
1 - Delete using Unique Identifier.
2 - Using SELF join.
3 - Using Window function.
4 - Using MIN function. This delete even multiple duplicate records.
5 - Using backup table.
6 - Using backup table without dropping the original table.
7 - Delete using CTID.
8 - By creating a temporary unique id column.
Read 4 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(