Courses, tutorials and tips to learn and improve your knowledge in modeling, designing and implementing Databases in your software projects.

Sections

How to Check if Redis is Running

Redis is an open-source, in-memory data structure store. It is used to store data in a fast and efficient way. To check if Redis is running on your system, you can use the following methods:

How to check if Redis is running on Linux Ubuntu, Mint and Debian

Open a terminal and run the following command:

systemctl...
PostgreSQL COALESCE Function: A Comprehensive Guide

In today’s data-driven environment, PostgreSQL continues to be a leading choice for robust database management. Among its arsenal of features, the PostgreSQL COALESCE function stands as a powerful tool for managing null values. As a database professional, understanding and leveraging the COALESCE function is...

Understanding and Resolving the SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction Error in MySQL

MySQL is a powerful and widely used open-source relational database management system. However, like any other software, it can occasionally throw errors that can be difficult to understand and resolve. One such error is “SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting...

Understanding MySQL Engine InnoDB Status Report

MySQL is a powerful open-source relational database management system, and InnoDB is one of the most popular storage engines for MySQL. InnoDB provides a unique feature called the InnoDB Monitor, which generates reports that provide valuable insights into the performance and internal workings of the InnoDB storage...

featured-engenharia-reversa.webp

Broadly, the concept of Reverse Engineering applied to systems and databases can be defined as: “the process of deriving the logical specifications of computer system components from their physical description (source code and tables, fields and indexes) with the help of automated tools”.

Software and...

featured-robo3t.png

Video lesson

Video Lesson that presents how to connect MongoDB Atlas to the Software Customer Robo 3T.

To learn how to create a MongoDB...

featured-mongodb-atlas-logo.png

Video lessons

Video class that describes the context of creating and using MongoDB Atlas cloud service and how to create a cluster to use in software projects (Portuguese).