Thuwarakesh MurallieinTowards Data ScienceThese 5 SQL Techniques Cover ~80% of Real-Life ProjectsSpeed up your SQL learning curve.Mar 8, 20234Mar 8, 20234
Axel Thevenot 🐣inGoogle Cloud - CommunityDeduplication in BigQuery Tables: A Comparative Study of 7 ApproachesAnalyzing and comparing 7 ways of deduplicating rows in a BigQuery table.Dec 14, 20227Dec 14, 20227
💡Mike ShakhomirovinTowards Data ScienceAdvanced SQL techniques for beginnersOn a scale from 1 to 10 how good are your data warehousing skills?Nov 30, 20223Nov 30, 20223
Andreas MartinsoninLearning SQLUnderstanding the SQL EXISTS ClauseAnd when you should think about using itSep 12, 20221Sep 12, 20221
Alejandro Zielinsky GaglioneQuerying GA4 event parameters in BigQuery in an easier and cleaner wayTo avoid messy and unreadable code, creating a Bigquery SQL persistent function is quite handy and can be your default method to get a…Sep 9, 2022Sep 9, 2022
Josh BerryinLearning SQLThe 5 Hardest Things to Do in SQLWith realistic examplesAug 25, 202215Aug 25, 202215
Andreas MartinsoninTowards Data ScienceYou Should Use This to Visualize SQL Joins Instead of Venn DiagramsVenn diagrams are so last yearApr 3, 202212Apr 3, 202212
Andreas MartinsoninTowards Data Science10 Quick SQL Tips After Writing Daily in SQL for 3 YearsThese tips address common SQL problems you will encounter as a data professionalMar 7, 202212Mar 7, 202212
Madison SchottinTowards Data ScienceHow to Use These 6 Unusual SQL FunctionsKeep these in your toolbox and you’ll be ready to solve the hardest problemsDec 20, 20215Dec 20, 20215
Cameron WarreninTowards Data Science6 Lesser-Known SQL Techniques to Save You 100 Hours a MonthUse these simple techniques to make your analysis and data extracts easierJan 15, 20225Jan 15, 20225
Aashish NairinBetter ProgrammingExplore Data Wrangling With SQLLeveraging SQL to clean your raw dataOct 4, 20211Oct 4, 20211
Cait MackinCodeXHow to Teach Yourself to be a Data Analyst in 63 HoursUPenn would charge you 13k for this info.Jun 2, 20211Jun 2, 20211
Soner YıldırıminTowards Data ScienceAnalyzing 120 Years of Olympics History with SQLHands-on SQL tutorialSep 21, 20211Sep 21, 20211
Sara A. MetwalliinTowards Data Science5 Games That Can Help You Improve Your Skills As a Data ScientistImprove your skills and have fun at the same time.Sep 19, 20212Sep 19, 20212
Moosa AliinAnalytics Vidhya5 Data Processing Techniques for Data Science BeginnersA beginners guide to processing data in python using the pandas framework.Sep 9, 2021Sep 9, 2021
Data Engineering Academy5 SQL queries every Data Engineer & Scientist should know!Over the years, I’ve worked on dozens of data engineering projects and these 5 queries have queries have gotten me out of few jams! Hope…Mar 13, 20213Mar 13, 20213
Terence Shin, MSc, MBAinTowards Data ScienceTop Five SQL Window Functions You Should Know For Data Science InterviewsFocusing on the important concepts for data scientists.Jul 7, 202110Jul 7, 202110