PinnedEason Liaw Yi XianinTowards Data ScienceThe Misconception of Views in SQLA well-hidden disguise of tables in SQL that not everyone is aware ofNov 24, 2021Nov 24, 2021
PinnedEason Liaw Yi XianinTowards Data ScienceThe Enemy of Database normalization — Grouping Values into Single String with SQLTaking data concatenation in SQL to the next levelNov 11, 2021Nov 11, 2021
PinnedEason Liaw Yi XianinSelectFromSelf-Referencing with Joins in SQL— Are There Better Alternatives?The Evolution and Complexity of Self-referencing in ProgrammingOct 31, 2021Oct 31, 2021
PinnedEason Liaw Yi XianinSelectFromSQL Performance of Window Functions vs Subqueries on Big DataUse of Window Functions for Better Query Performance ImprovementOct 22, 20211Oct 22, 20211
PinnedEason Liaw Yi XianLearning SQL for Data Science from a self-learning perspectiveMy journey of learning SQL for Data ScienceOct 14, 2021Oct 14, 2021