Session 34 - SQL Joins| DSMP 2023

Session 34 - SQL Joins| DSMP 2023
-------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------
| Time stamp |
-----------------------
00:00 Start
3:37 Session Star - Joins
6:14 What are SQL joins
7:10 But why have data in multiple tables?
16:36 Doubts
16:56 Types of Joins
18:16 Cross Joins --- Cartesian Products
24:00 Inner Joins
31:45 Doubt
39:45 Right Joins
32:15 Left Joins
46:40 Full Outer Join
51:08 Doubts
52:52 SQL Hands-on on Joins
1:04:36 Doubts
1:07:25 Set Operations
1:10:37 Set Operations Hands-on
1:16:32 Doubts
1:17:32 Self Join
1:21:09 Self Join Hands-on
1:24:37 Doubts
1:25:55 Query Execution Order
1:30:30 Joining on more than one col
1:36:23 Joining more than 2 tables - Find order name and corresponding category name
Filtering Columns
1:46:27 1. Find order_id, name, and city by joining users and orders.
1:49:30 2. Find order_id, and product category by joining order_details and category
Filtering Rows
1:51:14 1. Find all the orders placed in Pune
2. Find all orders under the Chairs category

Practice Questions
1:53:57 Find all profitable orders
1:58:10 Find the customer who has placed the max number of orders
2:00:20 Which is the most profitable category
2:02:34 Which is the most profitable state
2:05:27 Find all categories with profits higher than 5000
2:06:40 End Session Doubts
#datanalytics #Database #DBMS #SQL #DML #sqlgroupby #groupby

[shreyaverma]

Thankyou for such an amazing session. Really grateful

[shivaaryaprakash]

Thank you so much for such a great explanation. Most important part is animation, it develops an understanding on joining.
If ER diagram for flipkart data would be used then it were better

[neerajrana]

Fred Jumps With Great Happiness Seeing Ducks Outside...To remember sequence of execution

[rithikahuja]

Sir thank you soo sooo sooo much...These sessions are helping me a lot in building my SQL knowledge really well💟💟

[vineetkarmakar]

Sir believe me you're the one jisse mujhe pehli baar Joins conceptually samajh aya hai , Other youtubers just show some premade slides and narrate sql like it's history Thankyou sir!! Becuase of this beatiful course I am considering buying your full data science course But I am not sure that what is for me data science or data analyst

[adityamishra]

Maja aya, aur ye maja mae bharat ke hur nagrik do dena chata hun

[rsk]

A SQL query goes into a bar, walks up to two tables and asks, “Can I join you?”

[nikhilumredkar]

HOW TO UPLOAD DATASET USING PYTHON IN MYSQLWORKBEANCH PLEASE TELL ME

[ANUVJAIN-vlgt]

SIR i think time stamps galat hay is video ka, pichle video kahi dikha raha hay

[tanmayshinde]

UNION: This operation combines the results of two queries into a single result set. To use UNION, the following conditions must be met:
Both queries must have the same number of columns.
The data types of the corresponding columns in the two queries must be compatible.
By default, duplicate rows are removed from the result set. To include duplicates, you can use UNION ALL.

INTERSECT: This operation returns only the rows that are common to both result sets of the two queries. To use INTERSECT, the following conditions must be met:
Both queries must have the same number of columns.
The data types of the corresponding columns in the two queries must be compatible.

EXCEPT (or MINUS): This operation returns only the rows that appear in the first query but not in the second query. To use EXCEPT, the following conditions must be met:
Both queries must have the same number of columns.
The data types of the corresponding columns in the two queries must be compatible.

[sandeepvarma]

bhai kya hum ye website pe apne query ko animate kar sakte hai agar nahi toh koi website suggest kardo jaha pe hum apne query ko is tarah animation ke through samajh sakte hai

[ankitsaurabh_]

I am not getting EXCEPT and INTERSECT in my MySql Workbench.

[gouravsinha]

Hey. Around 2:10:00 you have selected name to group by to check the customer who had the highest orders but I can see that there are many customers with same name, so can we not just use user_id to see the check the users with highest number of orders?

[Udit-iwjz]

sir jo hamne infinityq wale pe inner join use kiya usme sirf model kyu aaaya baaki info kyu ni aaai..!?

[MdImran-rxol]

sir please DL ki playlist complete krdo....plzzz sir

[princeprasad]

Sir at 1:59:04 we can't perform group by on name as multiple person can have same name so group by should be done on user_id I think... And here in your case there are probably 5 person with name Shreya in users

[pawannawade]

How much fees to buy to complete data science mentorship program?