Original subtitles

0 Hi Everyone 1

In the last video 2

We learned about advanced pattern matching 3

And it's time to test our knowledge out 4

In the first activity you have to find out 5

All customers 6

Whose first and last name are of 5 characters each 7

The first name is also 5 characters last name is also 5 characters 8

And the last name starting with 9

A or B or c or D 10

And for your second activity 11

Very often we encounter such a problem 12

Where are database contains 13

Zip code or pin code values 14

And it has a lot of junk values in it 15

I want you to find out the valid zip codes 16

From this table 17

You have to create this table first you know how to create a table 18

It was in the initial parts of this course 19

If you do not remember it please visit the create table video section 20

To create this table zip code 21

And enter this values 22

Once you have inserted these values 23

Find out the valid zip code 24

Where the check for a valid zip code is that it will have only numeric characters 25

And its length should be either 5 or 6 26

So for example sdfe4 should not be part of the result set 27

If you are able to do these two activities 28

You are ready to do some advanced pattern searching also 29

If you faced any difficulty throughout the course 30

You can post your doubt in the discussion forum 31

And do remember to rate and give your feedback about this course 32

And congratulations 33

On earning your certificate in SQL, Thanks