InLearning SQLbyFurcy PinWriting SQL Like A Pro: Advanced Techniques Showcased in a Real-Life ScenarioMerging two history tables using advanced SQL techniques with Google’s BigQuery.Mar 5, 20249Mar 5, 20249
InDev GeniusbyAmit Singh RathoreDuplicates in SQLAll you need to know for handling duplicates in SQL.Aug 8, 20222Aug 8, 20222
Joao Marques @ Data Beyond LtdSQL Like a Pro: Window FunctionsYou probably use window functions already… but have you taken them this far?Feb 7, 20221Feb 7, 20221
Ergest XheblatiAn Introduction to SQL Design Patterns and Best PracticesNote: This post has now been turned into a book. You can get EPUB and PDF versions on Gumroad or get the Kindle version on AmazonJan 13, 20226Jan 13, 20226
InTDS ArchivebyKhuyen TranFugue and DuckDB: Fast SQL Code in PythonOptimize Your SQL Code with Python and DuckDBMar 7, 20221Mar 7, 20221
InCodeXbyNaser TamimiHow to Understand Long and Complex SQL QueriesA “peel-and-understand-the-layer” strategy for complex SQL queriesFeb 2, 20223Feb 2, 20223
InTowards DevbyDakai ZhouUseful Database/SQL Tricks for Data EngineeringWriting SQL statements is part of the daily routine for data analysts, data engineers, and many data scientists. Here are some SQL tricks…Feb 22, 20223Feb 22, 20223
InBetter ProgrammingbyRoman Orac5 Common Mistakes Developers Make When Writing SQL QueriesFor each mistake, there’s a proper solutionJul 9, 2021Jul 9, 2021
InTDS ArchivebyDavid Martins10 Best Practices to Write Readable and Maintainable SQL CodeHow to write SQL queries that your team can easily read and maintain?Jul 31, 20218Jul 31, 20218
Joao Marques @ Data Beyond LtdSQL Like a Pro: How to Write a “For Loop” in SQLThat mind blowing moment when someone just totally changes your understanding of how SQL worksDec 1, 2021Dec 1, 2021
InLevel Up CodingbyNitesh ChaudhryAdvanced SQL for Data ProfessionalsHow do you move beyond SELECT , WHERE , GROUP BY Queries ? How to solve SQL questions asked in FAANG interviews ?Sep 5, 20212Sep 5, 20212
InJavarevisitedbyjavinpaul10 Best Places to Learn SQL Online for FREEThese are my favorite websites to learn SQL Query and Database fundamentals online it includes SQLZoo, SQLBolt, Khan Academy and UdemyAug 26, 20215Aug 26, 20215
