View source for PostgreSQL-Database/C2/Creating-a-Table-and-its-Attributes/English

'''Title of the script: Creating a Table and its Attributes'''.

'''Author: EduPyramids'''

'''Keywords''': Table, creating table, Data types, data inputs, EduPyramids, Video Tutorial.


{| border=1
|-
| align=center| '''Visual Cue'''
| align=center| '''Narration'''
|-
|| '''Slide 1'''

'''Title Slide'''
|| Welcome to the '''Spoken''' tutorial on '''Creating a Table and its Attributes'''.
|-
|| '''Slide 2'''

'''Learning Objectives '''
|| In this tutorial, we will learn to, 
* Define tables and columns 
* Data types 
* Create a table using '''p g Admin 4''' and 
* View the '''S Q L''' command generated for the table.

|-
|| '''Slide 3'''

'''System Requirements '''
|| To record this tutorial, I am using 
* '''Ubuntu 24 point 04''' LTS
* '''Postgres Q L version 18 point 1''' and 
* '''pgAdmin 4 version 9 point 11'''.

|-
|| '''Slide 4'''

'''Pre-requisites '''

[https://edupyramids.org https://EduPyramids.org] '''

|| To follow this tutorial, 
* Learners should have '''PostgreS Q L''' and '''p g Admin 4''' installed in their systems.
* For the pre-requisite '''PostgreS Q L''' tutorials, please visit this website. 


|-
|| '''Slide 5 '''

'''Code Files'''
 
*'''cta-codes.txt'''


|| The following code file is required to practice this tutorial.

This file is provided in the '''Code Files''' link of this tutorial page.
|-
|| Switch to pgAdmin
|| Let us now switch to the '''p g Admin''' '''4''' interface.
|-
|| Show localhost server from '''Object Explorer.'''
|| Please ensure that you are connected to the '''Localhost''' Postgres Q L server.
|-
|| Click on the arrow to expand '''Studentdb'''
|| In the '''Browser '''pane, expand the '''Student d b''' database.
|-
|| Expand '''Schemas''', '''public''' and '''Tables '''node.
|| Now expand the '''Schemas''' node, '''public''' node and then '''Tables''' node.
|-
|| '''Slide 6'''

'''What is a Table?'''
|| In a relational database, data is stored in database objects called '''tables'''.

A table is a collection of related data organized in rows and columns.
|-
|| '''Slide STUDENT Table '''

sampledb.png
|| This is an example of a '''STUDENT''' table.
|-
|| Highlight columns
|| A '''column''' is an attribute that stores values of a specific data.

Columns represent attributes such as student i d, '''student name''', address, city, phone, date of birth and '''CGPA'''.
|-
|| Point to the column Student Name.
|| For example, '''Student Name ''' is a column that stores names of students.
|-
|| Back to pgAdmin
|| Let us now create a new table in the '''Student d b database'''.
|-
|| Right-click Tables

Select Create → select Table.
|| Right-click on the '''Tables''' node and select''' Create.'''

Then select '''Table'''.
|-
|| Point '''Create – Table''' window
|| The '''Create Table''' window opens.
|-
|| Enter table name as '''students'''
|| In the '''General '''tab, type '''students''' as the '''table''' name.
|-
|| Click Columns tab
|| Now click on the '''Columns''' tab.
|-
|| Click the '''Add''' '''row (+)''' button.
|| Click the '''Add row''' button at the extreme right of the Columns tab to add a new column.
|-
|| Enter '''student_name'''
|| Enter '''student_name''' in the Name field.
|-
|| From the drop-down select data type as '''character varying'''
|| Select '''character varying''' as the data type.
|-
|| Enter length as 50
|| Type its length as 50. 
|-
|| '''Slide 7'''

'''Data Type'''
|| You may be curious about what a '''data type''' is?Let’s see.

A '''data type''' specifies the kind of value a variable can store.

'''PostgreSQL''' provides several commonly used data types.
|-
|| '''Slide 8'''

'''Data Types'''

|| '''Integer''' and '''numeric''' are used for numeric values such as age and quantity.

'''numeric '''represents '''decimal''' values, where '''n''' is total digits and '''d''' is digits after the decimal.

'''char''' and '''character''' '''varying''' are used for string data.

'''text''' is a '''string''' '''data''' '''type''' with unlimited length.

'''date''' is used to store '''date''' values.
|-
|| Add '''city''' column

Select Data Type as '''character''' '''varying.'''

'''Type length as 40'''
|| Let us add a column named '''city''' with '''data type character''' '''varying''' and length 40.
|-
|| Add '''gender''' column

Select Data Type as '''character''' '''varying.'''

'''Type length as 10'''
|| Next let’s add a column named '''gender.'''

Let us select '''character''' '''varying''' as '''data type''', type its length as 10.
|-
|| Add '''date_of_birth'''

Select Data Type as''' date'''
|| Similarly let add a column '''date_of_birth''' with '''date''' as data type.
|-
|| Add '''cgpa''' column

Select Data Type as '''numeric'''

Precision is '''2'''

Select scale as '''1'''

|| Then add a column named '''cgpa''' with numeric data type, '''precision''' '''2 '''and''' Scale 1'''.

Here the''' Precision''' is 2. 

It allows a total of 2 digits, before and after the decimal.

Scale is 1. 

So out of those 2 digits, 1 digit is after the decimal point.
|-
|| '''Point to all the columns in the table.'''


'''Click the blue Save button to save the''' table1
|| We have added all the required columns for the table.


Let’s click the blue '''Save''' button at the bottom right corner.
|-
|| Expand Tables
|| The '''students''' table is now created and visible under the '''Tables''' node.
|-
|| Click students table
|| Click on the '''students''' table.
|-
|| Highlight SQL pane
|| In the '''SQL''' tab, we can see the automatically generated '''CREATE TABLE''' command.
|-
|| 
|| With this we come to the end of this tutorial.
|-
|| '''Slide 8'''

'''Summary'''

In this tutorial, we have learnt to *Define tables and columns, 
* Data types, 
* Create a table using pgAdmin 4, and 
* View the '''SQL''' command generated for the table.


|| Let us summarise.
|-
|| '''Slide 9'''

'''Assignment'''

* Connect to the PostgreSQL server.
* Create a database named Organization.
* In the Organization database, create a table named '''Emp.'''
* Add the columns Emp-name, Address, DOB and Salary.


|| As an assignment, please do the following.
|-
|| '''Slide 10'''

'''Thank You'''
|| This Spoken Tutorial is brought to you by EduPyramids Educational Services Private limited SINE IIT Bombay

Thank you for joining.
|-
|}