Sql
-
You can now ask your database questions and get answers without writing a single SQL query
15/07/2026Say you run a small online store. Its database holds hundreds or thousands of orders, customers and products. All that information is genuinely valuable, yet until now, looking anything up meant opening a SQL client, knowing the table schema and writing queries by hand.
-
Automation and advanced logic in your database with functions and triggers
15/04/2025In 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.
-
Database views: What are they and how to use them?
10/02/2025As 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/2025In 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/2024In 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.
-
Databases, an introduction to fundamentals
15/11/2024Today 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.