WEBVTT

NOTE
Automatically generated captions. Not fully reviewed; words, speaker changes and sound cues may be incomplete.

1
00:00:00.000 --> 00:00:03.180
In our restaurant analogy earlier, I said
that the back end stores your data

2
00:00:03.180 --> 00:00:06.620
in something like a kitchen's walk-in
freezer, where all the ingredients, or

3
00:00:06.620 --> 00:00:09.140
your data in this case, are kept ready for
when they're actually needed.

4
00:00:09.260 --> 00:00:12.260
That's a very helpful mental image for
understanding what storage is.

5
00:00:12.380 --> 00:00:15.000
But to understand how it's organized and
accessed, there's a better metaphor.

6
00:00:15.200 --> 00:00:17.960
You can picture a filing cabinet, like the
old school kind that you see in an

7
00:00:17.960 --> 00:00:21.620
office. That cabinet is your database,
your software's complete memory for

8
00:00:21.620 --> 00:00:23.460
everything to do with users and the app
itself.

9
00:00:23.640 --> 00:00:25.860
So in a database, data is organized by
category.

10
00:00:26.060 --> 00:00:29.480
So imagine that each drawer in this filing
cabinet holds one type of

11
00:00:29.480 --> 00:00:32.960
information. For example, if you had an
e-commerce app like Amazon, you might

12
00:00:32.960 --> 00:00:36.240
have one drawer for the users, another
drawer for products, and then another

13
00:00:36.240 --> 00:00:39.620
for orders. In database terms, each of
those drawers is called a table.

14
00:00:40.140 --> 00:00:43.240
So if you were to pull open the user's
drawer, you'd find a bunch of folders,

15
00:00:43.640 --> 00:00:46.380
one for each of your users, where each
folder has tabs for labels for

16
00:00:46.380 --> 00:00:49.220
information like your name, your address,
your email, etc.

17
00:00:49.500 --> 00:00:52.580
And at this point, you might be thinking,
hmm, so a table is basically like a

18
00:00:52.580 --> 00:00:55.160
spreadsheet, like Google Sheets or
Microsoft Excel.

19
00:00:55.340 --> 00:00:58.340
So then a database is basically a
collection of spreadsheets and honestly

20
00:00:58.340 --> 00:00:59.600
it's pretty much as simple as that.