WEBVTT 00:00.060 --> 00:05.490 So in this video we're going to talk about one of the more common questions that comes up early on which 00:05.490 --> 00:12.410 is what is the difference between my ask her will and as well or I usually just say sequel. 00:12.450 --> 00:14.110 But what's the difference between these two. 00:14.220 --> 00:17.490 Obviously sequel is contained in the name of my essay. 00:17.520 --> 00:20.730 Well what's the significance of that. 00:21.180 --> 00:28.320 So let's start off with discussing sequel which stands for structured query language. 00:28.320 --> 00:34.470 So the sequel is the language that we use when we talk to our databases. 00:34.710 --> 00:42.750 It's the way that we interact and access the data update data delete things and basically manipulate 00:42.750 --> 00:44.840 the data in our databases. 00:44.910 --> 00:51.090 It's the language we use so it's how we do things like find all users. 00:51.090 --> 00:55.560 Now what I'm showing you here is not actual sequel code you'll see that in just a second. 00:55.620 --> 00:58.200 These are just humanised versions. 00:58.560 --> 01:01.640 Find all users who are 18 years old. 01:02.220 --> 01:07.160 Add a new user with username jumbo Jim or if you want to get crazy. 01:07.200 --> 01:08.600 Delete every single user. 01:08.790 --> 01:12.990 So these are the sort of things that we use sequel to do. 01:13.140 --> 01:18.150 So we write these lines which are called queries structured query language. 01:18.480 --> 01:24.150 And once we hit enter or once we run that sequence code it's executed and it goes off and it talks to 01:24.150 --> 01:27.210 our database and it does it for us. 01:27.210 --> 01:32.760 So if you are curious what it looks like here's a really quick one line preview. 01:33.000 --> 01:42.780 The English version find all users who are 18 or older is translated into this select star from users 01:43.110 --> 01:47.440 where age is greater than or equal to 18 semi-colon. 01:47.640 --> 01:50.370 So hopefully that actually seems pretty straightforward. 01:50.560 --> 01:52.980 Now we're going to dive into a sequel. 01:53.130 --> 01:57.120 All throughout this course you don't need to worry about this exact statement. 01:57.300 --> 02:03.450 What's important though is that you can see there is a special syntax we use and that this query here 02:03.450 --> 02:06.830 is going to be sent off to interact the database somewhere. 02:07.170 --> 02:13.770 So the next point I want to make is that when we work with my AS Well we're actually writing sequel 02:13.770 --> 02:14.670 all the time. 02:15.150 --> 02:18.350 So my S Q Will is what we talked about earlier. 02:18.360 --> 02:22.990 A database management system and there's a bunch of them out there. 02:23.430 --> 02:24.730 Here's some common ones. 02:24.800 --> 02:27.130 Post gresse sequel light Oracle. 02:27.210 --> 02:33.000 Those hundreds of others and there's dozens of popular ones but hundreds of them all over the world 02:33.270 --> 02:34.830 that maybe aren't as popular. 02:35.160 --> 02:39.860 So all of these ones here that I've highlighted use as Cuil or sequel. 02:40.020 --> 02:42.390 That doesn't mean every database ever does. 02:42.700 --> 02:45.000 But what are called relational databases do. 02:45.000 --> 02:47.950 And we'll talk more about that later when we discussed tables. 02:48.150 --> 02:55.920 But for now the point I want to make is that as well it's not unique to my school or to postscripts. 02:56.340 --> 02:59.080 That's why they all have this as Cuil in their name. 02:59.100 --> 03:07.950 They share this language so structured query language sequel is a standard basically that these relational 03:07.950 --> 03:11.530 database management systems like my Escuela implement. 03:11.550 --> 03:16.680 So it's kind of a lot of jargon and terminology again but the main takeaway is that when we use something 03:16.680 --> 03:21.360 like my Eskil will actually be writing sequel all the time. 03:21.960 --> 03:29.730 So here's an example of what a line of sequel code looks like to do the exact same thing in my sequel 03:29.730 --> 03:32.820 database and a postgresql database. 03:33.480 --> 03:35.430 Here's the my as well. 03:35.610 --> 03:39.860 And here's the post press and hopefully you notice they are identical. 03:39.870 --> 03:43.910 Both of these are different database management systems. 03:44.100 --> 03:48.380 They have differences to them but they both use as well. 03:48.390 --> 03:53.240 You will be writing as well when you interact with these databases. 03:53.400 --> 03:56.720 So just to hit that home there are slight differences in the syntax. 03:56.880 --> 04:01.610 They are not identical but they are very very similar. 04:02.280 --> 04:06.420 Oh and I'd better not forget to mention the sequel standard. 04:06.420 --> 04:11.830 So the way that this whole thing works is that there is a standard for how sequels should work. 04:11.870 --> 04:13.470 It's kind of it's actually written down. 04:13.650 --> 04:20.430 You can read it online and all these different database management systems basically are tasked with 04:20.520 --> 04:25.320 implementing that standard in their own database and making it work and they deviate sometimes a little 04:25.320 --> 04:25.670 bit. 04:25.800 --> 04:29.080 But for the most part they're very very similar. 04:29.700 --> 04:31.470 So the two takeaways here. 04:31.470 --> 04:38.310 One is that once you learn sequel it's really not that hard to switch to another database that also 04:38.310 --> 04:39.360 uses sequel. 04:39.360 --> 04:40.720 So you're learning my ask. 04:40.780 --> 04:47.460 Well you could pretty easily switch to postgresql or to sequel light with not a lot of time needed to 04:47.640 --> 04:49.240 get up to speed. 04:49.470 --> 04:55.800 And the second thing is that what makes databases or database management systems to be specific what 04:55.800 --> 04:59.630 makes them unique are the features that they offer. 05:00.340 --> 05:03.070 Not the sequel or the language itself. 05:03.090 --> 05:08.630 So if we go back to this diagram all of these use as well but that doesn't mean that they're identical. 05:09.070 --> 05:13.150 And yes you might write the same line of code to do the same thing here. 05:13.450 --> 05:17.720 So what makes these different or the features that they implement things like. 05:18.040 --> 05:20.860 How secure is one versus the other how. 05:21.130 --> 05:25.310 How fast is it how much how big is the download. 05:25.420 --> 05:28.220 How do user permissions work and on and on and on. 05:28.240 --> 05:33.070 And we'll talk more about what those differences are when we get to a point where they actually make 05:33.070 --> 05:34.170 a little bit more sense. 05:34.180 --> 05:35.520 I don't want to just talk to you. 05:35.860 --> 05:36.580 OK. 05:36.670 --> 05:40.510 So this was about my ask Cuil versus sequel. 05:40.570 --> 05:47.770 Sequel is structured query language it exists separately from my well and my well is a database management 05:47.770 --> 05:49.960 system that implements as well.