Madhurig at 11:29, 9 February 2026

2026-02-09T11:29:48Z

Madhurig: Created page with "'''Title of the Script''': '''Basic SELECT Statement''' '''Author''': '''EduPyramids''' '''Keywords''': postgreSQL, pgadmin 4, SELECT statement, asterisk operator, retrieve..."

2026-02-09T10:44:30Z

Created page with "'''Title of the Script''': '''Basic SELECT Statement''' '''Author''': '''EduPyramids''' '''Keywords''': postgreSQL, pgadmin 4, SELECT statement, asterisk operator, retrieve..."

New page

'''Title of the Script''': '''Basic SELECT Statement'''

'''Author''': '''EduPyramids'''

'''Keywords''': postgreSQL, pgadmin 4, SELECT statement, asterisk operator, retrieve all the data, EduPyramids, Video Tutorial.

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

'''Title Slide'''
|| Welcome to this Spoken Tutorial on '''Basic SELECT Statement'''.
|-
|| '''Slide 2'''

'''Learning Objectives'''
|| In this tutorial we will learn about,
* '''SELECT''' '''statement''' and
* Asterisk(*) Operator

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

'''System Requirement'''
|| To record this tutorial, I am using
* Ubuntu''' 24.04 LTS.'''
* PostgresQL version 18.1 and
* PgAdmin 4 version''' '''9.11
|-
|| '''Slide 4'''

'''Prerequisite'''
|| To follow this tutorial,

* Learners should have '''PostgreSQL''' and '''pgAdmin 4'''.
* For the pre-requisite '''PostgreSQL '''tutorials, please visit this website.

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

'''Code Files '''

* bs-code.txt

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

This file is provided in the Code Files link of this tutorial page.
|-
||
|| Let us learn about the '''SELECT''' statement.
|-
|| '''Slide 6'''

'''SELECT statement'''
|| The '''SELECT''' statement retrieves data from one or more tables in '''PostgreSQL'''.

It does not modify the data, but only displays the stored data.
|-
||
|| Let’s get started.
|-
|| Show '''localhost''' server node
|| Please ensure that you are connected to the '''Localhost''' '''PostgreSQL''' server.
|-
|| Select '''Studentdb'''
|| In the '''Browser '''pane, expand the '''Student db''' database.
|-
|| Click '''students''' tableClick '''Columns '''node
|| Let us click on the '''students''' table.Let us next click on the '''Columns''' node.
|-
|| '''Slide 7'''

'''SELECT statement'''
|| '''SELECT''' statement is used to select all columns or specific columns from a table.

Ensure that a table containing data already exists.
|-
|| '''Slide 8'''
|| Imagine a notebook with many student records.

How do we read the stored information easily?
|-
|| '''Slide 9'''
|| In databases, we use the '''SELECT''' statement to read data.

Pause and think of asking for details from a register.
|-
|| Show the pgAdmin 4 records.Highlight Table.
|| Here, the table named '''students''' already exists.

This table stores student information.
|-
|| Type: '''SELECT * FROM students;'''
|| Let us retrieve all the data from the table.

Type this command in the query window.
|-
|| Highlight '''<nowiki>*(asterisk)</nowiki>'''
|| The asterisk symbol selects all the columns.

This command displays the entire data.
|-
|| Click on the '''Execute''' '''query''' button.
|| Let us execute the query.
|-
|| Highlight output:
|| Pause and observe the output carefully.Sometimes, we need only selected information.
|-
|| Highlight: '''studentname column''' and '''dob column'''
|| Let us select '''studentname''' and '''d o b '''columns.
|-
|| Type: '''SELECT studentname, dob FROM students;'''

Click the''' Execute query '''button.
|| Now type the command.'''SELECT studentname, dob FROM students;'''

Lets '''Execute '''the''' query'''.
|-
|| Highlight output.
|| Notice that only '''studentname '''and '''dob '''columns are displayed.Other columns are not shown in the output.
|-
||
|| Let us compare the results of both the queries.
|-
|| Split output view
|| The first query shows all columns from the table.

The second query shows only the selected columns.
|-
|| '''Slide 10'''

'''Summary'''

In this tutorial we have learnt about,
* '''SELECT''' statement.
* Asterisk(*) Operator

|| With this we come to the end of this tutorial.

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

'''Assignment'''

As an Assignment, '''
* Write a SELECT query to display only the gender
* Execute the query on the students table
* Observe the output

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

'''Thank you'''
|| This Spoken Tutorial is brought to you by EduPyramids Educational Services Private Limited SINE IIT Bombay.Thank you for joining.
|-
|}

@@ Line 66: / Line 66: @@
 |-
 || Show '''localhost''' server node
-|| Please ensure that you are connected to the '''Localhost''' '''PostgreSQL''' server.
+|| Please ensure that you are connected to the '''Localhost PostgreSQL''' server.
 |-
 || Select '''Studentdb'''
@@ Line 72: / Line 72: @@
 |-
 || Click '''students''' tableClick '''Columns '''node
-|| Let us click on the '''students''' table.Let us next click on the '''Columns''' node.
+|| Let us click on the '''students''' table.
 |-
 || '''Slide 7'''
@@ Line 123: / Line 125: @@
 |-
 || Highlight output.
-|| Notice that only '''studentname '''and '''dob '''columns are displayed.Other columns are not shown in the output.
+|| Notice that only '''studentname '''and '''dob '''columns are displayed.
 |-
 ||
@@ Line 161: / Line 165: @@
 '''Thank you'''
-|| This Spoken Tutorial is brought to you by EduPyramids Educational Services Private Limited SINE IIT Bombay.Thank you for joining.
+|| This Spoken Tutorial is brought to you by EduPyramids Educational Services Private Limited SINE IIT Bombay.
 |-
 |}

PostgreSQL-Database/C2/Basic-SELECT-Statement/English - Revision history

Madhurig at 11:29, 9 February 2026

Madhurig: Created page with "'''Title of the Script''': '''Basic SELECT Statement''' '''Author''': '''EduPyramids''' '''Keywords''': postgreSQL, pgadmin 4, SELECT statement, asterisk operator, retrieve..."