1
00:00:01,020 --> 00:00:01,920
Siri, can you.

2
00:00:02,250 --> 00:00:03,360
Can you say hello?

3
00:00:03,690 --> 00:00:04,200
Hello?

4
00:00:04,200 --> 00:00:04,840
It's me.

5
00:00:04,860 --> 00:00:09,340
I was wondering if, after all these years you'd like to meet to go over everything.

6
00:00:09,360 --> 00:00:11,580
They say that time is supposed to heal you.

7
00:00:11,610 --> 00:00:13,140
But I ain't done much dealing.

8
00:00:14,030 --> 00:00:14,340
Okay.

9
00:00:14,360 --> 00:00:15,320
Thank you, Siri.

10
00:00:15,500 --> 00:00:16,550
Can you just say hello?

11
00:00:16,550 --> 00:00:21,590
Not sing it cold wants me to say hello and welcome to the next section.

12
00:00:21,590 --> 00:00:22,760
Thank you, Siri.

13
00:00:23,870 --> 00:00:25,700
So, as Siri said, Hi.

14
00:00:25,700 --> 00:00:27,140
Welcome to the next section.

15
00:00:27,140 --> 00:00:30,140
This section is all about logical operators.

16
00:00:30,140 --> 00:00:35,360
So if you come from a programming language or have any programming experience, you have probably stumbled

17
00:00:35,360 --> 00:00:41,120
across logical operators, things like logical and and logical or there's a bunch of others, but those

18
00:00:41,120 --> 00:00:42,230
are the primary two.

19
00:00:42,260 --> 00:00:45,860
If you haven't, if you have no idea what I'm talking about, don't panic.

20
00:00:45,860 --> 00:00:47,570
That's what this section is all about.

21
00:00:47,570 --> 00:00:52,940
So this will either serve as a review if you know how to program or if you know logical operators,

22
00:00:52,940 --> 00:00:59,240
and it will serve as a way to show you how they work in my SQL or it will serve to both introduce them

23
00:00:59,240 --> 00:01:01,280
and to show you how they work in my SQL.

24
00:01:01,310 --> 00:01:03,380
Either way, they're really powerful.

25
00:01:03,380 --> 00:01:04,640
I'm not going to say they're important.

26
00:01:04,640 --> 00:01:07,790
They are important, but I'm just overusing that phrase in these videos.

27
00:01:08,210 --> 00:01:13,010
Everything's important here, but these allow us to string together different queries and make more

28
00:01:13,010 --> 00:01:14,420
complex selections.

29
00:01:14,540 --> 00:01:21,590
So if I were to give you a really contrived, idiotic example like cars, and I want to select all cars

30
00:01:21,590 --> 00:01:27,380
based off of a color right now, all we could do is select all cars that have a color of exactly blue

31
00:01:27,380 --> 00:01:34,760
or a color that contains the word blue, like, I don't know, sky blue or seashore blue or something

32
00:01:34,760 --> 00:01:35,360
like that.

33
00:01:35,840 --> 00:01:36,680
That's fine.

34
00:01:36,680 --> 00:01:42,200
But what if you also wanted to select all cars that were blue or that were red?

35
00:01:42,830 --> 00:01:47,000
Again, I said contrived and silly, but the idea is we can string things together.

36
00:01:47,000 --> 00:01:50,420
So rather than having to do two queries, we could put them together.

37
00:01:50,420 --> 00:01:55,940
Or if we go to our books example, which by the way, we're about to finish with, this is the last

38
00:01:55,940 --> 00:01:57,950
of that section, last of our books data.

39
00:01:57,950 --> 00:02:04,820
We could make more complex selections like select all books that have a price below $20.

40
00:02:04,820 --> 00:02:11,060
And at the same time they're, I don't know, we have 50 copies in stock, or we could do something

41
00:02:11,060 --> 00:02:16,520
like select all books written by a certain author before the year 1990.

42
00:02:16,520 --> 00:02:18,530
So two different components, right?

43
00:02:18,530 --> 00:02:23,420
We could select all books before 1990, select all books written by a certain author, but put them

44
00:02:23,420 --> 00:02:24,020
together.

45
00:02:24,020 --> 00:02:25,880
We need to use a logical operator.

46
00:02:25,880 --> 00:02:26,270
All right.

47
00:02:26,270 --> 00:02:27,230
I'm rambling a little bit.

48
00:02:27,230 --> 00:02:28,190
I apologize.

49
00:02:28,460 --> 00:02:30,440
This section is on logical operators.

50
00:02:30,470 --> 00:02:33,140
Lots of exercises, of course, like always.

51
00:02:33,530 --> 00:02:35,000
Hopefully they're enjoyable.

52
00:02:35,000 --> 00:02:35,930
If not.

53
00:02:36,290 --> 00:02:39,350
Well, like I said, it is, of course, some databases.

54
00:02:39,350 --> 00:02:40,790
So I'm trying.

55
00:02:40,790 --> 00:02:41,570
I really am.

56
00:02:42,320 --> 00:02:42,920
Yeah.

57
00:02:43,470 --> 00:02:43,700
Okay.

58
00:02:43,790 --> 00:02:44,510
I'm going to stop.

