PinnedPublished inCode Like A GirlUnsurpassed Filtering Clauses: WHERE and HAVING in SQLSQL Simplified: Understanding WHERE and HAVING ClausesNov 21, 2024Nov 21, 2024
PinnedPublished inCode Like A GirlFIRST_VALUE and LAST_VALUE in SQL: Capturing the Start and End Points of Your Data JourneyYou can still enjoy the full article for free if you're not a Medium member. Click here to read it all😊Aug 28, 20242Aug 28, 20242
PinnedPublished inCode Like A GirlSQL Essentials: RANK or DENSE_RANK? That’s the questionIf you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊Jul 10, 20243Jul 10, 20243
PinnedPublished inCode Like A GirlSQL Essentials: GROUP BY vs. PARTITION BY explainedIf you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊Jun 26, 202416Jun 26, 202416
PinnedPublished inCode Like A GirlSQL Window Functions: The Ultimate Tool for Data EnthusiastsVast amounts of data — this is what we’re dealing with nowadays. Along with this main challenge comes the complexity of various sources…Jun 13, 20245Jun 13, 20245
Published inCode Like A GirlThe Mystery Behind the Curtains: How SQL Processes Clauses in Your QueriesAs a beginner, it’s essential to have a good understanding of all steps in your learning journey. Skipping the fundamentals can leave gaps…Dec 5, 20241Dec 5, 20241
Published inCode Like A GirlAvoid the Oops: DELETE and TRUNCATE Made EasyMastering Data Management Without Losing Your MindOct 18, 20249Oct 18, 20249
Published inCode Like A GirlThe Mystery of NULL Values: Why They Matter and How to Tackle ThemIf you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all😊Sep 23, 20242Sep 23, 20242
Published inCode Like A GirlLAG and LEAD in SQL: Mastering Time Travel for Better Data InsightsIf you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all😊Aug 15, 20249Aug 15, 20249
Mastering SQL CASE Statements: A Comprehensive OverviewIn the world of data, CASEstatements are essential tools for handling complex conditions. Comparable to the IF-ELSE logic in other…Jul 27, 20241Jul 27, 20241
