CampusX Data Science Mentorship Program 2022-23 - Session 34 - SQL Joins| DSMP 2023

Session 34 - SQL Joins| DSMP 2023 ------------------------------------------------------------------------------------------------------------------------------------------------------- Enroll in this Programme from our Website - https://learnwith.campusx.in/ Course Website Link - https://campusx1040.graphy.com/s/preview/courses/CampusX-Data-Science-Mentorship-Program#6376dbd8e4b065a4cadac4db YouTube Playlist - https://www.youtube.com/playlist?list=PLKnIA16_RmvbAlyx4_rdtR66B7EHX5k3z ------------------------------------------------------------------------------------------------------------------------------------------------------- Task link: Link: https://colab.research.google.com/drive/1-3zL_hgjuHrfhjpC1cfPA8b7swvAzXbc?usp=sharing ------------------------------------------------------------------------------------------------------------------------------------------------------- Dataset Link - https://drive.google.com/drive/folders/1RAo7rKbbnzt5Zrek1sq1pb3OJ7-IbQ5f?usp=share_link ------------------------------------------------------------------------------------------------------------------------------------------------------- SQL Operators - https://drive.google.com/file/d/13Cu0VUqbENcUX76bx_aoBS0EAtzDPDrE/view?usp=share_link InfyTQ ANimation Course Link -https://infytq.onwingspan.com/web/en/app/toc/lex_auth_01275806667282022456_shared/overview ------------------------------------------------------------------------------------------------------------------------------------------------------- PDF Notes for this session - https://drive.google.com/file/d/17K-6H-Vpgc2PGO547tHX9-fTyHluq8DH/view?usp=share_link ----------------------- | 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