Original subtitles

0 Till now we have learnt how to sort filter the data and how to limit the number of rows 1

That we want to 2

Retrieve 3

Now 4

The data that we have received, if you want to get different column name on that table 5

The as keyword is used 6

As will assign an alias to the column name or the table name 7

Why it is used 8

So sometimes you have written a complex function or you have added operators 9

While retrieving the data 10

Your column name will display all those things 11

You want a meaningful name on the column 12

When you have retrieved the data 13

So that is why 14

And as the word is used 15

To provide the second name to that column or to that table 16

What is the syntax for as 17

It is select column name as 18

the alias 19

So you mention the 20

Column name first 21

And then you mention alias 22

From table name 23

You can also mention the table alias 24

For example 25

If you want to give your customer data to some other agency 26

You would like to change the column headers 27

Cust ID will not mean anything to the agency 28

Single change cust ID to serial number 29

Customer underscore name to name and age 30

as Customer's age 31

We'll write this query 32

In the PG admin 33

I am starting the as query now select 34

Customer ID 35

Customer ID as 36

Serial number 37

Since the word serial number has a space in between you need to use the double 38

Quotation mark 39

We need the customer name as name 40

Since name does not have any space bar in between 41

Will not put the 42

Double quotation marks 43

And age we need as the customer age 44

From 45

The table name which is customer 46

Before running this 47

Note that customer ID is written as 48

The column customer ID is showing customer underscore ID 49

Customer name is showing as customer underscore name and age is written as age 50

Now, Let us run this 51

you can see 52

In the output 53

The column name is serial number 54

Name and customer_age 55

Only the aliases 56

that we provided are shown and not the original column name 57

Providing aliases to column names is important when you are having Complex functions mentioned in the query 58

Providing aliases to tables is important when you are using the joins 59

We'll be discussing joins in the later part of the course when we understand the joins will also 60

Revisit the as keyword there 61

So in this lecture we learnt how to provide alias to columns 62

In the next lecture we will learn about some aggregate functions 63

Such as sum, count, average etc 64

See you in the next video