This repository contains examples for working with database and writing queries. Most of the examples are written for PostgreSQL. You can also try pgcli for better experience with PostgreSQL.
An example for writing SQL file and mount it into PostgreSQL docker.
A tiny model of Snapp database. It has drivers and passengers, also it stores rides and has their event as an enumeration type.
An example for using database users (roles).
An example for having views in the database.
This example is about getting reports from database. Please note that this example is the hardest.