WEBVTT 00:07.550 --> 00:13.130 All right, so before we move into the new part of this course, I would like us to create a new table 00:13.160 --> 00:16.400 because that is one of the very necessary things we need. 00:16.400 --> 00:19.880 And let's go ahead and go over to macro. 00:19.880 --> 00:23.600 And then we're going to create a new table. 00:23.600 --> 00:29.240 From here I'm going to leave the ID then I'm going to remove all these. 00:29.270 --> 00:30.950 Then I'm going to change this first name. 00:30.980 --> 00:33.050 We're going to create a table for a phone. 00:33.080 --> 00:33.680 Right. 00:33.680 --> 00:36.290 I'm going to change this to brand. 00:36.290 --> 00:42.020 And I'm going to change this to school and look for a mobile brand. 00:42.170 --> 00:45.230 So over here we see a mobile brand. 00:45.260 --> 00:48.710 So it is sunny Samsung Apple which is that. 00:48.710 --> 00:51.530 And then we'll look for a model for the phone. 00:51.530 --> 00:56.420 And we'll go over here and scroll down to model. 00:56.420 --> 00:59.450 And we see mobile device model. 01:00.440 --> 01:02.570 The next thing is the price of the phone. 01:02.570 --> 01:11.770 So let's go ahead and add a other prize for this was so we go over here and we move to money, and that 01:11.770 --> 01:16.300 is where we have money, because you are now going to be looking for prize. 01:16.330 --> 01:18.280 Under here there is no prize here. 01:18.280 --> 01:21.670 So we go and click on money. 01:22.030 --> 01:26.650 And now we go ahead and choose the range. 01:26.680 --> 01:37.090 And let's go ahead and say is between uh, maybe 10,000 and uh dollars or we go ahead and uh, choose 01:37.090 --> 01:40.690 that between 10,000 to $100,000. 01:40.720 --> 01:42.190 I think that would be okay. 01:42.430 --> 01:47.320 And, uh, we can go ahead and choose that to be initialize. 01:48.190 --> 01:48.610 All right. 01:48.610 --> 01:52.930 Now we go over here and now we're going to generate 1000 row as usual. 01:52.930 --> 01:55.720 And I will go ahead and choose our SQL. 01:55.720 --> 01:58.150 And let's go ahead and give that a name. 01:58.150 --> 02:04.630 And that should be phone then a good table right here to create the table. 02:04.630 --> 02:08.180 And let's go ahead and generate the Debtor. 02:08.300 --> 02:10.730 And this will start generating. 02:10.730 --> 02:15.950 And down here we can see that this is what we have right now. 02:15.980 --> 02:16.700 Let's go ahead. 02:16.700 --> 02:19.910 And now we have a phone created for us right in here. 02:20.030 --> 02:27.560 And we need to open up this using the VS code so we can be able to see how it looks like. 02:28.340 --> 02:29.840 So this is our VS code. 02:29.840 --> 02:33.950 And we have our students go ahead and open a new file. 02:33.980 --> 02:36.020 Go ahead and open a new file. 02:36.020 --> 02:39.410 And uh go ahead and click on this. 02:39.440 --> 02:42.230 And we have a phone dot SQL. 02:42.230 --> 02:46.430 And this is where we have our and we need to import these. 02:46.430 --> 02:50.420 Or we need to uh make some changes right in here. 02:51.260 --> 02:51.560 All right. 02:51.590 --> 02:58.400 Now let's go ahead and say that the brand is going to be not null. 02:59.690 --> 03:00.170 Right. 03:00.170 --> 03:04.940 And uh, the model is also going to be not null. 03:04.940 --> 03:11.180 And then the price will also be not null unknown. 03:11.180 --> 03:17.920 we also clean and make the ID is great to be the big area, right? 03:17.920 --> 03:29.200 So it will Autoincrement assay is going to be big area and not know, and then it's going to also be 03:29.200 --> 03:31.150 the primary key. 03:32.380 --> 03:32.770 All right. 03:32.800 --> 03:34.180 Now we have this. 03:34.210 --> 03:40.660 It's time for us to go ahead and upload or create this table and our database. 03:40.660 --> 03:42.940 So let's go ahead and kick off immediately. 03:43.570 --> 03:47.350 So first of all save your file and go over to forms. 03:47.350 --> 03:50.860 And uh uh copy the parts. 03:50.860 --> 03:56.620 And once you copy the parts you go over to maybe your notepad and press that. 03:56.620 --> 03:59.980 Then you remove all these and remove these. 04:00.010 --> 04:04.660 They change all these to file for slash. 04:04.720 --> 04:07.510 And this is also for slash. 04:07.510 --> 04:11.590 And then this is also for slash. 04:11.620 --> 04:14.200 Now let's go ahead and copy this. 04:14.230 --> 04:15.890 So copy whatever you have here. 04:15.890 --> 04:22.940 And then we go over to this place and then we try to import that. 04:22.940 --> 04:27.170 But I always love using my SQL shell for these. 04:27.170 --> 04:34.820 So all I need to do is to put a backward slash I remember backward slash I and then you go ahead and 04:34.820 --> 04:35.390 press this. 04:35.390 --> 04:37.670 But that is what you need. 04:37.670 --> 04:41.030 And once you do that we go ahead and import it. 04:42.110 --> 04:44.990 So let's go ahead and just hit enter. 04:44.990 --> 04:46.790 And it says users. 04:46.790 --> 04:48.890 No such file or directory exists. 04:49.100 --> 04:52.850 So it seems we omitted one of the backward slash one. 04:52.850 --> 04:54.620 We actually did that. 04:54.620 --> 05:03.110 So what we need to do is uh let's go over to displays and add back one of the box of four slash. 05:03.140 --> 05:03.590 Right. 05:03.590 --> 05:05.120 So that should be a forward slash here. 05:05.240 --> 05:08.840 And we go ahead and try it again with a. 05:10.940 --> 05:11.330 Right. 05:11.330 --> 05:14.330 And then press this again and let's go ahead I hit enter. 05:14.330 --> 05:18.470 And now we have this file inserted for us. 05:18.470 --> 05:28.420 And now we can go ahead and see backward slash D and now the name of the table is, uh, phones. 05:28.660 --> 05:36.280 And uh, let's go ahead and open up the VS code and make sure that is what we have. 05:36.310 --> 05:39.250 So that is phone and not phones. 05:39.250 --> 05:41.380 So go ahead and hit enter. 05:41.380 --> 05:44.740 And you can see that we have this table created for us. 05:44.740 --> 05:46.570 We have the ID, we have the brand. 05:46.570 --> 05:47.440 We have the model. 05:47.440 --> 05:49.270 We have the prices the price. 05:49.270 --> 05:50.950 And that is cool. 05:50.980 --> 05:51.370 All right. 05:51.400 --> 05:59.440 So you can simply go over here now and uh, check your select all from phone and uh, execute this query. 05:59.440 --> 06:00.910 And this is what we have. 06:00.910 --> 06:01.930 So that is cool. 06:01.960 --> 06:03.010 Go ahead and pull it down. 06:03.010 --> 06:08.590 And uh, you can also download this file app with that under source folder so that you can actually 06:08.620 --> 06:09.670 download that from there. 06:09.670 --> 06:11.260 Or you generate that by yourself. 06:11.290 --> 06:12.190 That is no problem. 06:12.190 --> 06:12.970 So thank you. 06:12.970 --> 06:15.910 And I'm going to see you in the next video lecture.