CampusX Data Science Mentorship Program 2022-23 - Session 35 - Subqueries in SQL | DSMP 2023

Session 35 - Subqueries in SQL | DSMP 2023 ------------------------------------------------------------------------------------------------------------------------------------------------------- Task link: https://colab.research.google.com/drive/1JbiCsNyrzALW_fCC-8VNPhlN2PJRN3Ks?usp=sharing ------------------------------------------------------------------------------------------------------------------------------------------------------- Dataset Link - https://drive.google.com/drive/folders/1xCNbO_LJIkr7bi9YDa7hUFYgJ-IZ01A-?usp=share_link ------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------- 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 -------------------------------------------------------------------------------------------------------------------------------------------------------- This session's PDF: https://drive.google.com/file/d/11efqFezqmghTq3wvbPkTFUDHUBcG-SSF/view?usp=share_link ----------------------- | Time stamp | ----------------------- *Session Start* 00:00:00 - Session Start 00:03:43 - Agenda of this session *Subquery* 00:05:35 - What is Subquery? 00:07:48 - Practical Example of Subquery 00:13:52 - Types of Subquery 00:20:15 - Where can subquery be used? 00:22:29 - Doubt clearance *Independent subquery - Scalar Subquery* 00:24:10 - Details 00:24:53 - Example #1 00:32:25 - Example #2 00:34:26 - Example #3 00:36:13 - Example #4 *Independent subquery - Row Subquery* 00:41:17 - Details 00:43:28 - Example #1 00:46:35 - Example #2 00:52:54 - Example #3 00:57:46 - Doubt clearance *Independent subquery - Table Subquery* 01:01:11 - Details 01:01:38 - Example #1 01:06:41 - Example #2 01:10:47 - Example #3 01:16:08 - Doubt Clearance *Correlated Subquery* 01:17:37 - Details 01:18:26 - Example #1 01:27:59 - Example #2 01:38:06 - Doubt clearance *Usage with SELECT* 01:39:36 - Details 01:40:21 - Example #1 01:43:40 - Example #2 *Usage with FROM* 01:47:05 - Example #1 *Usage with HAVING* 01:51:25 - Example #1 *Subquery in INSERT* 01:56:20 - Example #1 *Subquery in UPDATE* 02:01:40 - Example #1 (Get the query at the last section of this session) *Subquery in DELETE* 02:08:32 - Example #1 *Doubt clearance* 02:11:45 - Doubt clearance 02:12:32 - Subquery in UPDATE (Resolved) 02:15:24 - Doubt clearance ------------------------------------------------------------------------------------------------------------------------------------------------ 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