86,041 views
★ 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 take the lecture with the existing video and then study only the additional parts separately:) ★ Chapter-by-chapter summary ★ 00:00 Intro 00:07 PART1. Overview of Relational Databases 11:02 PART2. SELECT Statement 24:18 PART3. Functions 49:14 PART4. WHERE Clause 59:24 PART5. GROUP BY Clause and HAVING Clause 1:07:12 PART6. ORDER BY Clause 1:10:42 PART7. Join 1:26:32 PART8. Standard Join