Difference between revisions of "RDBMS-PostgreSQL/C2/Create-database-using-PgAdmin/English"

Learning Objectives

• connect to the server
• database and its objects
• how to create a database
• Table and its attributes and
• how to create a table

System requirement

• Ubuntu Linux 14.04 operating system
• PostgreSQL 9.3.x
• pgAdmin 1.18

Pre-requisites

• good understanding of basic computer concepts and

• working knowledge of any programming language.

Here, on the left hand side we can see the object browser pane.

The various objects of the database are displayed here.

Click on the connection icon on the top left corner of the tool bar.

Type localhost in the Name field

Type localhost in the Username field

Keep all the other parameters same.

Click on Ok button.

These give additional information for our understanding.

Always click on this check box 'Do not show this hint again', before you close these windows.

I won't explicitly mention this.

Click on Ok button.

Click on the localhost node.

Point to the objects under the server

Click on the localhost node.

We can see several objects for this particular server.

The default database 'postgres' that is created during installation is displayed here.

Database

Image

Database.svg

A database has objects such as tables, views, procedures, functions, etc.

We will learn about these objects in the future tutorials in this series.

We can have multiple databases depending upon our application requirement.

What is table?

A table is a collection of related data that is stored in rows and columns format.

Show the table image:student.jpg

Tables have columns which are called as fields.

The fields in the STUDENT table are Student ID, student name, address, city, Phone, DOB, CGPA.

What is a Column?

Show the student_ column.jpg

Here in the STUDENT table, Student Name is one of the attribute that represents names of students.

Then click Schemas and then Public and Tables.

Let us give “students” as table name.

Click on the Add button.

The data type specifies what type of data the field can hold.

The length specifies the maximum length of the column of the table.

Data types:

integer, numeric - numeric data type

numeric (n,d) – where n is the total digits and d is the number of digits after the decimal

char (size) - holds a fixed length string

character varying(size), varchar(size) - holds a variable length string

text – variable unlimited length

Date – date data type

For example, phone no, age, quantity are of numeric data type.

numeric(n,d) - is also numeric data type with decimal places.

Here n is the total digits and d is the number of digits after the decimal.

It can be used to represents fields like basic salary, unit price etc.

char and character varying represents string data type.

Fields such as name, address, email are of string data type.

Text is a string data type with unlimited length.

Date represents date data type.

This is same as the decimal data type.

We will see the importance of Primary keys in the future tutorials.

• how to connect to the server
• database and its objects
• how to create a database
• Table and its attributes and
• how to create a table

1. Connect to the server and check the default available database
2. Create a new database Organization.
3. In the Organization database, create a table Emp with the columns Emp name, Address, DOB and Salary.

About Spoken Tutorial project

[1]

Please download and watch it.

Spoken Tutorial workshops

• conducts workshops
• gives certificates

For more details, please write to us.

Forum for specific questions

Acknowledgement

More information on this mission is available at this link.