PinnedLuchiana DumitrescuinCode Like A GirlSQL Essentials: GROUP BY vs. PARTITION BY explainedWhen I first stepped into the world of data, I was a college student captivated by the simplicity of SQL. The language seemed…Jun 266Jun 266
PinnedLuchiana DumitrescuinCode 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. In…Jun 133Jun 133
PinnedLuchiana DumitrescuinCode Like A GirlAdvanced Data Manipulation in PL/SQL: Harnessing the Power of REGEXData manipulation is a crucial process that involves adapting the strings in your dataset to meet your specific requirements. Regular…May 27May 27
PinnedLuchiana DumitrescuinWomen in TechnologyMaximizing SQL Performance: Choosing Between Cursors and While LoopsNowadays we deal with processing large amounts of data in SQL, which brings us another challenge in the world of data; overcoming the…May 8, 20231May 8, 20231
Luchiana DumitrescuFrom Complex Queries to Elegant Solutions: Exploring CTEs in SQLAt least once in our life, we’ve all experienced the frustration that comes when you have to deal with someone else’s code. At first…Apr 30Apr 30
Luchiana DumitrescuinCode Like A GirlHarnessing the Magic of PIVOTA Real-world Example in Financial ManagementMar 26Mar 26
Luchiana DumitrescuMaximizing SQL Power: Improving Large Query PerformanceIn today’s digital landscape, information is the currency that fuels progress, and the relentless pursuit of speed has become a defining…Mar 13Mar 13
Luchiana DumitrescuinCode Like A GirlA SQL Data Cleaning Odyssey: Unveiling the Crimes of LAThe world of data analytics is no stranger to most of us. It's a constantly evolving field where Python has become a popular tool for data…Feb 28Feb 28
Luchiana DumitrescuinCode Like A GirlMastering SQL Data Quality: Exploring NULL Values with a Custom SSMS Stored ProcedureData cleaning, the perpetual nemesis in our dreams, relentlessly haunts the data realm, affording us no respite. Like an unyielding shadow…Feb 12Feb 12
Luchiana DumitrescuinCode Like A GirlAudible Data Cleaning: A Python Approach to Silencing NoiseReducing noise in a dataset is the main aspiration of every data enthusiast. The journey from a raw, unpolished dataset to a clean and…Feb 4Feb 4