SQL

Image: What are the key differences in a MariaDB vs. MySQL comparison?kentohShutterstock

What are the key differences in a MariaDB vs. MySQL comparison?

MySQL is one of the most widely used database management systems worldwide. The open-source software has been available since 1995 and is considered the standard solution for relational databases. However, MariaDB is becoming an attractive alternative. We compare both systems and…

Read more
Image: How to import and export MySQL/MariaDB databaseRDVectorShutterstock

How to import and export MySQL/MariaDB database

If you want to back up or restore MySQL or MariaDB databases, you can use the command line to do so. This tutorial walks you through the process of importing and exporting databases—both in MySQL and MariaDB. In this dedicated article, you’ll learn how to create an empty…

Read more
Image: What alternatives to SQL are there?Wright Studioshutterstock

What alternatives to SQL are there?

In terms of databases, alternatives to the SQL approach have existed for quite some time. The advantages of a relational system shouldn’t be overlooked though. In fact, it might be exactly what your project requires. Here, we’ll go over which NoSQL solutions are worth considering…

Read more
Image: What are the top 6 MySQL alternatives?Connect worldshutterstock

What are the top 6 MySQL alternatives?

MySQL is one of the best-known solutions in the relational database segment. But if you’re seeking a NoSQL companion to your SQL database or are aiming to get around rigid table structures altogether, it makes sense to explore NoSQL options. In this article, we’ll take a look at…

Read more
Image: What is SQL AND?REDPIXEL.PLshutterstock

What is SQL AND?

With the SQL AND operator, you can implement various conditions in a WHERE query, allowing you to include or exclude different entries. In this article, we’ll explain what the operator is and the syntax for it. Using practical examples, we’ll go over how to use the operator as…

Read more
Image: What is an SQL injection?STILLFXshutterstock

What is an SQL injection?

It seems like almost every day a new software vulnerability is uncovered or an existing one is patched. One attack method that has long exploited such weaknesses is the SQL injection. But what exactly are these malicious database exploits, how do they work, and—most…

Read more
Image: How to use SQL SELECT TOP

How to use SQL SELECT TOP

Large data sets can quickly get confusing! Commands like SQL SELECT TOP, LIMIT and ROWNUM allow you to limit query results to a number of your choosing. That makes results easier to read and increases efficiency and performance. In this tutorial, we show you how to use SELECT TOP…

Read more
Image: How to use SQL OR

How to use SQL OR

When working with complex datasets, it’s important to be able to perform efficient, precise searches. One tool that can help with that is the logical operator OR. SQL’s OR returns records that meet at least one of two conditions. In this tutorial, we explain everything you need…

Read more
Image: How to use SQL SELECTREDPIXEL.PLShutterstock

How to use SQL SELECT

When analyzing and processing data, it’s essential to be able to select relevant records. SQL SELECT is the main tool for selecting relevant columns and records in SQL. When combined with other operators and commands, SELECT has a wide variety of potential uses. In this tutorial,…

Read more
Image: How to use SQL SUMPaolo Schorlishutterstock

How to use SQL SUM

Whether you need to calculate total costs, sales, order quantity or any other value, SQL SUM can do a large part of that mathematical work for you! As an aggregate function that adds up all the values in a column, it is an indispensable tool in SQL. In this tutorial, we show you…

Read more