1 00:00:00,090 --> 00:00:05,100 So in this video, we're going to talk about one of the more common questions that comes up early on, 2 00:00:05,100 --> 00:00:09,870 which is what is the difference between my skull and skull? 3 00:00:10,020 --> 00:00:14,190 Or I usually just say skull, but what's the difference between these two? 4 00:00:14,190 --> 00:00:18,000 Obviously, skull as contained in the name of my skull. 5 00:00:18,390 --> 00:00:19,980 What's the significance of that? 6 00:00:21,060 --> 00:00:27,930 So let's start off with discussing Skull, which stands for structured query language. 7 00:00:28,140 --> 00:00:34,110 So Skull is the language that we use when we talk to our databases. 8 00:00:34,590 --> 00:00:42,810 It's the way that we interact and access the data, update data, delete things, and basically manipulate 9 00:00:42,810 --> 00:00:44,520 the data in our databases. 10 00:00:44,790 --> 00:00:50,280 It's the language we use, so it's how we do things like find all users. 11 00:00:50,940 --> 00:00:53,610 Now what I'm showing you here is not actual SQL code. 12 00:00:53,940 --> 00:00:55,470 You'll see that in just a second. 13 00:00:55,590 --> 00:00:57,990 These are just humanized versions. 14 00:00:58,500 --> 00:01:01,050 Find all users who are 18 years old. 15 00:01:02,130 --> 00:01:08,620 Add a new user with username jambo Jim or if we want to get crazy, delete every single user. 16 00:01:08,640 --> 00:01:12,950 So these are the sort of things that we use SQL to do. 17 00:01:12,960 --> 00:01:17,670 So we write these lines which are called queries, structured query language. 18 00:01:18,330 --> 00:01:24,270 And once we hit Enter or once we run that SQL code, it's executed and it goes off and it talks to our 19 00:01:24,270 --> 00:01:26,010 database and it does it for us. 20 00:01:27,060 --> 00:01:30,930 So if you are curious of what it looks like, here's a really quick one. 21 00:01:30,930 --> 00:01:41,820 Line preview the English version find all users who are 18 or older is translated into this select star 22 00:01:41,820 --> 00:01:46,860 from users where age is greater than or equal to 18 semicolon. 23 00:01:47,520 --> 00:01:50,250 So hopefully that actually seems pretty straightforward. 24 00:01:50,340 --> 00:01:54,480 Now we're going to dive into SQL all throughout this course. 25 00:01:54,900 --> 00:01:57,120 You don't need to worry about this exact statement. 26 00:01:57,150 --> 00:02:03,270 What's important, though, is that you can see there is a special syntax we use and that this query 27 00:02:03,270 --> 00:02:06,750 here is going to be sent off to interact with the database somewhere. 28 00:02:07,080 --> 00:02:14,040 So the next point I want to make is that when we work with my SQL, we're actually writing SQL all the 29 00:02:14,040 --> 00:02:14,580 time. 30 00:02:15,030 --> 00:02:21,810 So my SQL is what we talked about earlier, a database management system, and there's a bunch of them 31 00:02:21,810 --> 00:02:22,500 out there. 32 00:02:23,340 --> 00:02:24,720 Here's some common ones. 33 00:02:24,720 --> 00:02:27,120 Post Grass, SQL Light, Oracle. 34 00:02:27,150 --> 00:02:33,150 There's hundreds of others and there's dozens of popular ones, but hundreds of them all over the world 35 00:02:33,150 --> 00:02:34,710 that maybe aren't as popular. 36 00:02:35,040 --> 00:02:39,900 So all of these ones here that I've highlighted use SQL or SQL. 37 00:02:39,960 --> 00:02:45,000 That doesn't mean every database ever does, but what are called relational databases do. 38 00:02:45,000 --> 00:02:47,990 And we'll talk more about that later when we discuss tables. 39 00:02:48,000 --> 00:02:55,530 But for now, the point I want to make is that SQL is not unique to my SQL or to post press. 40 00:02:56,310 --> 00:02:58,740 That's why they all have this SQL in their name. 41 00:02:58,920 --> 00:03:00,900 They share this language. 42 00:03:00,900 --> 00:03:02,940 So structured query language. 43 00:03:02,940 --> 00:03:11,350 SQL is a standard basically that these relational database management systems like my SQL implement. 44 00:03:11,370 --> 00:03:14,310 So it's kind of a lot of jargon and terminology again. 45 00:03:14,310 --> 00:03:20,490 But the main takeaway is that when we use something like SQL, we'll actually be writing SQL all the 46 00:03:20,490 --> 00:03:20,970 time. 47 00:03:21,930 --> 00:03:30,300 So here's an example of what a line of SQL code looks like to do the exact same thing in a my SQL database 48 00:03:30,300 --> 00:03:32,310 and a post stress database. 49 00:03:33,450 --> 00:03:39,750 Here's the my SQL and here's the post graphs and hopefully you notice they are identical. 50 00:03:39,780 --> 00:03:43,380 Both of these are different database management systems. 51 00:03:44,010 --> 00:03:48,360 They have differences to them, but they both use SQL. 52 00:03:48,390 --> 00:03:51,750 You will be writing SQL when you interact with these databases. 53 00:03:53,250 --> 00:03:56,750 So just to hit that home, there are slight differences in the syntax. 54 00:03:56,760 --> 00:04:01,200 They are not identical, but they're very, very similar. 55 00:04:02,250 --> 00:04:06,230 Oh, and I better not forget to mention the SQL standard. 56 00:04:06,240 --> 00:04:11,310 So the way that this whole thing works is that there is a standard for how SQL should work. 57 00:04:11,700 --> 00:04:13,560 It's it's actually written down. 58 00:04:13,560 --> 00:04:14,850 You can read it online. 59 00:04:14,850 --> 00:04:21,870 And all of these different database management systems basically are tasked with implementing that standard 60 00:04:21,870 --> 00:04:23,760 in their own database and making it work. 61 00:04:23,760 --> 00:04:28,770 And they deviate sometimes a little bit, but for the most part, they're very, very similar. 62 00:04:29,610 --> 00:04:36,810 So the two takeaways here, one is that once you learn SQL, it's really not that hard to switch to 63 00:04:36,810 --> 00:04:39,270 another database that also uses SQL. 64 00:04:39,270 --> 00:04:41,190 So you're learning my SQL. 65 00:04:41,220 --> 00:04:47,940 You could pretty easily switch to post grass or to SQL light with not a lot of time needed to get up 66 00:04:47,940 --> 00:04:48,630 to speed. 67 00:04:49,320 --> 00:04:55,680 And the second thing is that what makes databases or database management systems, to be specific, 68 00:04:55,680 --> 00:04:59,700 what makes them unique are the features that they offer. 69 00:05:00,210 --> 00:05:03,110 Not the sequel or the language itself. 70 00:05:03,120 --> 00:05:08,490 So if we go back to this diagram, all of these use SQL, but that doesn't mean that they're identical. 71 00:05:08,880 --> 00:05:13,050 And yes, you might write the same line of code to do the same thing here. 72 00:05:13,320 --> 00:05:19,890 So what makes these different are the features that they implement, things like how secure is one versus 73 00:05:19,890 --> 00:05:20,230 the other? 74 00:05:20,230 --> 00:05:20,940 Or How? 75 00:05:20,970 --> 00:05:22,330 How fast is it? 76 00:05:22,350 --> 00:05:23,010 How much? 77 00:05:23,010 --> 00:05:24,570 How big is the download? 78 00:05:25,380 --> 00:05:27,200 How do user permissions work? 79 00:05:27,210 --> 00:05:28,260 And on and on and on. 80 00:05:28,260 --> 00:05:33,120 And we'll talk more about what those differences are when we get to a point where they actually make 81 00:05:33,120 --> 00:05:34,110 a little bit more sense. 82 00:05:34,110 --> 00:05:35,370 I don't want to just talk at you. 83 00:05:36,480 --> 00:05:40,320 So this was about my SQL versus SQL. 84 00:05:40,410 --> 00:05:42,570 SQL is structured query language. 85 00:05:42,570 --> 00:05:50,100 It exists separately from my SQL, and my SQL is a database management system that implements SQL.