I am very glad you've come a long way in this course.
And now we are about to submit a dataset to anybody that requested that.
Can we say your data analyst is cool?
And the head of school said, I want to have this data submitted in CSV file because whatever you are
doing, it is you alone that knows what you are doing because your proprietor or anyone in the office
will not come.
And looking at your execution or pgadmin or anything you're working on.
So how do you submit this as a CSV file?
Because they need to see it and check out how many students that are headphone are sent to them, and
how many student that doesn't have phone assigned to them.
And remember, we have worked on this in the previous lectures and now want to export this file.
And this file might be I have 1,000,002 million and so on and so forth, and it can be able to download
all that.
So we go ahead and use that, send, join and export this.
And now I'm going to do that uh, a silo.
And what's a sent that file into a folder?
And let me say the name of the folder is going to be a folder I've worked on and done.
That is a folder we have always been using right.
In here it's going to say this is the folder.
And have fun, students and students fun, which I use to be able to create a foreign key.
So we're going to send that directly inside this folder.
So can we go to uh, share that with the proprietor of our school or anybody in the office who requested
for this data set to be able to view it in a CSV format.
And that is going to be very interesting.
All right.
Now let's go ahead and learn how to actually do this, because that is a very nice or interesting part
of this course.
So as an analyst this is a part of waiting for in order to see a file in CSV format.
Now what I need to do is go right in here and put a backward slash and say copy.
And now you're going to copy whatever you've done.
So I'm going to do a J.
I'm going to use a left join to in order to join those two lines.
And those who don't have these, I have deleted one of the students.
Therefore, I'm going to export whoever remains.
So go ahead and say select and I'm going to select all from the students.
And that is the student table using left join.
Let me go ahead and join this with the full table.
And I'm going to create any table with the on keyword set on.
Then the phone that ID.
So that is the phone table ID which is the primary key.
And the the students.
Dot phone underscore ID which we use to rephrase the phone table.
So now we go ahead and export that.
And I'm going to use this keyword called two.
And I want to do this.
All I need to do is I have to go ahead and move back inside this folder and get this part right.
So you can go ahead and copy this part.
Let me say I'll copy this part I have here.
Copy part.
And I have to just rename what I just have.
So right here I'm going to put this into a quotation mark over here.
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
double quotation mark that is in there because we need just single quotes.
And now I've removed that.
So I'm going to rename this file because I use this one to copy the parts.
And I can call that to be students.
Uh phone record student phone records dot c s v because that is going to be in a CSV format.
And close these quotes and I'm going to add a QR code with C and D.
And once you do that you put a semicolon at the end.
And now you hit enter so that it says missing first class entry in table students.
And now okay, we have this table.
And this table is supposed to be students and not students or whatever you have right in here and go
right here and press that.
So I'm going to move right inside here.
So that is students dot phone and not student dot phone and put a s right in here.
So select all from students left join phone on to phone ID equal to students dot phone underscore ID.
And that is all.
And let's go over here and uh export this.
Go ahead and hit enter.
And you can see copy three.
It shows that this actually copy the three tables we have.
So the three rules because it has created a new table.
And the new table we created, we use the on keyword to do that.
Now I'll go ahead and uh go inside here and we have a, a CSV file called Students Record.
Let's go ahead and double click on this and check what we have.
And that is Excel file.
And now we can see that uh, we have this one two, three 23.
The way we were assigned Motorola and Image, respectively.
Why Rosalind Mayweather has not been assigned.
You can also go ahead and check out the names.
That's all I can do to spread this.
So this is the only part of this course, but I'm just trying to make that to look good.
All right.
And you can see that done looks good now.
All right.
So and, uh, everything is really, really very okay at this moment.
Okay.
So go ahead and, uh, export this.
I'll go ahead and minimize this so we can be able to see this command again.
And I'm going to shoot this command one more time.
And that is right in here.
Go ahead and export this and, uh, try to share that with anyone who is requested for your data set
and everything you've done so far.
And that is very, very interesting.
So we have actually done a lot, and I'm very glad you've come almost to this point in this course.
Thank you.
And that is very, very interesting.