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.