6 Lesser-Known SQL Techniques to Save You 100 Hours a Month

Use these simple techniques to make your analysis and data extracts easier

Cameron Warren
Towards Data Science
6 min readJan 15, 2022

--

Over an eight-year data career, I’ve relied on a few simple, yet lesser-known SQL techniques to save myself countless hours performing analysis and building ETL pipelines.

In this article, I’ll share six that come up over and over again:

Finding and deleting duplicate records from a table

--

--

Writing about how teams and individuals can more effectively use data. Follow me: @camwarrenm