161,460 views
★ Reflecting the 2024 revision ★ Some of the 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 additionally) ★ 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 revisions will be released on YouTube on July 8. Since these are typos corrected and some content added, if you have the existing textbook and the new textbook, you can take the lecture with the existing video and study only the parts that will be added later :) ★ Summary of each chapter ★ 00:00 Intro 00:07 PART1. Understanding Data Model 10:16 PART2. Entity 17:43 PART3. Attributes 26:04 PART4. Relationships 32:21 PART5. Identifiers 41:29 PART6. Normalization 54:31 PART7. Understanding Relationships and Joins 1:01:13 PART8. Understanding Transactions Represented by Models 1:04:19 PART9. Understanding Null Attributes 1:09:18 PART10. Essential Identifiers vs. Artificial Identifiers