How to improve at SQL as a data engineer
- 1. Introduction
- 2. SQL skills
- 3. Practice
- 4. Conclusion
- 5. Further reading
- 6. References
1. Introduction
SQL is the bread and butter of data engine...
Similar Articles (10 found)
🔍 73.4% 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....
🔍 72.1% similar
How to quickly deliver data to business users? #1. Adv Data types & Schema evolution
- 1. Introduction
- 2. Use Schema evolution & advanced data types...
🔍 71.6% similar
6 Steps to Avoid Messy Data in Your Warehouse
- 1. Introduction
- 2. Six Steps for a Clean Data Warehouse
- 2.1. Understand the business
- 2.2. Make d...
🔍 71.0% similar
Data Engineering Interview Preparation Series #2: System Design
- 1. Introduction
- 2. Guide the interviewer through the process
- 2.1. [Requirements ...
🔍 70.6% similar
What is a Data Warehouse?
- 1. Introduction
- 2. Business requirements: dashboards and analytics
- 3. What is a data warehouse
- 4. OLTP vs OLAP based...
🔍 70.5% similar
How to reduce your Snowflake cost
- 1. Introduction
- 2. Snowflake pricing and settings inheritance model
- 3. Strategies to reduce Snowflake cost
- 4...
🔍 70.1% similar
Advanced SQL is knowing how to model the data & get there effectively
- 1. Introduction
- 2. SQL techniques
- 3. Query optimization
- 4. Data modeling...
🔍 69.6% 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...
🔍 69.3% 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 ...
🔍 69.3% similar
Data Engineering Best Practices - #1. Data flow & Code
- 1. Introduction
- 2. Sample project
- 3. Best practices
- 3.1. Use standard patterns that pro...