All language subtitles for 3. Exercise 16 Pattern Matching

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