All language subtitles for 4. Exercise Building Amazon

All right, everybody, it's exercise time, and in this exercise, we're going to build Amazon or at

least understand how Amazon uses databases.

Now, I want to take us back all the way into the 90s.

That is Amazon before Jeff Bezos look like a superhero.

We're talking Jeff Bezos in the 90s.

Now, imagine you're starting Amazon.

You just started.

You're starting to deliver some books.

You are getting your first customers.

If you're a Jeff Bezos, what's your first thing that you're going to do?

Well, maybe you will use a notebook, a pen and paper and say, Joe just ordered a Harry Potter book.

I'm going to write down his name, grab their credit card information or check and grab their address

so that I can ship them that book.

Now, eventually, this notebook, pen and paper is going to overwhelm Jeff and he decides, you know

what, let's use Excel.

Let's use a spreadsheet.

And Jeff starts using a spreadsheet.

And now look at that, things look a lot better, a lot cleaner instead of pen and paper on the computer.

Now Jeff has some orders.

We have Andre myself.

I ordered a toy duck.

I wanted two of them.

And this is my address now.

My real address.

Don't try and send me mail.

We have Mo, who likes candy and just bought 100 candies.

Wow, that's a lot.

Bruno, again, has perfect hair and he buys a lot of hair gel.

And then finally, Sally is buying a Harry Potter book.

Awesome.

So Jeff is keeping tracks of orders.

He knows when to send those items because he has the address.

He has a quantity, he has the name.

Everything is great.

But then comes a problem.

The Excel sheet gets a little bit bigger.

And now we have something confusing that Andre has done.

You see, I wanted to get some cool glasses, so I order some cool glasses and there you go, order

them.

But once I see them, I didn't really like them.

I don't think they were as cool as I thought.

So while I, I decided to return them and a week later I decided, you know what, I wasn't thinking

straight.

Those cool glasses, they were actually very, very cool.

So I decide to order another pair of glasses, but oh, just a heads up.

I actually moved to Japan in the meantime.

So Jeff looking is this is saying.

Hold on, hold on.

Well, OK.

So is this the same Andre?

There's two different addresses.

There's a minus one here and in his head has to keep track of all these things, all these changes,

and imagine having more and more rows.

Imagine this Excel sheet getting bigger and bigger and bigger, more information, more data.

Things start to get confusing.

And this is why databases exist.

Instead of this, let's imagine a better system that Jeff implements now for you.

I want you to go to this length that will link in this lecture and try this out.

This is an interactive playground.

This is a website that actually has a database already as part of it.

You can see here that this is your database and it has different tables with different records.

So there's ninety one customers.

There's eight categories.

And there's also a playground for you to run.

Ask all statements.

Now, we haven't really learned about school yet, so this might be gibberish for you, but I just want

you to click run school.

And by the way, your school statement here might be different than mine.

That doesn't matter.

Just click run.

This is essentially what a database does, we kind of get the same results as a spreadsheet, but we

use ask you all statements and we grab information that we need.

But it's not just one big Excel file, right?

There's different pieces of data.

So if I go to customers, I see all my customers, each customer has an ID, has different columns with

important information like address, like the contact name if we go to orders.

We have some order date, we have some customer ID, so who ordered the orders?

If we go to products, we see all the products that we have.

And all of these are grabbed using school statements.

Now, I know this is still confusing, might not understand what the difference between this and an

Excel spreadsheet is, but before we do, before I go into the next video and show you the exact difference

and why this system might be more beneficial to Jeff, I want you to play around over here, start clicking

on some of these categories around the school commands and just kind of understand what we're trying

to do.

Essentially, when we select staff from something, we get some data, see if we can modify this information

right over here to perhaps match different databases and find out about our Amazon store.

So play around, even though you have no idea maybe what these statements do, and in the next video,

we're going to dive deeper into Jeff's Amazon database.