WEBVTT

00:00:01.832 --> 00:00:04.162 align:middle line:84%
This is where we
have to get ready.

00:00:04.162 --> 00:00:08.892 align:middle line:84%
Now, if I quizzed you on this--
and I love to quiz people--

00:00:08.892 --> 00:00:11.262 align:middle line:84%
and I said to you,
did this database

00:00:11.262 --> 00:00:14.262 align:middle line:84%
come from an Android or
an iPhone, how many of you

00:00:14.262 --> 00:00:16.565 align:middle line:90%
would actually know that answer?

00:00:16.565 --> 00:00:17.982 align:middle line:84%
Most people would
look at the body

00:00:17.982 --> 00:00:19.607 align:middle line:84%
and hope that it said
iPhone or Android

00:00:19.607 --> 00:00:21.672 align:middle line:90%
and start scanning like crazy.

00:00:21.672 --> 00:00:24.852 align:middle line:84%
There are no datetime
stamps shown here as a clue.

00:00:24.852 --> 00:00:28.372 align:middle line:84%
But what you are going to
see, the column headers.

00:00:28.372 --> 00:00:30.802 align:middle line:84%
Look how they all
start with the Z.

00:00:30.802 --> 00:00:35.850 align:middle line:84%
So we see ZFLAGS, Z_OPT,
ZSTATE, ZTYPE, ZBODY.

00:00:35.850 --> 00:00:37.642 align:middle line:84%
It's not to make me
sound like a psychopath

00:00:37.642 --> 00:00:38.672 align:middle line:90%
when I teach you this.

00:00:38.672 --> 00:00:41.972 align:middle line:84%
It is a clue that
it's an Apple device.

00:00:41.972 --> 00:00:43.772 align:middle line:90%
So this is actually an iPhone.

00:00:43.772 --> 00:00:47.812 align:middle line:84%
You're not going to find that
Z in a column name on Android.

00:00:47.812 --> 00:00:50.022 align:middle line:90%
So that's a good clue for you.

00:00:50.022 --> 00:00:52.862 align:middle line:84%
Now, when you look
at this, a query

00:00:52.862 --> 00:00:56.352 align:middle line:84%
is going to enable you to say,
only show me what I care about.

00:00:56.352 --> 00:00:59.942 align:middle line:84%
So if you only care
about ZBODY, ZSTATE,

00:00:59.942 --> 00:01:03.122 align:middle line:84%
maybe ZTIMESTAMP,
ZTYPE, tell it that,

00:01:03.122 --> 00:01:05.027 align:middle line:84%
and it will show you
only those things.
