Databases

NoSQL data models are built for speed, efficiency, and scalability. This tutorial covers different techniques for building NoSQL data models.

SQL Server Express is a light, feature-restricted version of Microsoft's SQL Server 2019. This tutorial will guide you through the process of installing, upgrading, or uninstalling your copy of SQL Server Express 2019.

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…

External tables in Hive are used to access and query data stored outside of a database. Follow the steps of this tutorial to learn how to create, query and drop external tables.

Using the improper storage engine can lead to errors in querying and reduced speed and performance. In this article, you will learn differences between MyISAM and InnoDB storage engines. You will also learn how to check the storage engine and how it…

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.

MySQL is a well-known, free and open-source database application. One of the most crucial processes in MySQL is creating tables and databases. Follow this tutorial to learn how to create a table in MySQL and insert data.