Join

• Database views: What are they and how to use them?

  10/02/2025

  As databases grow larger and more complex, managing and accessing data efficiently becomes increasingly challenging. This is where database views come into play. A view acts as a “window” into the data stored in your database.

• Introduction to PostgreSQL, one of the most popular database engines

  15/01/2025

  In this series, we’ve explored various database engines, such as SQLite, and the fundamental concepts of the relational model. Now, we’ll dive into PostgreSQL, a relational database management system (RDBMS) widely recognized for its robustness, scalability, and extensibility.

• An overview of the most common commands in relational databases with SQL

  01/12/2024

  In the previous chapter, we reviewed the origins and fundamentals of databases. We took a brief journey through the different types of databases, including relational ones.