1 00:00:01,020 --> 00:00:01,890 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,350 Thank you, Siri. 10 00:00:15,500 --> 00:00:16,550 Can you just say hello? 11 00:00:16,550 --> 00:00:17,480 Not sing it. 12 00:00:17,630 --> 00:00:17,920 Hi. 13 00:00:18,110 --> 00:00:21,580 Cold wants me to say hello and welcome to the next section. 14 00:00:21,590 --> 00:00:22,760 Thank you, Siri. 15 00:00:23,870 --> 00:00:25,700 So as Siri said hi. 16 00:00:25,700 --> 00:00:27,140 Welcome to the next section. 17 00:00:27,140 --> 00:00:30,140 This section is all about logical operators. 18 00:00:30,140 --> 00:00:35,030 So if you come from a programming language or you have any programming experience, you have probably 19 00:00:35,030 --> 00:00:40,610 stumbled across logical operators, things like logical and and logical or there's a bunch of others, 20 00:00:40,610 --> 00:00:42,230 but those are the primary two. 21 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. 22 00:00:45,860 --> 00:00:47,570 That's what this section is all about. 23 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. 24 00:00:52,940 --> 00:00:58,970 And it will serve as a way to show you how they work in my SQL, or it will serve to both introduce 25 00:00:58,970 --> 00:01:01,280 them and to show you how they work in my SQL. 26 00:01:01,310 --> 00:01:03,380 Either way, they're really powerful. 27 00:01:03,380 --> 00:01:04,640 I'm not going to say they're important. 28 00:01:04,640 --> 00:01:07,820 They are important, but I'm just overusing that phrase in these videos. 29 00:01:08,210 --> 00:01:09,530 Everything's important here. 30 00:01:09,530 --> 00:01:14,420 But these allow us to string together different queries and make more complex selections. 31 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 32 00:01:21,590 --> 00:01:27,350 based off of a color right now, all we could do is select all cars that have a color of exactly blue 33 00:01:27,350 --> 00:01:34,760 or a color that contains the word blue, like, I don't know, sky blue or seashore blue or something 34 00:01:34,760 --> 00:01:35,360 like that. 35 00:01:35,840 --> 00:01:36,680 That's fine. 36 00:01:36,680 --> 00:01:43,190 But what if you also wanted to select all cars that were blue or that were red again? 37 00:01:43,190 --> 00:01:47,000 I said, contrived and silly, but the idea is we can string things together. 38 00:01:47,000 --> 00:01:50,420 So rather than having to do two queries, we could put them together. 39 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 40 00:01:55,940 --> 00:01:57,950 of that section, last of our books data. 41 00:01:57,950 --> 00:02:04,820 We could make more complex selections like select all books that have a price below $20. 42 00:02:04,820 --> 00:02:09,740 And at the same time they're, I don't know, we have 50 copies in stock. 43 00:02:10,160 --> 00:02:16,520 Or we could do something like select all books written by a certain author before the year 1990. 44 00:02:16,520 --> 00:02:18,530 So two different components, right? 45 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 46 00:02:23,420 --> 00:02:24,050 together. 47 00:02:24,050 --> 00:02:25,880 We need to use a logical operator. 48 00:02:25,880 --> 00:02:27,230 All right, I'm rambling a little bit. 49 00:02:27,230 --> 00:02:28,160 I apologize. 50 00:02:28,460 --> 00:02:30,440 This section is on logical operators. 51 00:02:30,470 --> 00:02:32,150 Lots of exercises, of course. 52 00:02:32,150 --> 00:02:33,140 Like always. 53 00:02:33,530 --> 00:02:34,970 Hopefully they're enjoyable. 54 00:02:34,970 --> 00:02:39,350 If not, well, like I said, it is of course on databases. 55 00:02:39,350 --> 00:02:40,790 So I'm trying. 56 00:02:40,790 --> 00:02:41,570 I really am. 57 00:02:42,320 --> 00:02:42,920 Yeah. 58 00:02:43,470 --> 00:02:44,480 Okay, I'm going to stop.