Databases

Cómo instalar MySQL en Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

Cómo instalar MySQL en Ubuntu 20.04

Hazel Virdó escribió una versión anterior de este tutorial. MySQL es un sistema de administración de bases de datos de código abierto, que comúnmente se instala como parte de la popular…

Read more
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
How To Install and Use TimescaleDB on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use TimescaleDB on Ubuntu 18.04

TimescaleDB is an open-source database optimized for storing time series data. It is implemented as an extension of PostgreSQL and combines the ease-of-use of relational databases and the speed of NoSQL databases. By following this tutorial, you’ll set up TimescaleDB on Ubuntu 18.04, configure it, and learn how to work with it. You’ll run through creating time series databases and making simple queries. Finally, you’ll see how to compress data and get rid of unnecessary data.

Read more
How To Reset Your MySQL or MariaDB Root Password on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Reset Your MySQL or MariaDB Root Password on Ubuntu 18.04

Forgetting passwords happens to the best of us. If you forget or lose the **root** password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-enabled user account. In this tutorial you’ll reset the root password for your MySQL or MariaDB database running on Ubuntu 18.04.

Read more
How To Use Functions in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Use Functions in SQL

When working with relational databases and Structured Query Language (SQL), you can store, manage, and retrieve data from the relational database management system. SQL can also perform calculations and manipulate data through the use of functions. In this tutorial, you’ll use different SQL functions to perform mathematical calculations, manipulate strings and dates, and calculate summaries using aggregate functions.

Read more
CHAT