1 00:00:00,420 --> 00:00:00,840 All right. 2 00:00:00,840 --> 00:00:05,320 So I have some good news, which is that in the next video, we're going to start typing code. 3 00:00:05,340 --> 00:00:06,450 We're going to start with SQL. 4 00:00:06,870 --> 00:00:09,930 The bad news is that we still have to make it through this video. 5 00:00:10,500 --> 00:00:11,760 Hopefully it's not too painful. 6 00:00:11,790 --> 00:00:16,050 Essentially, what I want to talk about is different types of content in the course and how the course 7 00:00:16,050 --> 00:00:16,990 really works. 8 00:00:17,010 --> 00:00:21,770 It might be a little different than other courses you've taken online, depending on how they were structured. 9 00:00:21,780 --> 00:00:25,260 Basically, I break the content into a couple of different categories. 10 00:00:25,260 --> 00:00:32,580 The first are things like this video where it's a video of me talking usually with blue and you know, 11 00:00:32,580 --> 00:00:35,640 you don't have to watch them, but kind of just serve to introduce content. 12 00:00:36,420 --> 00:00:41,310 It's a way for me to kind of interact with you, to say hello and to set the stage for what comes next. 13 00:00:41,310 --> 00:00:44,640 And if you're someone who has no patience for that sort of thing, absolutely. 14 00:00:44,640 --> 00:00:45,240 Skip it. 15 00:00:45,360 --> 00:00:49,350 So then after that, we've got the actual content of the course, the lectures. 16 00:00:49,350 --> 00:00:54,750 So there are a ton of videos where it's mostly screencast and I'm explaining concepts. 17 00:00:54,780 --> 00:00:59,820 I usually make a bunch of diagrams, slides, I try and make things somewhat visually interesting. 18 00:00:59,820 --> 00:01:03,900 I'm not a great graphic designer, but try and keep things interesting to look at. 19 00:01:04,200 --> 00:01:08,220 And then I also type code and there's a lot to watch there ideally. 20 00:01:08,220 --> 00:01:13,410 So it's a combination of slides with me talking over it as well as diagrams and animations and then 21 00:01:13,410 --> 00:01:17,490 most of the time typing code in our text editors and running SQL code. 22 00:01:17,790 --> 00:01:19,470 So those are the lecture videos. 23 00:01:19,530 --> 00:01:25,380 But then we've also got and this is probably the most important part, more so even than the lectures 24 00:01:25,560 --> 00:01:27,030 which are the exercises. 25 00:01:27,030 --> 00:01:31,740 So one of the things that I think makes my courses stand out a bit, some of the feedback I've gotten 26 00:01:31,740 --> 00:01:36,870 has to do with exercises and activities, and I think the really, really central to making a good course. 27 00:01:36,870 --> 00:01:39,510 So I kind of throw them everywhere in the course. 28 00:01:39,630 --> 00:01:44,340 And then within those exercises we've got a couple of different categories of challenges. 29 00:01:44,340 --> 00:01:48,690 The first are what I would call Rapid Fire, basically pause the video. 30 00:01:48,720 --> 00:01:51,960 I'll ask you a question, very short quiz type questions. 31 00:01:51,960 --> 00:01:56,730 And then there are the second type of exercises which usually come at the end of a section, the last 32 00:01:56,730 --> 00:02:01,410 video typically, and it's an entire video dedicated to exercises. 33 00:02:01,710 --> 00:02:05,280 Usually there's like 5 to 10 challenges in that video. 34 00:02:05,280 --> 00:02:10,320 And then following that, there's always a solution video where I go over the solutions, I tell you 35 00:02:10,320 --> 00:02:12,720 the answer, and then also show you myself coding them. 36 00:02:12,720 --> 00:02:15,450 And as always, the solution code is available. 37 00:02:15,450 --> 00:02:17,370 If you don't care to see me, explain it. 38 00:02:17,370 --> 00:02:19,740 If you just want the code, you can get that at any time. 39 00:02:19,740 --> 00:02:22,800 And the final type of challenge is more comprehensive. 40 00:02:22,830 --> 00:02:27,990 It's essentially there are a couple of sections that are entirely devoted to exercises, so they might 41 00:02:27,990 --> 00:02:32,730 have seven or ten different videos, but they're all about one set of problems. 42 00:02:32,730 --> 00:02:34,290 So there's not many of these in the course. 43 00:02:34,290 --> 00:02:37,620 They take a while, but there are a couple of these challenge sections. 44 00:02:37,620 --> 00:02:40,530 So just to reiterate, we've got quick rapid fire questions. 45 00:02:40,530 --> 00:02:46,200 We've got more general kind of summation quizzes and exercises at the end of a section, and then we've 46 00:02:46,200 --> 00:02:48,180 got entire challenge sections. 47 00:02:48,180 --> 00:02:52,710 And of course after every lecture I include the code, all of the commands that I type. 48 00:02:52,710 --> 00:02:57,930 They're in a file that always comes after the lecture, and it always starts with the word code in all 49 00:02:57,930 --> 00:02:58,740 capital letters. 50 00:02:58,740 --> 00:03:04,050 So the last thing I'd like to add is a piece of advice, I guess, which is that I highly recommend 51 00:03:04,050 --> 00:03:06,450 you do the challenges and do these exercises. 52 00:03:06,480 --> 00:03:08,070 Obviously I have no control over that. 53 00:03:08,070 --> 00:03:11,460 You can just skip through everything and just take the pieces of the course you need. 54 00:03:11,460 --> 00:03:16,860 But if you're trying to get the full experience, kind of the way that I designed it, I would do all 55 00:03:16,860 --> 00:03:18,510 the exercises, do the challenges. 56 00:03:18,510 --> 00:03:24,090 Even if that means going at a slower pace, it definitely means you'll go at a slower pace, but you'll 57 00:03:24,090 --> 00:03:27,630 learn much better and hopefully you'll have a better experience. 58 00:03:27,630 --> 00:03:32,310 And with that said, the other component that's really important are the discussion forums. 59 00:03:32,310 --> 00:03:36,990 We have a full time to in the course as well as myself who are here to help you at any point. 60 00:03:36,990 --> 00:03:40,410 So absolutely lean on that, ask any questions you can come up with. 61 00:03:40,410 --> 00:03:41,370 We're here to help. 62 00:03:41,670 --> 00:03:42,510 All right. 63 00:03:42,540 --> 00:03:44,490 On to the code in the next section.