A review of resources to use in Big Data Engineering projects in Microsoft Azure Cloud — Microsoft Azure is a very powerfull platform for data projects. From data ingestion to processing and analytics, Azure provides an extensive set of resources designed to meet the diverse needs of data engineering projects. …

A small summary of what is and its benefit — Checkout my other medias I create content: ➡️ GitHub ➡️ My Data Courses (udemy) ➡️ Linkedin ➡️ Subscribe my Newsletter ➡️ Youtube Data partitioning is a database management technique that has gained significant popularity in recent years, thanks to its ability to improve performance, scalability, and maintenance of large datasets…

The Magic of CTEs and Subqueries in Database Queries — When it comes to databases and SQL queries, two powerful features often comes in mind when we need to tackle complex data manipulations: Common Table Expressions (CTEs) and subqueries. These gems of the database make our lives as developers a whole lot easier, but understanding when to use each and…

Google Cloud has emerged as a big player, offering a suite of robust tools and services to streamline the process of collecting, processing, and analyzing data. In this article I aim to explore the resources I used the most and were the best ones to use for the use cases…

Leverage built in features and software engineering practices and have your code recognized as good one. — I have been writing ideas on how to write better python code, and I have created 8 blog posts divided in 2 categories: Software Engineering and Python Efficiency. I believe all the points below are very important to advance you python skills to the next level, after you learn the…

Before starting the read, I also suggest checking out my recent ➡️ Youtube channel. Please, watch and subscribe. Snowflake Data Platform, a cloud-based data warehousing and analytics service that has quickly risen to prominence in the industry. Snowflake’s innovative approach to data management addresses the demands of the modern era…

In the ever-evolving world of data management, three key concepts have gained prominence: Data Warehouse, Data Lake, and the relatively new entrant, Data Lakehouse. Each of these approaches offers distinct advantages and serves different purposes in the data ecosystem. In this article, we will explore the concepts behind these three…

Amazon Web Services (AWS) provides a wide array of resources and services that empower data engineers to collect, store, process, and analyze data effectively. In this article, I will explore the most commonly used AWS resources for data engineering projects, their use cases, and how they can be combined to…

Data modeling is a very important aspect of database design and plays a crucial role in designing the structure of data for various analytical and operational needs. Two popular approaches in data modeling are the Third Normal Form (3NF) and Dimensional Data Modeling. These methods were created by different pioneers…