SQL Anti-Patterns You Should Avoid
Introduction
Today, I will be talking about some of the common and high impact SQL anti-patterns I have seen from experience that can make queries and pipelines diff...
Similar Articles (10 found)
🔍 67.4% similar
Advanced SQL is knowing how to model the data & get there effectively
- 1. Introduction
- 2. SQL techniques
- 3. Query optimization
- 4. Data modeling...
🔍 62.7% similar
How to turn a 1000-line messy SQL into a modular, & easy-to-maintain data pipeline?
1. Introduction
If you’ve been in the data space long enough, you ...
🔍 60.9% similar
You’ve done it!
You’ve built your first data pipeline. Maybe you’re a junior data engineer. Maybe you’re a data analyst shipping your first pipeline i...
🔍 60.3% similar
How to improve at SQL as a data engineer
- 1. Introduction
- 2. SQL skills
- 3. Practice
- 4. Conclusion
- 5. Further reading
- 6. References
1. Intro...
🔍 59.5% similar
Hi, fellow future and current Data Leaders; Ben here 👋
I recently was skimming the data engineering subreddit and came across a post with a title that...
🔍 59.5% similar
Over the past year, I’ve been writing about several back-to-the-basics topics, like extracting data via APIs and SFTP, and building solid data models....
🔍 59.4% similar
You don't know SQL. Aside from basic CRUD statements, you haven't used any advanced database features. This free ebook will share many recipes to make...
🔍 59.3% similar
Data Engineering Interview Preparation Series #3: SQL
- 1. Introduction
- 2. Step-by-step process to solve any SQL interview question
- 3. Lead the co...
🔍 59.1% similar
How to reduce your Snowflake cost
- 1. Introduction
- 2. Snowflake pricing and settings inheritance model
- 3. Strategies to reduce Snowflake cost
- 4...
🔍 59.1% similar
5 Things in Data Engineering That Still Hold True After 10 Years
Why core challenges in data engineering resist the test of time
Hi, fellow future and...