This is the simple instruction on how to download the dump file with sql database and import it to the local postgreqsql database

In this article you will get the knowledge about very important function inside SQL databases.

We will talk about indexes.

Here you can find quick tips, how to create a database in postgresql + you will also get the knowledge
about assigning user to the created database.

In this article you will get the knowledge about different conditional statements which are appearing in SQL language.

You will know how to execute SQL query only when some conditions are met.

SQL beginners can have some problems with understanding how Self-Join works. But everybody should understand
how handy this query type is. It helps us to combine two records inside same table into single row.

This thing is widely used on some level of programming and for sure we all sure understand, how to use it.

Sometimes you can realize, one query is not enough to get the information you want.
It just feels like you need to do it "in steps". Thank god, we have Subqueries in SQL.

Subqueries will help you make more complex SQL queries and i will show you how to write them.