MySQL

In the last part of this series, We talked about ACID properties and why it is necessary to understand them. In this article, We'll discuss a very interesting topic about Database internals: HOW DATABASE STORES TABLES ON DISK. Overview We all know that relational databases stores data in the form of…

Data security is a critical aspect of any application, especially when dealing with sensitive information. MySQL, one of the most popular database management systems, provides built-in encryption functions to protect data at rest. Two key functions in MySQL for encryption and decryption are AES_ENCRYPT and AES_DECRYPT. …

Aggregation functions play an important role in SQL when it comes to summarizing and analyzing data. They allow us to calculate statistical metrics, perform calculations on groups of data, and gain meaningful insights. In this article, we will explore the 10 most commonly used MYSQL aggregation functions such as COUNT…

Practice your SQL skills with this exercise case about the FIFA World Cup! Level: Beginner — Exercise Case: FIFA World Cup 2022 — Group E Level: Beginner Questions: 7 Link to Practice Environment: FIFA World Cup 2022 — Group E — MySQL — OneCompiler Welcome to this exercise SQL case where you can practice your query writing skills. Being able to write the right SELECT statements…

Introduction: Docker has revolutionized the way we deploy and manage applications, making it easier to run software in isolated environments. In this guide, we’ll walk you through the process of running MySQL containers in Docker and installing WordPress, all without enabling port mapping for MySQL. …

SQL (Structured Query Language) is a powerful tool for managing and manipulating relational databases. Whether you’re a beginner or an experienced SQL user, having a solid understanding of essential SQL methods is crucial for effective data retrieval and manipulation. In this article, we will explore 12 fundamental SQL methods that…

We all use databases in our daily online lives and in the process, we generate even more data. Uploading photos, making an order online, giving someone a piece of your mind online, filling a questionnaire are all ways we generate data. But where is all this data stored? In our…

Welcome to this week’s OpenLampTech developer newsletter. Like always, I am sharing a lot of great content from some fantastic writers and developers. Receive a free copy of my eBook, “10 MySQL Tips For Everyone”, when you subscribe to the weekly OpenLampTech newsletter. OpenLampTech has sponsorship opportunities in the weekly…

When working in Laravel, I always install barryvdh/laravel-debugbar in order to be able to better debug SQL queries and not only. While debugging I noticed something on the debug bar: