Introduction to ANSI SQL - Understanding the Syntax and Concepts
An introduction to ANSI SQL, covering its standardized syntax, key concepts like DDL, DML, joins, CTEs, and its importance for database interoperability.
Alex Merced — Developer and technical writer sharing in-depth insights on data engineering, Apache Iceberg, data lakehouse architectures, Python tooling, and modern analytics platforms, with a strong focus on practical, hands-on learning.
333 articles from this blog
An introduction to ANSI SQL, covering its standardized syntax, key concepts like DDL, DML, joins, CTEs, and its importance for database interoperability.
Explains how ontologies structure data for better interoperability, integration, and analysis across domains like healthcare and finance.
An introductory guide to Python programming covering installation, syntax, data structures, and best practices for beginners.
A comprehensive guide to mastering the essential Git commands 'git pull' and 'git push', covering their anatomy, options, and best practices.
Explains the data lakehouse architecture and the roles of Apache Iceberg, Nessie, and Dremio in modern data management.
Compares partitioning techniques in Apache Hive and Apache Iceberg, highlighting Iceberg's advantages for query performance and data management.
A comprehensive guide to JavaScript Promises, covering basics, error handling, advanced methods like Promise.all(), and real-world use cases.
Compares columnar vs. row-based data structures, explaining their optimal use in OLAP and OLTP systems for performance and scalability.
An introduction to Data Vault modeling, a flexible data warehouse design method using Hubs, Links, and Satellites for scalable data integration.
Table of Contents Context Introduction Short Version for Quick Readers My Journey with Table Formats and Lakehouses Ecosystem Over Features Key Takeaw
Explores the Data Lakehouse architecture and the roles of Apache Iceberg and Dremio in modern, integrated data management.
A comprehensive directory of resources for learning about and building Open Lakehouses using Apache Iceberg, Nessie, and Dremio.
Introduces Nessie as a self-managed catalog alternative to Hive & JDBC for Apache Iceberg, addressing limitations and new features.
A no-code tutorial on converting XLS/CSV files to Parquet format using Dremio, including setup via Docker.
An introduction to HTMX, a modern library for building dynamic web interfaces using HTML with minimal JavaScript, and how to use it.
Explores how Dremio's platform simplifies building and managing Apache Iceberg-based data lakehouses with governance, performance, and self-service.
A comprehensive guide to implementing Object-Oriented Programming (OOP) design patterns in JavaScript, covering creational, structural, and behavioral patterns.
Explores Apache Iceberg and Project Nessie, key open-source technologies powering the flexible and vendor-neutral Open Lakehouse data architecture.
A guide on learning software development effectively, covering language choice, early practice with simple challenges, and building a todo app.
A step-by-step tutorial on building a JSON API using Java Spring Boot, Maven, and PostgreSQL.