Databases

Find a list of all MySQL date functions in this helpful article. Learn what each function does and how to use it through the practical examples.

Need a reference sheet for all the important MySQL commands? Check out this MySQL Commands article which includes a downloadable MySQL cheat sheet in PDF format.

The rise of NoSQL databases caused a stir in the database community, with many companies deciding to adopt the novel approach to database management. This article analyses how MongoDB, a document-oriented NoSQL, compares with MySQL, a traditional relational database management system.

Database transaction models are sets of properties which guarantee validity of data in a database. ACID and BASE are the most common among them. This article describes and compares the two models and offers advice on which one to choose.

Redis is an open-source solution for data storage, most often used as a database, cache storage, or a message broker. This tutorial covers different ways to install, configure, and uninstall Redis on Mac.

A data warehouse is a complex system that stores historical and cumulative data used for forecasting, reporting, and data analysis. Learn about the data warehouse architecture and the components found in the system.

Redis is used as a database, cache storage, and message broker thanks to its ability to store key-value pairs. This tutorial covers different ways to clear Redis cache and delete key-value pairs.

The article covers seven basic Redis Data Types, including HyperLogLogs and Bitmaps. Each data type is presented using practical and to the point commands.

Want to learn more about HDFS? This guide explains what the Hadoop Distributed File System is, how it works, and when to use it. If you need an effective solution for big data, HDFS and Hadoop could be the answer.

There are two main types of database solutions: SQL and NoSQL. In this article, you will learn the key differences between these database types.