Header Ads

How to install PostgreSQL with basic queries

INTRODUCTION

The practical wordbook for “DataBase System. In this section we will discuss about PostgreSQL environment and there functionalities, & how to install the PostgreSQL application(DBMS) with lab task.

 Index:

 In this we learn 

 Introduction to PostgreSQL. 

 How to install PostgreSQL. 

 How to connect with server. 

How to create a Database. 

 How to create Table in PostgreSQL. 

 How to insert Data (info).



Objectives: 

 Task #1 

Introduction to PostgreSQL & his Installation. 

Introduction To PostgreSQL: 


PostgreSQL is called Postgres , it was create by Computer Science Professor named Micheal Stonebreker at UCB. It is open source Data Base Management system (DBMS). 
Task #2
⦁Installation of PostgreSQL: 
How to install PosgtreSQL, First of all you have need backup of PostgreSQL. It is have many versions on internet.

Download Link Download from this Link for Windows, Linux, Mac etc.
Link :
https://www.postgresql.org/download/


Step No.1

Of Installation of PostgreSQL is (Double Click) on the Backup file or setup.

Step No.2

The computer get permission from Administrator for Installation of PostgreSQL. 

Step No.3

It introduce the setup and get answer for going to continue the application installing.


Step No.3

In step number three is specify the Directory (location or place), where you can install this, it means in which memory partition you can install it.


Step No.4

It confirm the components, which components you have need in your application.


Step No.5

After selection of components it get password from you for connect the database with server.


Step No.6      

It get selection of port number the server it is by default number.


Step No.7

After the selection of port number server it have some Advance option to locate to use new database cluster.


Step No.8

In the step 8 it show some summary to you about the Directory, server install directory, data base ports, database super user etc. For the confirmation of the application for your information.  It show the database is there go to install and your database port is this and super user mean application name and version etc.



Step No.9

After the summary the application was ready to install, it get permission to install the application.


Step No.10

After the gating permission it was save files into memory or (install) the application.





Step No.11

After the installation it show one message in this message the system say your application was in process of completing.


Step No.12

After the finishing the process it tell you to install Stak Builder you do not install it or (cancel it).


Step No.13

After the finishing of installation, opening (starting) the application look it like this.

 Interface of PostgreSQL.
After the installation of PosgreSQL we see how this interface.

Task #3

Ø Connect to server:

After the opening of PostgreSQL we will connect data base to server. First of all you click on server and then Right click on PostgreSQL and click on (connect server) option.


After the click on (connect server) it get Password which password you insert in the process of installation.


After the enter password you are connect with server. It remove the (X sign) automatically because you are connected with server.

Task #4

Ø Create DataBase:

After the connected with server you are able to create your own  DataBase. Click Right on the postgress & goto Query Tool.

And write code on Query Tool for creating DataBase.


After writing the code of creating DataBase, select all and Execute the program. Then you have to refresh the database, after refreshing your Database was created. Then  you have to create Table.

Task #5

Ø Creating Table


After the creating Database you will create Table. In the process of creating table you are creating table collums. Table have another name.
After creating table you go into your Database Schema option in schema have table option open table option to see your Collum’s.

 
Task # 6

Ø Inserting Data:

In this section we are insert data (info) in our Table.

It have a Query to insert Data.

 


Download Complete Lab Manual..

                              ______________________The End____________________

If you have any problem about this lecture or about any other problem then just leave your comment here, I will read and reply here.

Please keep Supporting on My YouTube Channel.
If you like this Blog than share with others.
Do you want to learn about Python/C/C++ and other computer relative subjects than follow this Channel link  Computer Knowledge.
Thanks For Coming...

No comments

Powered by Blogger.