30,647 views
01. Introduction to database, entities, properties 02. Relationships 03. Identifiers, data models 04. Normalization, relationships and joins 05. Transactions, null, intrinsic vs. artificial expressed by the model 06. Overview of relational databases 07. Functions, WHERE 08. GROUP BY, HAVING, ORDER BY 09. Joins 10. Subqueries 11. Set operators, group functions, window functions 12. TOP-N, hierarchical queries 13. PIVOT and UNPIVOT, regular expressions 14. DML, TCL 15. DDL, DCL SQLD core theory lectures are provided to those who purchase the book [Selfish SQL Developer Theory Book + Past Questions]. You can watch episodes 7-15 after authenticating the book on the Selfish homepage. ???? View book details: https://www.yes24.com/Product/Goods/1... ???? Playlists that include this video: • SQL Developer Theory + Past Questions Lecture ???? Selfish Study Cafe: https://cafe.naver.com/yjbooks ???? Selfish Homepage: https://license.youngjin.com ???? Instagram: /license.youngjin_official