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](https://mazer.dev/images/redis/redis-running.webp)
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](https://mazer.dev/images/pgsql/postgresql-coalesce-function.webp)
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](https://mazer.dev/images/mysql/error-1205-lock-timeout-mysql.webp)
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](https://mazer.dev/images/mysql/innodb-monitor.webp)
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](/pt-br/bancos-de-dados/artigos/engenharia-reversa-sistemas-e-bancos-de-dados-migracao-softwares-legados/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](/en/databases/mongodb/atlas/connecting-mongodb-atlas-with-robomongongo-robot-3t/featured-robo3t.png)
Robo 3T is no longer being developed by Studio 3T. Studio 3T recommends users looking for a MongoDB GUI client try Studio 3T Free, a free-forever edition of the Studio 3T tools.
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](/en/databases/mongodb/atlas/mongodb-atlas-creating-cluster/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).
What is Mongodb Atlas
MongoDB Atlas is a cloud service that allows the developer to set up a MongoDB server infrastructure without the...