Databases

Como Gerenciar um Banco de Dados SQL — step-by-step Databases tutorial on Progressive Robot

Como Gerenciar um Banco de Dados SQL

Os bancos de dados SQL vêm instalados com todos os comandos necessários para adicionar, modificar, excluir e consultar seus dados. Este guia de consulta rápida fornece uma referência para alguns dos comandos SQL mais usados. **Como…

Read more
Databases Checkpoint — step-by-step Databases tutorial on Progressive Robot

Databases Checkpoint

This checkpoint is intended to help you assess what you learned from our introductory articles to Databases, where we defined databases and introduced common database management systems.

Read more
How To Configure a Galera Cluster with MariaDB on Debian 9 Servers — step-by-step Linux tutorial on Progressive Robot

How To Configure a Galera Cluster with MariaDB on Debian 9 Servers

In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three Debian 9 Droplets that will act as nodes in the cluster. MariaDB is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.

Read more
How To Install and Configure Neo4j on Ubuntu 22.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Configure Neo4j on Ubuntu 22.04

Neo4j is a graph database that records relationships between data nodes, whereas traditional relational databases use rows and columns to store and structure data. Since each node stores references to all the other nodes that it is connected to, Neo4j can encode and query complex relationships with minimal overhead.

Read more
How To Install and Use ClickHouse on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use ClickHouse on Ubuntu 20.04

ClickHouse is an open source, column-oriented analytics database created by Yandex for OLAP and big data use cases. In this tutorial, you’ll install the ClickHouse database server and client on your machine. You’ll use the DBMS for typical tasks and optionally enable remote access from another server so that you’ll be able to connect to the database from another machine. Then you’ll test ClickHouse by modeling and querying example website-visit data.

Read more
CHAT