SQL Functions Easily ExplainedCovered in this article — NULLIF, ISNULL, COALESCE, STRING_AGG, DATENAME, DATEPART, ROW_NUMBER, RANK, LEAD, LAGOct 8, 2022Oct 8, 2022
An easy guide to SQL Window Functions FramingIn this article, I have talked about the ORDER BY clause and framing concepts used in SQL Window Functions and solved 3 Leetcode questions.Sep 29, 20221Sep 29, 20221
3 important Leetcode SQL questions (Level: medium) I solved — Part IAfter solving almost all easy Leetcode problems, I dived deeper into applying logical thinking to solve SQL queries by tackling medium…Sep 27, 2022Sep 27, 2022
3 important Leetcode SQL questions (Level: easy) I solved — Part IIThis is in continuation with the previous article I posted about solving Leetcode easy-level questions. This post will cover questions…Sep 23, 2022Sep 23, 2022
3 important Leetcode SQL questions (Level: easy) I solvedSQL is fundamental to any person getting involved in the analytics field. It has been a part of our lives for 50+ years and it is not…Sep 21, 2022Sep 21, 2022
Credit Card Fraud Detection (ML using PySpark)Using classification algorithms to make a robust credit card fraud detection systemDec 28, 2021Dec 28, 2021
