Databases

What is a Multi-Model Database?

April 29, 2021

Multi-model databases combine different database models into a single backend system. Learn about the use-cases and what the best multi-model databases are currently available on the market in this article.

Read more

MySQL Events and Event Scheduler Guide

April 27, 2021

MySQL events run on a schedule defined by the user. They automate database maintenance and execute tasks periodically. Learn how to use them in this simple tutorial.

Read more

What Is a Graph Database?

April 22, 2021

Graph databases are NoSQL systems created for exploring correlation within complexly interconnected entities. Learn when and how to use them.

Read more

How To Use MySQL JOINS {With Examples}

April 20, 2021

This tutorial explains what MySQL JOINS are and how to use them to combine information located in multiple tables, producing a unified result.

Read more

What Is an Object-Oriented Database

April 15, 2021

Object databases integrate seamlessly with object-oriented programming languages. The object-oriented approach to database modeling makes it easier to model complex real-world problems. Learn about how they work and what they can bring to the table in this article.

Read more

MySQL Stored Procedures (Create, List, Alter, & Drop)

April 13, 2021

MySQL stored procedures group multiple tasks into one and save the task on the server for future use. Stored procedures simplify database management and reduce network traffic. Learn how to use stored procedures in this tutorial.

Read more

How To Use MySQL Triggers

April 12, 2021

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.

Read more

What Is a Spark DataFrame?

March 16, 2021

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.

Read more

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.

Read more

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.

Read more