SQLD 2 subjects PART2. Complete summary of SQL usage (reflecting the new type in 2024)

75,204 views

홍쌤의 데이터랩

Published on Feb 20, 2024
About :

★ Reflecting the 2024 revision ★ Some SQLD contents have been added and changed in 2024. This video is a key summary lecture reflecting the 2024 revision. (Since many people found PART2 of Subject 2 difficult, we plan to produce and upload an easier lecture) ★ Plans to re-upload the video reflecting our own revision ★ The textbook distributed in the 1st and 2nd times in 2024 has been revised and re-published for a fee! You can purchase the textbook on the website below (total 155 pages) Website address: www.hdatalab.co.kr Video lectures reflecting the revision will be released on YouTube on July 8. This is a typo correction and some additional content, so if you have the existing textbook and the new textbook, you can watch the lecture with the existing video and then study only the additional parts separately:) ★ Chapter-by-chapter summary ★ 00:00 Intro 00:07 PART1. Subquery 15:55 PART2. Set operator 21:01 PART3. Group function 29:19 PART4. Window function 50:01 PART5. TOP N QUERY 57:11 PART6. Hierarchical query 1:07:38 PART7. PIVOT and UNPIVOT 1:21:01 PART8. Regular expression

  • vidoe Comments
Trend Videos
13:36
Hongsoyuk: The most popular pork belly dish in the world! I think this is better than Dongpoyuk. (Shanghai Authentic Recipe)
육식맨 YOOXICMAN
775,234 views   3 days ago
12:41
Jindo dog that was stuck in an apiary for 2 months returns to its original home
프응TV Honeybeefather
538,807 views   8 days ago
21:42
I'm going to take a break.
LeoJ Makeup
432,835 views   2 days ago
26:41
Reasons for not getting married. No, I can't... No, I won't...
걍밍경
1,102,980 views   7 days ago
5:15
Stir-fried pork
웃고리즘
828,430 views   3 days ago
2:29
[Minecraft Movie] 2nd trailer
Warner Bros. Korea
895,568 views   2 days ago
41:48
When cooking, panic. The first great step to conquering the kitchen. [Night Chef]
김풍천국
231,122 views   1 day ago
5:10
I got an email from YouTube regarding my subscriber count.
보겸s
678,639 views   2 days ago
17:57
What happens when you run 100km in 7 days
고재영
1,142,186 views   6 days ago
21:05
The most expensive country... the world's cheapest Michelin 1 star
잡재홍
294,203 views   3 days ago
21:43
[VLOG] Our family is very united‼ 2 days and 1 night in a quiet country life (with boyfriend's family)
지유롭게
186,688 views   3 days ago
40:41
[SUB] ※Essential knowledge for freshmen※ Surviving the drinking party [I didn't prepare anything] EP.34 #Lee Young-ji #Twice #TXT
차린건 쥐뿔도 없지만
3,371,084 views   6 days ago
25:19
Every word she says makes me nervous. Joo Byung Jin's second blind date full of excitement~ #highlight #CanILoveNow EP.2
tvN STORY 티비엔 스토리
2,310,537 views   10 days ago
7:01
I did well on the CSAT (Myrin, a high school senior, shares her story on the 2025 CSAT) Myrin TV
마이린 TV
482,615 views   6 days ago
11:44
HAON - Skrr (feat. GISELLE of aespa) [Official KCam] ENG/KOR
KC 케이씨
415,073 views   1 day ago
2:27
MEOVV(민야오) 'BODY' (4K) STUDIO CHOOM ORIGINAL
STUDIO CHOOM [스튜디오 춤]
1,735,272 views   2 days ago
30:55
[Eating Vlog #105] Salppejo is actually a famous noodle artist🍲 A collection of noodle mukbangs perfect for binge-watching on a cold day😋♨️
살빼조DietJo
178,134 views   1 day ago
8:45
Understanding the intention of the questioner
너덜트
2,154,382 views   7 days ago
14:56
🐺 : You... are you an imposter? 🐐 : Get to work Old SKT Association feat. Jiseon, Gumayushi Lockdown Protocol
울프 이재완
536,709 views   5 days ago
3:15
MEOVV - 'TOXIC' M/V
THEBLACKLABEL
8,898,383 views   3 days ago
3:31
JAESSBEE - 'All Now with You' Official MV
MMTG 문명특급
2,417,180 views   10 days ago
9:08
Signs of a awning
짧은대본 ShortPaper
564,118 views   5 days ago
21:38
Cheaper than home shopping! A chance to stock up on the cleanser that celebrities use! Kwanghee's [Discount Game 16][EN]
솔코 스테이지 SOLCHORD
539,815 views   1 day ago
23:49
🔥Love counseling is back and it's even hotter🌶️🔥 with Eunji from the Jongji couple
아옳이
420,236 views   2 days ago
5:15
Stir-fried pork
웃고리즘
828,430 views   3 days ago
21:42
I'm going to take a break.
LeoJ Makeup
432,835 views   2 days ago
28:34
[Ah-hyung Highlight] All below Seoul National University..?! Mi-mi-minu and Seo Jang-hoon arguing about affinity vs. high affinity - Triple S Kim Yoo-yeon from Ewha Womans University's one-shot at Seo Jang-hoon💥 Knowing Brothers JTBC 241116 broadcast
아는형님 Knowingbros
1,684,028 views   5 days ago
2:08
Hazard Tactics Hazard Hero Trailer Overwatch 2
오버워치
189,528 views   2 days ago
23:49
🔥Love counseling is back and it's even hotter🌶️🔥 with Eunji from the Jongji couple
아옳이
420,236 views   2 days ago
13:36
Hongsoyuk: The most popular pork belly dish in the world! I think this is better than Dongpoyuk. (Shanghai Authentic Recipe)
육식맨 YOOXICMAN
775,234 views   3 days ago
17:57
What happens when you run 100km in 7 days
고재영
1,142,186 views   6 days ago
33:00
Broken Taxi, Strange Taxi Driver and 2 Days & 1 Night - Tajikistan (3)
곽튜브
735,247 views   5 days ago
Google AdSense
336 x 280
Up Next
10:53
Emergency call 112 #20 New vehicle fleet and use of the TLF
Cpt.Cookie
7,818 views
1 year ago
11:37
Emergency call 112 #8 Carport fire in Broich: TLF is dispatched
Cpt.Cookie
24,920 views
2 years ago
23:12
Emergency services in action: shift starts! Emergency call 112 - The Fire Department Simulation 2
Kuschi
3,341 views
8 days ago
13:23
emergency number 112 in the Hanover region
Wolffgolf
74,480 views
5 years ago
27:58
🚨 Notruf 112 🚒 Chapter 3 Back to the fire service!
Blackwatero_0
474 views
11 days ago
17:38
Emergency call 112 #9 Apartment in full fire: ELW in action
Cpt.Cookie
11,517 views
2 years ago
10:28
SRBuncut. – On the road with the emergency doctor from Protection and Rescue Bern (Episode 1)
Schutz und Rettung Bern
15,161 views
1 month ago
9:03
LS 22 Small forest fire in Bregenz
Np Luca
794 views
10 days ago
9:44
Emergency Call 112 the Fire Department Simulation 2: Is it worth playing the game again?
Gaming-Island
361 views
6 days ago
32:12
LS25: Off to the forest: transporting wood with the VOLVO truck Country life #6 FARMING SIMULATOR 25
NPLAY
82,345 views
3 days ago
10:30
Emergency call 112 #16 Cat in a tree: DLK in action
Cpt.Cookie
15,317 views
2 years ago
24:50
Constantly on the go with major fires and MANV - EMERGENCY 5 LÜDENSCHEID #164
ducAnle
160 views
8 days ago
5:33
Discover the Error that causes your VEHICLE'S BATTERY to DRAIN!
Todo terreno
5 views
2 hours ago
22:10
BYD KING DM-I 2025 - It will be the best plug-in hybrid sedan in Mexico
Turbo Test
31,400 views
3 months ago
13:38
BUY MG5 or GEELY EMGRAND? WHICH ONE PAYS LESS INTEREST? - Financing Analysis
ErickAutosCAA / Conductores Al Azar
25,790 views
1 month ago
14:21
MG7 Premier. What does the ENTRY version offer? AUTOSIE7E
AUTOSIE7E
25,536 views
11 days ago
35:29
The 18 CHEAPEST Cars in MEXICO 2025 for Less than 300 Thousand Pesos
AutosMas
91,527 views
13 days ago
12:08
Nissan Kicks 2025 first dynamic test in Mexico
Automóvil Panamericano
6,359 views
11 days ago
6:57
THIS FORD SUV IS MADE IN CHINA. GOOD OR BAD?
ErickAutosCAA / Conductores Al Azar
2,452 views
12 days ago
32:36
ALL VERSIONS OF MG3
compowervlogs
14,608 views
2 weeks ago
26:00
MG5 2025 What a renovation!! They hit the nail on the head!!!
Un Papá Sobre Ruedas
7,551 views
7 days ago
11:13
What is a BMW X5 F15 3.0 DIESEL for about 20,000.00 euros?
YASmotor
1,908 views
3 hours ago
15:36
ARE MEXICO'S BEST-SELLING CARS RECOMMENDED? - Top / Analysis
ErickAutosCAA / Conductores Al Azar
9,126 views
4 days ago
19:05
🚧⚠️MG5 EXCITE INTERMEDIATE, WHAT DO YOU GET FOR $359,900? HERE IF WE SAY IT IS CHINESE
EL GARAGE
9,891 views
10 days ago
36:01
The 18 CHEAPEST PICKUPS in MEXICO 2025
AutosMas
35,846 views
5 days ago
5:08
Delivery of CUPRA LEON 300 MATE // This is what it's like to experience a CUPRA 🤟🏽🧡
ADN_Cupra
567 views
8 days ago
18:01
Now it's the cheapest! We drive Waldos' car! KIWO E-ZIP
El Mago de los Autos
1,144,614 views
6 months ago
12:42
BUY A CAR ON THE END? REAL DEALS? - Financing analysis
ErickAutosCAA / Conductores Al Azar
19,675 views
5 days ago
18:06
SHOCKING STATEMENTS by Franco Colapinto at the Las Vegas GP the most difficult
F1 Andrew
11,501 views
10 hours ago
Google AdSense
336 x 280

fetery.com. Copyright 2024