Session 35 - Subqueries in SQL | DSMP 2023 скачать в хорошем качестве

Session 35 - Subqueries in SQL | DSMP 2023

Session 35 - Subqueries in SQL | DSMP 2023 ------------------------------------------------------------------------------------------------------------------------------------------------------- Task link: https://colab.research.google.com/dri... ------------------------------------------------------------------------------------------------------------------------------------------------------- Dataset Link - https://drive.google.com/drive/folder... ------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------- Enroll in this Programme from our Website - https://learnwith.campusx.in/ Course Website Link - https://campusx1040.graphy.com/s/prev... YouTube Playlist -    • CampusX Data Science Mentorship Program 20...   ------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------- SQL Operators - https://drive.google.com/file/d/13Cu0... InfyTQ ANimation Course Link -https://infytq.onwingspan.com/web/en/... -------------------------------------------------------------------------------------------------------------------------------------------------------- This session's PDF: https://drive.google.com/file/d/11efq... ----------------------- | 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