In this article I present and share the solution for a number of basic algorithms that recurrently appear in MAANG interviews — Suggested On-Demand Courses Many of you contacted me asking for valuable resources to nail Python coding interviews. Below I share 4 courses/platforms that I strongly recommend to keep exercising after practicing the algorithms in this post: Python Data Engineering Nanodegree→ High Quality Course If You Have More Time To Commit.

A brief introduction to Apache Kafka architecture. — Introduction At some point, in your career as a data engineer, you will naturally move beyond batch processing (that means querying bounded datasets) and familiarise with the tools used in stream processing. In stream processing, data is unbounded and may be incomplete at the time of a query. One of the…

Learn three methods to count objects through Python dictionaries. — Suggested On-Demand Courses: Are you trying to advance your career as a Data Professional? I would highly recommend for you to check the following courses: Data Engineering Nano-Degree → High Quality Course! Data Analyst Nano-Degree → High Quality Course! LeetCode In Python: 50 Algorithms Coding Interview Questions → Best For Coding Rounds Involving…

In this first tutorial on Apache Flink, learn how to import data into a table from a CSV source, using the Python Table API. — Suggested On-Demand Courses Do you wish to learn more about Apache Flink, Apache Spark and other data streaming technologies? These are some online courses taught in Python that would strongly recommend: Apache Flink Relational Programming Using Table API And SQL Data Streaming With Apache Kafka & Apache Spark Nanodegree

Dive into Python and learn how to automate tasks like merging chunky CSV or Excel files using few lines of code. — Suggested On-Demand Courses: Many of you contacted me asking for valuable resources to automate Excel (and in general spreadsheets) tasks with Python. Below I share four courses that I would recommend: Intermediate Python (Nano-Degree) OR Data Analysts | Python + SQL (Nano-Degree) VERY HIGH quality courses for people committed to learn more advanced…

Interview Countdown P2: In this article I present the solution of three frequently asked coding problems about computing running totals with window functions. — Recommended To My Readers Are you learning SQL or preparing for the next technical interview and you liked the style of the question in this article? Then, you should have a look at the SQL coding challenges offered by StrataScratch, an excellent platform dedicated to people that wish to pursue a career in Data…

The first triathlon can be daunting. Let me share with you some advices so you won’t have to learn the same lessons the hard way. — The Plot Of My First Ever Triathlon Lanzarote welcomed me with sunny skies and very strong winds. The temperature was around 20 degrees celsius, but it felt chill. Canary Islands are notoriously windy. I knew it from my first visit two years earlier, and I was reminded the following year, when my partner an I decided to…

Learn how to interact with Snowflake using the Snowflake Connector or SQLAlchemy Python packages and take advantage of the templates presented in the article. — Suggested On-Demand Courses: Are you trying to advance your career as a Data Engineer or Machine Learning Engineer? I would highly recommend for you to check the following courses: Data Engineering Nanodegree → High Quality Course! Data Streaming With Apache Kafka & Apache Spark Nanodegree

Learn how to store high volume of data, from Python nested lists to a Snowflake database, that you can query with SQL — Suggested On-Demand Courses: Are you trying to advance your career as a Data Engineer or Machine Learning Engineer? I would highly recommend for you to check the following courses: Python Data Engineering Nanodegree→ High Quality Course! LeetCode In Python: 50 Algorithms Coding Interview Questions → Best For Coding Rounds Involving Algorithms!