Session 35 - Subqueries in SQL | DSMP 2023

Published: 01 January 1970
on channel: CampusX

44,117

910

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 Progr...
-------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------
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

Watch video Session 35 - Subqueries in SQL | DSMP 2023 online without registration, duration hours minute second in high quality. This video was added by user CampusX 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 44,11 once and liked it 91 people.