How to use nested data types effectively in SQL
- 1. Introduction
- 2. Code & Data
- 3. Using nested data types effectively
- 4. Conclusion
- 5. Continue reading
1. Introduction
If you have worked in ...
Similar Articles (10 found)
🔍 75.3% similar
25 SQL tips to level up your data engineering skills
- Introduction
- Setup
- SQL tips
- 1. Handy functions for common data processing scenarios
- 1.1...
🔍 66.5% similar
How to quickly deliver data to business users? #1. Adv Data types & Schema evolution
- 1. Introduction
- 2. Use Schema evolution & advanced data types...
🔍 59.2% 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 ...
🔍 56.7% 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...
🔍 56.6% similar
What is an Open Table Format? & Why to use one?
- 1. Introduction
- 2. What is an Open Table Format (OTF)
- 3. Why use an Open Table Format (OTF)
- 4....
🔍 56.4% 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...
🔍 56.3% similar
How to Join a fact and a type 2 dimension (SCD2) table
- Introduction
- What is an SCD2 table and why use it?
- Setup
- Joining fact and SCD2 tables
-...
🔍 56.1% 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...
🔍 55.3% 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...
🔍 54.7% similar
dbt(Data Build Tool) Tutorial
1. Introduction
If you are a student, analyst, engineer, or anyone in the data space and are curious about what dbt
is a...