Tamil10inches BBC Selfie Session Worth for Watching

Video Transcription

So you can see that it has nicely categorized all of the parts.

This is very helpful, especially when you're trying to build some categorization based

on your data, either using numeric values like I have shown or text values, so that

you could then either display it on the screen or use it to build a pair condition or mark

it out to another table.

顯示更少顯示更多

This brings us to the end of our part one of the SQL journey.

So far we have been building queries where all the data sits in one table and then we

are doing operations on that data.

In the subsequent part of this video, we are going to look at joins so that you can take

data that is in multiple tables and then combine that to create one output.

Let's go.

In the joins part of this video, I'm going to show you some practical examples and briefly

explain what is what.

But if you want to learn a little bit more about how joins work and how to use them for

many practical scenarios, you will need to do a little bit of further study.

I'll talk about some resources for learning SQL later on at the end of the video.

But for now, let's go and build some joins.

Before I do that, I just want to save my SQL file because then I can come back and refer

to these queries or I can share these examples with you.

...