Understanding NoSQL Data Modeling Techniques


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

Read More

How to Install SQL Express Server


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.

Read More

MySQL Date Function Guide with Examples


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.

Read More

MySQL Commands Cheat Sheet


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.

Read More

MongoDB vs. MySQL


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…

Read More

How to Create an External Table in Hive


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.

Read More

MyISAM vs. InnoDB: A Comparison


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…

Read More

ACID vs. BASE: Comparison of Database Transaction Models


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.

Read More

How to Install Redis on Mac


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.

Read More

How to Create a Table in MySQL


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.

Read More