1
00:00:00,180 --> 00:00:04,830
Now that we have our basic CRUD arsenal, create, read, update, delete.

2
00:00:05,340 --> 00:00:09,150
Those are the basic operations we perform all the time in the world of SQL.

3
00:00:09,180 --> 00:00:12,850
It's time to start building up on them or leveling them up.

4
00:00:12,870 --> 00:00:19,050
And what you'll see throughout this course is that a lot of what we do in SQL is based around writing

5
00:00:19,050 --> 00:00:21,240
fancy select queries.

6
00:00:21,360 --> 00:00:26,550
You will insert data, sure, but when you insert, it's pretty much always the same basic pattern.

7
00:00:26,550 --> 00:00:29,190
You insert something or you insert multiple rows.

8
00:00:29,670 --> 00:00:34,260
When you delete, when you update, you can get fancy, you can write fancy selections.

9
00:00:34,260 --> 00:00:40,890
But certainly when we actually are selecting data and trying to learn about our information, we'll

10
00:00:40,890 --> 00:00:45,510
write pretty complicated things, especially when we start working with multiple tables at the same

11
00:00:45,510 --> 00:00:46,890
time and combining them.

12
00:00:47,100 --> 00:00:50,490
So we're going to be working with Select in this particular section.

13
00:00:50,490 --> 00:00:54,720
We're going to be talking about some of the built in string functions.

14
00:00:54,720 --> 00:01:00,930
Now, string functions are different built in operations that we can perform on text columns.

15
00:01:01,260 --> 00:01:02,400
So there's a bunch of them.

16
00:01:02,400 --> 00:01:06,330
This is the docs in my SQL string functions and operators.

17
00:01:06,330 --> 00:01:10,470
We are not going to cover, not even close to half of these.

18
00:01:10,470 --> 00:01:14,910
We're going to cover, I don't know, seven, eight, nine of the more useful ones.

19
00:01:14,910 --> 00:01:19,860
But there's things in here that help us uppercase and lowercase text to find the length of text, to

20
00:01:19,860 --> 00:01:26,820
reverse text, to replace parts of text, lots of different operations, and they all have to do with

21
00:01:26,820 --> 00:01:27,420
text.

22
00:01:27,420 --> 00:01:33,490
And right now we know one column type, one data type that is a text type, which is var car or var

23
00:01:33,490 --> 00:01:34,020
char.

24
00:01:34,200 --> 00:01:38,490
So nothing to do with numbers, all to do with strings or text.

25
00:01:38,490 --> 00:01:40,470
So that's what we're going to do in this section.

26
00:01:40,470 --> 00:01:44,850
But first, I want us to work with some new data and I want us to all be on the same page with the same

27
00:01:44,850 --> 00:01:48,930
data, set the same rows so that we can get the same results when we select.

28
00:01:48,930 --> 00:01:52,080
So in the next video, we're going to quickly set up a new table.