Understanding NoSQL Data Modeling Techniques
February 25, 2021
NoSQL data models are built for speed, efficiency, and scalability. This tutorial covers different techniques for building NoSQL data models.
How to Install SQL Express Server
February 4, 2021
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.
MySQL Date Function Guide with Examples
January 28, 2021
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.
MySQL Commands Cheat Sheet
January 20, 2021
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.
MongoDB vs. MySQL
December 31, 2020
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…
SysAdmin,Databases,Bare Metal Servers
How to Create an External Table in Hive
December 9, 2020
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.
MyISAM vs. InnoDB: A Comparison
November 26, 2020
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…
ACID vs. BASE: Comparison of Database Transaction Models
November 25, 2020
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.
How to Install Redis on Mac
November 5, 2020
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.
How to Create a Table in MySQL
November 3, 2020
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.