Original subtitles

0 Hi everyone 1

So now we have covered all the string functions 2

In string functions you learnt how to find out length of characters 3

Change characters to upper or lowercase 4

Find out substrings in a string 5

Trim extra spaces or any other extra special character from a string 6

And to create an aggregate string 7

Let us test this out in this exercise 8

First 9

I want you to find out 10

The product name 11

Which has maximum length. so out of all the product names 12

Which product name has the maximum length 13

Next let us see if you are able to do concatenation 14

I wanted to join product name subcategory and category from the product table into a column 15

Called product details 16

So 17

Your resultset will have four columns 18

Product name 19

Sub category category 20

And the fourth one is product details which is concatenation of the previous three columns 21

In the third activity 22

If you go and look at the product IDs 23

In your product table 24

you will see it consists of three parts 25

Which is separated by hyphens 26

Analyze these three parts 27

Check the length of all these three parts and separate these three parts out so in your resultset 28

What I want is 29

Your first column should be the product ID 30

The second column should have the first part of the product ID 31

Third column should have the second part of product ID and fourth column should have the third part of product ID 32

And in the last activity 33

You have to get a list of all the 34

Chairs or tables 35

From your products table 36

So wherever subcategory is chairs or tables 37

I want you to get the list of all those products 38

and aggregate those product names 39

Into a comma separated list 40

So in your final table it will have only two rows 41

In the First row 42

It will have 43

List of all shares which are separated by comma 44

And in the second row it will have list of all tables separated by comma 45

If you are able to do this exercise 46

You have successfully learnt the lesson taught in the 47

String functions section and you are now ready to move to next section