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