PinnedPublished inCode Like A GirlUnsurpassed Filtering Clauses: WHERE and HAVING in SQLSQL Simplified: Understanding WHERE and HAVING ClausesNov 21, 202484Nov 21, 202484
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, 20242792Aug 28, 20242792
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, 20243313Jul 10, 20243313
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, 20241K15Jun 26, 20241K15
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, 20246615Jun 13, 20246615
Published inCode Like A GirlUNION vs. UNION ALL: The Guards of your combined SQL statementsYou’re not a Medium member? Enjoy the full article for free HERE 👈😊1d ago11d ago1
Published inCode Like A GirlSQL Data Types and Memory: Because Size Sometimes MattersYou’re not a Medium member? Enjoy the full article for free HERE 👈😊Mar 471Mar 471
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, 2024661Dec 5, 2024661
Published inCode Like A GirlAvoid the Oops: DELETE and TRUNCATE Made EasyMastering Data Management Without Losing Your MindOct 18, 20243659Oct 18, 20243659
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, 20242182Sep 23, 20242182