25 SQL tips to level up your data engineering skills
- Introduction
- Setup
- SQL tips
- 1. Handy functions for common data processing scenarios
- 1.1. Need to filter on WINDOW function without CTE/Su...
Similar Articles (10 found)
🔍 75.3% similar
How to use nested data types effectively in SQL
- 1. Introduction
- 2. Code & Data
- 3. Using nested data types effectively
- 4. Conclusion
- 5. Conti...
🔍 64.0% similar
How to quickly deliver data to business users? #1. Adv Data types & Schema evolution
- 1. Introduction
- 2. Use Schema evolution & advanced data types...
🔍 60.2% similar
What Does It Mean for a Column to Be Indexed
When optimizing queries on a database table, most developers tend to just create an index on the field to...
🔍 60.1% similar
How to build a data project with step-by-step instructions
- 1. Introduction
- 2. Setup
- 3. Parts of data engineering
- 3.1. Requirements
- 3.2. Iden...
🔍 59.8% 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.0% similar
Using Joins and Group Bys the right way for data warehousing
- 1. Introduction
- 2. Joins & Group bys are two of the most commonly used operations in ...
🔍 58.0% similar
Data Engineering Best Practices - #1. Data flow & Code
- 1. Introduction
- 2. Sample project
- 3. Best practices
- 3.1. Use standard patterns that pro...
🔍 57.9% similar
6 Key Concepts, to Master Window Functions
- Introduction
- Prerequisites
- 6 Key Concepts
- Efficiency Considerations
- Conclusion
- Further reading
...
🔍 57.3% similar
Advanced SQL is knowing how to model the data & get there effectively
- 1. Introduction
- 2. SQL techniques
- 3. Query optimization
- 4. Data modeling...
🔍 57.1% similar
What are Common Table Expressions(CTEs) and when to use them?
- Introduction
- Setup
- Common Table Expressions (CTEs)
- Performance comparison
- Tear...