Databases

• 1

  Automation and advanced logic in your database with functions and triggers

  Apr 15, 2025

  In the previous chapters of this series, we’ve explored everything from foundational concepts of database design to more advanced SQL use cases using PostgreSQL. We’ve built a system to manage a public transportation network and covered how to define relationships between entities, perform complex queries, and even build views to simplify access to key data.

• 2

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

  Feb 10, 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.

• 3

  Introduction to PostgreSQL, one of the most popular database engines

  Jan 15, 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.

• 4

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

  Dec 1, 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.

• 5

  Databases, an introduction to fundamentals

  Nov 15, 2024

  Today we will talk about databases, which are often the backbone of modern computer systems, powering everything from business applications to social networks and e-commerce systems.