WEBVTT 00:00:07.290 --> 00:00:10.830 In this video you're going to get introduced to my Escurial. 00:00:10.830 --> 00:00:16.450 All right so far we have made some really good progress with our web development because we started 00:00:16.470 --> 00:00:25.350 by learning the basics of a symbol and then we learnt how to create Sunsilk ASML pages using a shemale 00:00:25.460 --> 00:00:27.200 she says javascript's. 00:00:27.240 --> 00:00:35.070 Jay Querrey with Trump and then we moved to PSP and we learned how to create dynamic web pages so we 00:00:35.070 --> 00:00:41.310 know now how to send data through a request to a BHB file on a server. 00:00:41.700 --> 00:00:50.370 And we know also how to process that data and build a nice ASML outputs using BHB. 00:00:50.370 --> 00:00:52.270 Now we're going to learn something new. 00:00:52.290 --> 00:00:58.430 We're going to learn how to store data in a database and also to learn how to retrieve that data changes 00:00:58.440 --> 00:00:58.460 . 00:00:58.470 --> 00:01:01.530 If you want to add also delete it if required. 00:01:02.220 --> 00:01:06.010 So for that purpose we're going to use my school. 00:01:06.030 --> 00:01:09.070 So what is my a school. 00:01:09.240 --> 00:01:19.140 My girl is an open source database management system which uses Escurial which stands for a structured 00:01:19.290 --> 00:01:23.810 query language to explain that in a bit. 00:01:23.940 --> 00:01:24.300 So 00:01:27.600 --> 00:01:31.990 my school is going to store data in a database. 00:01:32.110 --> 00:01:32.910 OK. 00:01:33.210 --> 00:01:39.210 And a database is just a structured collection of data databases. 00:01:39.210 --> 00:01:45.120 In my Escurial they are relational databases which means that they are going to store data in separate 00:01:45.120 --> 00:01:47.910 tables. 00:01:48.030 --> 00:01:56.300 So as an example we see here a table inside a database. 00:01:56.340 --> 00:01:58.010 So this is our users table. 00:01:58.140 --> 00:02:04.850 And usually I would use this table for logging details of users. 00:02:05.100 --> 00:02:10.440 So we got here a column user ID and then email and then password. 00:02:10.440 --> 00:02:16.830 So for example if you want to log in to your Facebook accounts and your inputs your e-mail address and 00:02:16.860 --> 00:02:20.100 password OK then 00:02:23.610 --> 00:02:33.040 the B The data is going to be sent to a PH B file which is going to be embedding some Escurial code 00:02:33.080 --> 00:02:34.080 and it's OK. 00:02:34.170 --> 00:02:41.520 And then there would be a query which is going to check for any matching email address and password 00:02:41.970 --> 00:02:45.030 inside the the user's table. 00:02:45.390 --> 00:02:45.810 OK. 00:02:46.050 --> 00:02:52.200 And based on the results you will be directed to your Facebook page. 00:02:52.200 --> 00:02:59.430 Otherwise there would be an error saying that we couldn't find any e-mail address with the password 00:02:59.430 --> 00:03:00.710 . 00:03:00.750 --> 00:03:01.300 OK. 00:03:01.830 --> 00:03:02.930 Another example here. 00:03:03.020 --> 00:03:11.040 Of course a product list here for columns called the products ID product name description and price 00:03:11.050 --> 00:03:11.120 . 00:03:11.190 --> 00:03:11.960 OK. 00:03:12.420 --> 00:03:23.910 And a simple query for this would be to look for a product name with a price that is equal to 600 OK 00:03:25.170 --> 00:03:29.900 or a price that is less than 700 for example. 00:03:29.970 --> 00:03:37.800 So the query is going to go through the database table that just look for all the product names that 00:03:38.550 --> 00:03:44.420 verify the requested condition. 00:03:44.990 --> 00:03:53.340 My girl is very fast reliable and very easy to use and a big advantage of my school is that we can embed 00:03:54.130 --> 00:04:00.970 Escurial inside many programming languages including BHB. 00:04:01.170 --> 00:04:06.540 So in the next videos we're going to learn how to create databases and 00:04:09.180 --> 00:04:11.820 use my Escurial with BHB