Databases

MySQL triggers provide control over data validation when inserting, updating or deleting data from a database. Learn how to use triggers through an example database and when to use each type of trigger.

Thanks to Spark's DataFrame API, we can quickly parse large amounts of data in structured manner. DataFrame API is available for Java, Python or Scala and accepts SQL queries.

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 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.