WEBVTT 00:07.550 --> 00:10.790 I am very glad you've come a long way in this course. 00:10.790 --> 00:16.070 And now we are about to submit a dataset to anybody that requested that. 00:16.220 --> 00:18.200 Can we say your data analyst is cool? 00:18.200 --> 00:23.900 And the head of school said, I want to have this data submitted in CSV file because whatever you are 00:23.900 --> 00:30.290 doing, it is you alone that knows what you are doing because your proprietor or anyone in the office 00:30.290 --> 00:31.130 will not come. 00:31.130 --> 00:35.480 And looking at your execution or pgadmin or anything you're working on. 00:35.480 --> 00:38.180 So how do you submit this as a CSV file? 00:38.210 --> 00:45.530 Because they need to see it and check out how many students that are headphone are sent to them, and 00:45.530 --> 00:47.840 how many student that doesn't have phone assigned to them. 00:47.840 --> 00:52.280 And remember, we have worked on this in the previous lectures and now want to export this file. 00:52.280 --> 00:58.850 And this file might be I have 1,000,002 million and so on and so forth, and it can be able to download 00:58.850 --> 01:00.020 all that. 01:00.020 --> 01:04.760 So we go ahead and use that, send, join and export this. 01:04.760 --> 01:09.020 And now I'm going to do that uh, a silo. 01:09.050 --> 01:11.720 And what's a sent that file into a folder? 01:11.720 --> 01:15.890 And let me say the name of the folder is going to be a folder I've worked on and done. 01:15.920 --> 01:18.020 That is a folder we have always been using right. 01:18.020 --> 01:20.510 In here it's going to say this is the folder. 01:20.510 --> 01:27.410 And have fun, students and students fun, which I use to be able to create a foreign key. 01:27.410 --> 01:31.790 So we're going to send that directly inside this folder. 01:31.790 --> 01:38.990 So can we go to uh, share that with the proprietor of our school or anybody in the office who requested 01:38.990 --> 01:42.500 for this data set to be able to view it in a CSV format. 01:42.500 --> 01:45.350 And that is going to be very interesting. 01:45.380 --> 01:45.800 All right. 01:45.830 --> 01:52.820 Now let's go ahead and learn how to actually do this, because that is a very nice or interesting part 01:52.820 --> 01:53.510 of this course. 01:53.510 --> 01:59.090 So as an analyst this is a part of waiting for in order to see a file in CSV format. 01:59.120 --> 02:04.310 Now what I need to do is go right in here and put a backward slash and say copy. 02:04.520 --> 02:07.130 And now you're going to copy whatever you've done. 02:07.130 --> 02:10.310 So I'm going to do a J. 02:10.580 --> 02:14.120 I'm going to use a left join to in order to join those two lines. 02:14.120 --> 02:17.880 And those who don't have these, I have deleted one of the students. 02:17.910 --> 02:20.340 Therefore, I'm going to export whoever remains. 02:20.340 --> 02:29.040 So go ahead and say select and I'm going to select all from the students. 02:29.040 --> 02:32.490 And that is the student table using left join. 02:32.520 --> 02:37.080 Let me go ahead and join this with the full table. 02:37.080 --> 02:41.970 And I'm going to create any table with the on keyword set on. 02:41.970 --> 02:47.010 Then the phone that ID. 02:47.010 --> 02:52.350 So that is the phone table ID which is the primary key. 02:52.350 --> 02:55.170 And the the students. 02:57.270 --> 03:04.350 Dot phone underscore ID which we use to rephrase the phone table. 03:04.350 --> 03:07.890 So now we go ahead and export that. 03:07.890 --> 03:11.190 And I'm going to use this keyword called two. 03:11.190 --> 03:12.750 And I want to do this. 03:12.750 --> 03:19.080 All I need to do is I have to go ahead and move back inside this folder and get this part right. 03:19.080 --> 03:21.330 So you can go ahead and copy this part. 03:21.360 --> 03:24.540 Let me say I'll copy this part I have here. 03:24.570 --> 03:25.380 Copy part. 03:25.410 --> 03:29.640 And I have to just rename what I just have. 03:29.640 --> 03:34.260 So right here I'm going to put this into a quotation mark over here. 03:34.260 --> 03:41.400 And uh click on this and paste that part I just copied now or I need to do is I'm going to remove this 03:41.400 --> 03:45.900 double quotation mark that is in there because we need just single quotes. 03:45.900 --> 03:47.700 And now I've removed that. 03:47.700 --> 03:51.960 So I'm going to rename this file because I use this one to copy the parts. 03:51.960 --> 03:54.510 And I can call that to be students. 03:54.510 --> 04:05.250 Uh phone record student phone records dot c s v because that is going to be in a CSV format. 04:05.250 --> 04:12.420 And close these quotes and I'm going to add a QR code with C and D. 04:12.450 --> 04:15.390 And once you do that you put a semicolon at the end. 04:15.390 --> 04:23.880 And now you hit enter so that it says missing first class entry in table students. 04:23.880 --> 04:26.850 And now okay, we have this table. 04:26.850 --> 04:32.850 And this table is supposed to be students and not students or whatever you have right in here and go 04:32.850 --> 04:34.620 right here and press that. 04:34.620 --> 04:37.890 So I'm going to move right inside here. 04:37.890 --> 04:43.380 So that is students dot phone and not student dot phone and put a s right in here. 04:43.380 --> 04:53.400 So select all from students left join phone on to phone ID equal to students dot phone underscore ID. 04:53.400 --> 04:54.690 And that is all. 04:54.690 --> 04:59.520 And let's go over here and uh export this. 04:59.550 --> 05:00.960 Go ahead and hit enter. 05:00.960 --> 05:03.240 And you can see copy three. 05:03.270 --> 05:07.620 It shows that this actually copy the three tables we have. 05:07.620 --> 05:10.710 So the three rules because it has created a new table. 05:10.710 --> 05:15.420 And the new table we created, we use the on keyword to do that. 05:15.420 --> 05:24.360 Now I'll go ahead and uh go inside here and we have a, a CSV file called Students Record. 05:24.390 --> 05:27.330 Let's go ahead and double click on this and check what we have. 05:27.330 --> 05:28.800 And that is Excel file. 05:28.800 --> 05:35.230 And now we can see that uh, we have this one two, three 23. 05:36.160 --> 05:40.540 The way we were assigned Motorola and Image, respectively. 05:40.570 --> 05:43.810 Why Rosalind Mayweather has not been assigned. 05:43.840 --> 05:46.690 You can also go ahead and check out the names. 05:46.720 --> 05:49.180 That's all I can do to spread this. 05:49.180 --> 05:53.950 So this is the only part of this course, but I'm just trying to make that to look good. 05:53.980 --> 05:54.430 All right. 05:54.430 --> 05:56.950 And you can see that done looks good now. 05:57.670 --> 05:58.300 All right. 05:58.300 --> 06:05.980 So and, uh, everything is really, really very okay at this moment. 06:06.010 --> 06:06.760 Okay. 06:06.790 --> 06:10.060 So go ahead and, uh, export this. 06:10.090 --> 06:13.540 I'll go ahead and minimize this so we can be able to see this command again. 06:13.540 --> 06:16.540 And I'm going to shoot this command one more time. 06:16.540 --> 06:18.160 And that is right in here. 06:18.190 --> 06:23.980 Go ahead and export this and, uh, try to share that with anyone who is requested for your data set 06:24.010 --> 06:25.690 and everything you've done so far. 06:25.690 --> 06:27.310 And that is very, very interesting. 06:27.310 --> 06:33.040 So we have actually done a lot, and I'm very glad you've come almost to this point in this course. 06:33.040 --> 06:33.640 Thank you. 06:33.640 --> 06:36.100 And that is very, very interesting.