Basics of Postgress Sql

Before jumping into the topic of Postgress Sql. We need to undesrtand the meaning of database and database management system in short called as DBMS.

Q1. What is database?

Ans: database is place where we can store the data,retrieve the data and manipulate the data. This data can be huge volumes of data

Q2. What is DBMS?

DBMS is software which is used to manage the database (like running the queries provided by the users and showing the appropriate output after running the query)

Real life scenarios where actual databases are very helpful:

There are lot of scenarios where we use databases in the daily lives

1. In Facebook there could a huge database where it stores our credentials (secured manner), friends post, liked post and the photos we share on our timeline or in our friends timeline
2. In Amazon application, where they would need to store product details,reviews of the users etc..

I think with the above explaination one would get the basics of database and some of the real case scenarios.

Now we discuss about Postgress SQL.

Postgress is the database engine and SQL is like a programming language that allows to interact with the database.

Now you might get a doubt what is database engine.

Suppose we are interacting with the database with some commands. These commands should be understood by the database so that it performs a task.

The interpreation of the database commands is done by database engine.The objective of engine to create, read, update and delete (CRUD) data from a database.

How data is stored in database?

data is stored in the database in the form of tables. Tables contain rows and columns.

Tables in database model

Features of Postgress SQL:

• Postgress Object relational database management system(ORDBMS):

Object relational database management system: It is similar to relational model but also supports some complex data types like images,videos which is not supported by the simple RDBMS.

Postgress is opensource. So we dont need any licence to explore more concepts in Postgress.

Installation of Postgress in windows:

Go the link download link of postgress and install the new version of Postgress

How to acess the database?

Database is accessed through 3 ways

1. GUI : It is the simplest way to access database and all the tools related to modify or retieve data is done with GUI icons.
2. command line : This is the most used of way of accessing the database by the developers or by the db persons. Here we should write commands to get required results.
3. Application: Server side applications need to connect with the database and perform required queries to store or reterive the information

References:https://hackernoon.com/how-sql-database-engine-work-483e32o7

What is Database Management Systems (DBMS)?

https://www.guru99.com/relational-data-model-dbms.html