Member-only story
Advanced SQL techniques for beginners
On a scale from 1 to 10 how good are your data warehousing skills?
On a scale from 1 to 10 how good are your data warehousing skills? Want to go above 7/10? This article is for you.
Want to get ready for a data analyst job interview asap? This blog post explains some intricate data warehouse SQL techniques in detail. I will use BigQuery standard SQL dialect to scribble down a few thoughts on this topic.
2024 update: I decided to update this story with new code examples. You can find new fuzzy matching, approximate joins and equality SQL code snippets in the end of the article.
1. Incremental tables and MERGE
Updating table effectively in the right way is important. It is important indeed. Ideal situation is when you have transactions that are a PRIMARY key, unique integers and auto increment. Table update in this case is simple:
