Database normalization is the process of organizing data in a database so that it is structured, efficient, and easy to use. It involves splitting up large tables into smaller, more manageable ones and ensuring that each table has a single, well-defined purpose. Normalization is a critical part of database design, as it ensures data consistency,…
Read moreCategory: SQL
With Recursive in PostgreSQL
![](http://karolos.me/wp-content/uploads/2023/02/with_Recursive.jpg)
There are several concepts in real world, which in order to be modeled properly in a database we will need to use a self referential tables. Such concepts can be anything that looks like a “tree”. Think of employees and managers as an organizational chart, taxonomy systems such as animals or genetics, graphs like travel…
Read morePostgreSQL Window Functions with practical examples
![](http://karolos.me/wp-content/uploads/2022/09/window-functions.jpg)
Window functions provide the ability to perform calculations across sets of rows that are related to the current query row. In this post we will explore PostgreSQL’s window functions and how we can utilize them.
Read more