Madhurig at 14:05, 6 February 2026

2026-02-06T14:05:27Z

Madhurig: Created page with "Title of the tutorial: '''Inserting and Retrieving Data'''. Author: EduPyramids Keywords: '''INSERT Script, INSERT''' '''statement''', '''Query Tool, Execute query''', '''SEL..."

2026-02-06T14:04:32Z

Created page with "Title of the tutorial: '''Inserting and Retrieving Data'''. Author: EduPyramids Keywords: '''INSERT Script, INSERT''' '''statement''', '''Query Tool, Execute query''', '''SEL..."

New page

Title of the tutorial: '''Inserting and Retrieving Data'''.
Author: EduPyramids

Keywords: '''INSERT Script, INSERT''' '''statement''', '''Query Tool, Execute query''', '''SELECT''' '''query'''.''' Retrieving data,''' '''data redundancy''', '''EduPyramids, Video Tutorial.'''

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

'''Title Slide'''
|| Welcome to the Spoken tutorial on '''Inserting and Retrieving Data'''.
|-
|| '''Slide 2'''

'''Learning Objectives '''
|| In this tutorial, we will learn to
* '''Insert''' data into a table and
* '''Retrieve''' data from a table.

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

'''System Requirements '''
|| To record this tutorial, I am using
* '''Ubuntu 24.04''' LTS
* '''Post gres Q L version 18 point 1''', and
* '''P g Admin 4 version 9 point 11'''.

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

'''Pre-requisites '''

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

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

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

'''Code Files '''

* '''ird-codes.txt'''

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

This file is provided in the Code Files link on this tutorial page.
|-
|| Open pgAdmin
|| Let us open '''pgAdmin''' '''4.'''
|-
|| Show dashboardDouble click on Servers.Enter password: '''postgres'''

Click''' OK'''
|| Please ensure that you are connected to the '''Localhost''' '''Post gres Q L '''server.
|-
|| Select '''Studentdb'''
|| In the '''Browser '''pane, let us expand the '''Student d b''' database.
|-
|| Click on the '''Schemas, '''then''' Public '''and''' '''then''' Tables'''.
|| Now let’s expand the '''Schemas''' node, '''public''' node and then '''Tables''' node.
|-
|| Click '''students''' table
|| Let us click on the '''students''' table.
|-
|| Click '''Columns'''
|| Next let us click on the '''Columns''' node.
|-
|| Point to columns
|| We can see the structure of the students table with its columns.
|-
|| Transition
|| Now let us insert data into this table.
|-
|| Right-click students
|| Let me right click on the '''students''' table.
|-
|| Select Scripts → INSERT Script
|| Let us select '''Scripts. '''

A submenu list opens

From the submenu select''' INSERT Script'''.
|-
|| Query Tool opens
|| The''' Query Tool '''window opens with a default '''INSERT''' statement.
|-
|| '''Slide 6: '''

'''INSERT Statement '''

'''INSERT INTO table(column1,column2...)'''

'''VALUES (value1, value2,...);'''

Highlight according to narration
|| The '''Insert statement''' inserts one or more rows into a '''table'''.

The inserted values must match column order and data type of each column.

That is column 1 takes the value 1 and column 2 takes the value 2 and so on.
|-
|| Highlight syntax
|| The column names must follow the same order as the values.
|-
|| Type:

'''INSERT INTO students (student_name, city, gender, date_of_birth, cgpa)'''

'''VALUES ('Ram', 'Mumbai', 'Male', '1996-10-23', 9.6);'''
|| Please delete the default '''INSERT''' statement before typing the new query.

Let us type the following query in the query window to insert a row.

Let’s drag the boundary to see the query clearly.
|-
|| Highlight values Ram, Mumbai and Male.

Highlight the numeric value.
|| Observe that character values are enclosed within single quotes.

Here numeric values are not enclosed in quotes.
|-
|| Click on the '''Execute query''' button.

Show the tool tip.

Point to the Execute query pop window.

Point to the message.

Click the Continue button.
|| Let us now click on the '''Execute query''' button on the toolbar.

Execute query window opens with a message Do you want to run this query-

Click the '''Continue''' button to run the query.
|-
|| Success message
|| A message '''Query returned successfully''' appears.
|-
|| Select and press delete key.

'''Type: '''

'''INSERT INTO students '''

'''(student_name, city, gender, date_of_birth, cgpa)'''

'''VALUES '''

'''('Kishore', 'Mumbai', 'Male', '1996-08-09', 8.5);'''
|| I will insert one more row in the same way.

Please delete the last command before typing the new command.

Let me type the following query.
|-
|| Click on the '''Execute query''' button.

Point to the Don’t ask again check box on the left.

|| Let us click on the '''Execute query''' button to run the query.

We will check the '''Don't ask again''' check box to prevent the pop-up from appearing on every query execution.

Click Continue in the pop up box.
|-
|| Transition
|| Now let us retrieve the inserted data.
|-
|| Type '''SELECT * FROM students;'''
|| Type '''SELECT asterisk FROM students semicolon.'''
|-
|| Click on the '''Execute query''' button.
|| Let me execute the query again.
|-
|| Point to the Output pane
|| The output is displayed in a tabular format.

Let’s drag the boundary to see the table clearly
|-
|| '''Slide 7'''

'''Syntax: Insert - Multiple row'''

'''INSERT INTO table(column1,column2...)'''

'''VALUES (value1, value2,...),'''

'''(value1, value2,...),'''

'''…..;'''

|| This syntax is used to insert multiple rows in a single''' INSERT '''statement.

Each set of values inside the parentheses represent one row.

These rows are separated by commas.

The values in each row must match both the column order and the specified data type.
|-
|| '''INSERT into students(student_name, city, gender, date_of_birth,cgpa)'''

'''Values ('Ram','Chennai','Male','1995-11-21', 9.2), ('Kishore','Mumbai','Male','1996-08-09', 8.5),'''

'''('Pooja','Pune','Female','1995-03-25', 9.2);'''
|| Now let me type this INSERT statement.
|-
|| Click on the '''Execute query''' button.
|| Let us execute the query again.
|-
|| Point to the message
|| The message shows '''3 rows.'''
|-
|| Type '''Select * from students;'''

Click on the '''Execute query''' button.
|| Let us retrieve the data again using a '''SELECT''' query.

Let us execute the query.
|-
|| Drag the boundary to see the table.

Highlight Duplicate names

|| Let us drag the boundary to see the entire table

The table contains multiple students with the same name.

So the student names are not unique.

This causes '''data redundancy'''.
|-
|| Point to the data.
|| How can we uniquely identify each student?
|-
||
|| We will learn more about data redundancy in the next tutorial.
|-
|| Click on '''Save File''' icon on the toolbar.
|| Let us save the file.

Click on the '''Save File''' icon on the toolbar.
|-
|| Save the file as '''insertscript-student.sql'''
|| Save file window opens

Type the Name as '''insert script hyphen student dot s q l'''.Now click on the '''Save '''button.
|-
||
|| With this, we come to the end of this tutorial.
|-
|| '''Slide 8'''

'''Summary'''

In this tutorial, we learnt to
* '''Insert''' data into a table
* '''Retrieve''' data from a table.

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

'''Assignment'''

* Insert five records in the Emp table created in the previous assignment
* Retrieve the data.

|| 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.
|-
|}

@@ Line 1: / Line 1: @@
 Title of the tutorial: '''Inserting and Retrieving Data'''.
 Author: EduPyramids
 Keywords: '''INSERT Script, INSERT''' '''statement''', '''Query Tool, Execute query''', '''SELECT''' '''query'''.''' Retrieving data,''' '''data redundancy''', '''EduPyramids, Video Tutorial.'''

PostgreSQL-Database/C2/Inserting-and-Retrieving-Data/English - Revision history

Madhurig at 14:05, 6 February 2026

Madhurig: Created page with "Title of the tutorial: '''Inserting and Retrieving Data'''. Author: EduPyramids Keywords: '''INSERT Script, INSERT''' '''statement''', '''Query Tool, Execute query''', '''SEL..."