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 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
Смотрите видео Session 35 - Subqueries in SQL | DSMP 2023 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь CampusX 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 44,11 раз и оно понравилось 91 людям.