All 29 articles
- SQL Blunders: The Disastrous Approach of Ignoring Window Functions for Basic Aggregations
- Gaps and Islands in SQL
- Is Kimball's dimensional modeling approach still applicable in modern data warehousing?
- Single version of the truth
- Data Silos
- Variable Definition Precedence in Terraform
- Luhn Algorithm in Python
- Behind the Numbers: A Data Engineer's Take on Jadon Sancho's Football Journey
- What is Python List Comprehension?
- Python Exception Hierarchy
- Python Built-in Exceptions
- AWS vs. GCP vs. Azure: A Comprehensive List of Cloud Services
- DAG Runs
- Parallel Computation Frameworks in Data Engineering
- Data Engineer vs Data Scientist
- Python Cheatsheet: The Basics
- Numpy for Data Analysis: the Ultimate Guide
- Python Variable Naming Conventions
- Python Order of Arithmetic Operations
- Anatomy of an SQL Query
- Learn to Split a Dataset for Testing and Training Using SQL
- Learn to Generate Sample Data Using SQL
- Learn to Generate Random Data Using SQL
- Learn to Generate Data Using SQL
- Python Libraries Every Data Engineer Should Know
- Machine Learning Model Cheatsheet
- Bigquery ML Models
- Bigquery ML Project Phases
- What Does a Typical Data Warehouse Solution Architecture Look Like?