Introduction In this tutorial, I will show you how Materialize works by using it to run SQL queries on continuously produced nginx logs. By the end of the tutorial, you will have a better idea of what Materialize is, how it's different than other SQL...

Introduction If you've ever used SQL, you probably know that JOINs can be very confusing. In this quick post we are going to learn what the difference between JOIN and INNER JOIN is! Difference between JOIN and INNER JOIN Actually, INNER JOIN AND JOI...

Introduction In some cases if you have a really large .sql file, it is best to import it via the command line. You might need to do this in case that you are using a tool like PHPmyAdmin, which more often than not, has a certain limit that the file t...

Introduction In this quick tutorial, you will learn how to add a default value to an existing column in MySQL. Prerequisites You always need to be careful, when changing the structure of an existing column in your database. Make sure to always have b...

Introduction No matter if you are a data analyst or a system administrator when working with unstructured files in Linux there are a set of commands that would help you a lot in your daily tasks. In this tutorial, you will learn the basics of the fol...

💡 Introduction to Docker This is an open-source introduction to Docker guide that will help you learn the basics of Docker and how to start using containers for your SysOps, DevOps, and Dev projects. No matter if you are a DevOps/SysOps engineer, dev...

Introduction By creating a repository with the same name as your GitHub username (eg. bobbyiliev/bobbyiliev) you actually create a special repository. Its README.md will appear on your public profile. In this post I will show you how to automatically...

Introduction With the ever growing data volumes and demands, the data engineering career has been one of the fastest growing jobs for the past few years. According to the 2021 Stack Overflow survey, data engineers are one of the top 5 highest paid pr...

Introduction No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you can use Bash scripts to combine different Linux commands and automate boring and repetitive daily tasks, so that you can focus on more productive a...

Introduction to Docker It is more likely than not that Docker and containers are going to be part of your IT career in one way or another. In this blog post series I'll cover the following: What are Docker images, containers and Docker Hub Installi...