Learn PostgreSQL for basic to advance

Learn PostgreSQL  for basic to advance

PostgreSQL uses SQL as the main query language.

what is the database: where we can store, manipulate, and retrieve data.

PostgreSQL and relational database:

PostgreSQL is the actual database engine and the SQL is a structured query language. this query language helps us to communicate with dataBase. SQL is a programming language. it manages us to manage relational database. it's easy to learn. and also it's powerful. SQL used all over the internet.

how to data stored

Data is stored in a table. it's the combination of columns and rows.

what is PostgreSQL:

it's basically the most advanced open-source relational database. it's very popular because it is open source. and it's been active in development 30 years. A lot of start-up uses PostgreSQL. PostgreSQL is an object-relational database management system.

PostgreSQL installation:

install PostgreSQL on your machine step by step. and start server.