PostgreSQL-Database/C2/Alias-Names/English - Revision history

Madhurig at 09:54, 28 April 2026

2026-04-28T09:54:48Z

Madhurig at 09:39, 28 April 2026

2026-04-28T09:39:09Z

Madhurig at 09:36, 28 April 2026

2026-04-28T09:36:30Z

Madhurig at 09:34, 28 April 2026

2026-04-28T09:34:16Z

ANJALISATDIVE at 10:06, 27 April 2026

2026-04-27T10:06:32Z

ANJALISATDIVE at 10:06, 27 April 2026

2026-04-27T10:06:04Z

ANJALISATDIVE at 10:05, 27 April 2026

2026-04-27T10:05:41Z

ANJALISATDIVE: Created page with "Title of the Script: Alias Names Author: EduPyramids Keywords: PostgreSQL, pgAdmin 4, alias, AS keyword, space, underscore, double quotes, video tutorial, EduPyramids. {|..."

2026-04-27T09:54:11Z

Created page with "Title of the Script: Alias Names Author: EduPyramids Keywords: PostgreSQL, pgAdmin 4, alias, AS keyword, space, underscore, double quotes, video tutorial, EduPyramids. {|..."

New page

Title of the Script: Alias Names

Author: EduPyramids

Keywords: PostgreSQL, pgAdmin 4, alias, AS keyword, space, underscore, double quotes, video tutorial, EduPyramids.

{| border=1
|-
! width="35%" | '''Visual Cue'''
! width="65%" | '''Narration'''

|-
|| '''Title Slide 1'''
|| Welcome to this Spoken Tutorial on '''Alias Names''' in '''PostgreSQL'''.

|-
|| '''Slide 2'''
'''Learning Objectives'''
|| In this tutorial, we will learn to,

* Create alias names using:
* space,
* AS keyword,
* underscore and
* double quotes.

|-
|| '''Slide 3'''
'''System Requirements'''

'''To record this tutorial, I am using'''

• '''Ubuntu 24.04 LTS,'''

• '''PostgreSQL version 18.1, and'''

• '''pgAdmin 4 version 9.11.'''

|| To record this tutorial, I am using the following setup.

|-
|| '''Slide 4'''
'''Pre-requisites'''
|| To follow this tutorial,
* Learners should have '''PostgreSQL''' and '''pgAdmin 4'''
* For the prerequisite '''PostgreSQL''' tutorials, please visit this website.

|-
|| '''Slide 5'''
'''Code Files'''
The following code file is required to practice this tutorial:

• '''an-commands.txt'''

This file is provided in the Code Files link on this tutorial page.

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

This file is provided in the '''Code Files''' link of this tutorial page.

Please download and extract the file.

|-
||
|| Let us get started.

|-
|| '''Point to the interface.'''
|| I have opened the '''pgAdmin 4''' interface and connected to the localhost server.

|-
|| Display the students table
Type: **SELECT * FROM students;**
|| Let us display the student table.
Type the following query.
Click on the Execute query icon to run the query.
Notice the student table with all the records.

|-
|| '''Slide 5'''
'''What is an Alias?'''
|| Let us see what an alias is?
An alias is a temporary name given to a column or a table.
It improves the readability of the output.
Alias names exist only for the duration of the query.

|-
|| '''Type:'''
'''SELECT studentname fullname FROM students;'''
|| Let us create an alias using a '''space'''.
Type the following query.

|-
|| Highlight '''studentname fullname'''
|| Here, '''studentname''' is the original column name.
'''fullname''' is the alias given using a '''space'''.

|-
|| Click on the execute query button.
|| Click on the '''Execute query''' button to execute the query.
The output displays the '''studentname''' column with the new heading '''fullname'''.

|-
|| '''Type:'''
'''SELECT city AS studentcity FROM students;'''
|| Now let us create an '''alias''' using the '''as''' keyword.
Type the following query.

|-
|| '''Highlight city AS studentcity'''
|| Here, '''AS''' keyword explicitly assigns the '''alias''' name '''studentcity''' to the '''city''' column.

|-
|| Click the '''Execute query''' icon
Point to the output..
|| Let us execute the query.
Observe the output.
The original column name '''city''' is now replaced with '''studentcity'''.

|-
|| Type: '''SELECT studentid AS student_id FROM students;'''
|| Now let us use an '''underscore''' in the '''alias''' name.
Type the following query.

|-
|| Highlight '''student_id'''
|| Here, '''student_id''' is the '''alias''' name.
The '''underscore''' is used to separate words for better readability.

|-
|| Click the Execute query icon.
|| Let us execute the query.
The column heading is now changed to '''student_id'''.

|-
|| '''Highlight: SELECT studentid AS student_id FROM students;'''
'''Type:'''
'''SELECT studentid student_id FROM students;'''
|| Here the '''AS''' keyword is optional, it means the query runs with or without '''AS'''.
Let us type this query and execute it.
Both the queries give the same result.

|-
|| Type: '''SELECT cgpa AS "Student cgpa" FROM students;'''
|| Now let us create an alias using double quotes. Type the following query.

|-
|| Highlight '''"student cgpa"'''
|| Here double quotes allow us to include spaces in the '''alias''' name.
Double quotes are required when the '''alias''' contains spaces.

|-
|| Click the '''Execute query''' icon.
|| Let us execute the query.
The column heading '''cpga''' is now changed to '''student cgpa'''.

|-
|| Type: **SELECT * FROM students;**
|| '''Alias''' names are temporary and do not modify the actual table structure.
To check, let us type this query and execute it.
Observe that the actual table is not modified.

|-
|| '''Slide 7'''
'''Summary'''
In this tutorial we have learnt to,

• Create alias names using:

• space,

• AS keyword,

• underscore and

• double quotes.

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

Let us summarise.

|-
|| '''Slide 8'''
'''Assignment'''

'''As an assignment,'''

Create alias names for gender and date of birth columns using different methods of aliasing.
SELECT * FROM students;

|| As an assignment, please do the following.

|-
|| '''Slide 9'''
'''Thank You'''

This Spoken Tutorial is brought to you by EduPyramids Educational Private Limited, SINE IIT Bombay.

|| Thank you.

|}

@@ Line 158: / Line 158: @@
 '''SELECT studentid student_id FROM students;'''
-|| Here the '''AS''' keyword is optional, it means the query runs with or without '''AS'''.
+|| Here the '''AS''' keyword is optional, it means the query runs with or without '''AS''' keyword.
 Let us type this query and execute it.
 Both the queries give the same result.

@@ Line 213: / Line 213: @@
 Create alias names for gender and date of birth columns using different methods of  aliasing.
-SELECT * FROM students;
 || As an assignment, please do the following.

@@ Line 93: / Line 93: @@
 '''What is an Alias?'''
 || Let us see what an alias is?
 An alias is a temporary name given to a column or a table.
 It improves the readability of the output.

← Older revision		Revision as of 09:34, 28 April 2026
Line 60:		Line 60:

	This file is provided in the Code Files link on this tutorial page.		This file is provided in the Code Files link on this tutorial page.
		+
		+	Please download and extract the file.

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

@@ Line 183: / Line 183: @@
 |-
 || '''Slide 7'''
 '''Summary'''
 In this tutorial we have learnt to,
@@ Line 202: / Line 204: @@
 |-
 || '''Slide 8'''
 '''Assignment'''

← Older revision		Revision as of 10:06, 27 April 2026
Line 54:		Line 54:

	'''Code Files'''		'''Code Files'''
		+
	The following code file is required to practice this tutorial:		The following code file is required to practice this tutorial:

@@ Line 16: / Line 16: @@
 |-
 || '''Slide 2'''
 '''Learning Objectives'''
 || In this tutorial, we will learn to,
@@ Line 28: / Line 29: @@
 |-
 || '''Slide 3'''
 '''System Requirements'''
@@ Line 42: / Line 44: @@
 |-
 || '''Slide 4'''
 '''Pre-requisites'''
 || To follow this tutorial,
@@ Line 49: / Line 52: @@
 |-
 || '''Slide 5'''
 '''Code Files'''
 The following code file is required to practice this tutorial:
@@ Line 72: / Line 76: @@
 |-
 || Display the students table
-Type: **SELECT * FROM students;**
 || Let us display the student table.
 Type the following query.
@@ Line 88: / Line 96: @@
 |-
 || '''Type:'''
 '''SELECT studentname fullname FROM students;'''
 || Let us create an alias using a '''space'''.
 Type the following query.
@@ Line 94: / Line 104: @@
 |-
 || Highlight '''studentname fullname'''
 || Here, '''studentname''' is the original column name.
 '''fullname''' is the alias given using a '''space'''.
@@ Line 120: / Line 132: @@
 |-
-|| Type: '''SELECT studentid AS student_id FROM students;'''
+|| Type:
 || Now let us use an '''underscore''' in the '''alias''' name.
 Type the following query.
@@ Line 126: / Line 140: @@
 |-
 || Highlight '''student_id'''
 || Here, '''student_id''' is the '''alias''' name.
 The '''underscore''' is used to separate words for better readability.
@@ Line 135: / Line 150: @@
 |-
-|| '''Highlight:  SELECT studentid AS student_id FROM students;'''
+|| '''Highlight: SELECT studentid AS student_id FROM students;'''
 '''Type:'''
 '''SELECT studentid student_id FROM students;'''
 || Here the '''AS''' keyword is optional, it means the query runs with or without '''AS'''.
@@ Line 157: / Line 173: @@
 |-
-|| Type:  **SELECT * FROM students;**
+|| Type:
 || '''Alias''' names are temporary and do not modify the actual table structure.
 To check, let us type this query and execute it.