WEBVTT

00:00:01.784 --> 00:00:03.284 align:middle line:90%
SQLite is important.

00:00:03.284 --> 00:00:05.654 align:middle line:84%
There is zero way to
dodge it at this point

00:00:05.654 --> 00:00:07.334 align:middle line:84%
in smartphone
forensics because most

00:00:07.334 --> 00:00:10.694 align:middle line:84%
of the third-party applications
and native applications

00:00:10.694 --> 00:00:13.004 align:middle line:84%
for Android and
iOS rely on SQLite.

00:00:13.004 --> 00:00:15.704 align:middle line:84%
Your tools will not be
able to parse everything.

00:00:15.704 --> 00:00:18.414 align:middle line:84%
New features will be
introduced to these apps,

00:00:18.414 --> 00:00:21.349 align:middle line:84%
new columns will be introduced,
timestamps will be modified.

00:00:21.349 --> 00:00:22.724 align:middle line:84%
Things will change
that are going

00:00:22.724 --> 00:00:28.094 align:middle line:84%
to force you to modify or
create new queries to parse

00:00:28.094 --> 00:00:28.934 align:middle line:90%
the information.

00:00:28.934 --> 00:00:30.944 align:middle line:84%
In this course, you
are going to start

00:00:30.944 --> 00:00:34.424 align:middle line:84%
with this next lab that
is going to force you

00:00:34.424 --> 00:00:36.584 align:middle line:90%
to write a query from scratch.

00:00:36.584 --> 00:00:39.644 align:middle line:84%
In section 4, this
is a perfect example.

00:00:39.644 --> 00:00:43.514 align:middle line:84%
We give you a query
that worked in iOS 13,

00:00:43.514 --> 00:00:46.274 align:middle line:84%
and we say, hey, here is
what the database looks

00:00:46.274 --> 00:00:47.444 align:middle line:90%
like in iOS 15.

00:00:47.444 --> 00:00:49.524 align:middle line:90%
Modify it, and make it work.

00:00:49.524 --> 00:00:52.194 align:middle line:84%
So the first thing you have
to do is detect the change.

00:00:52.194 --> 00:00:54.554 align:middle line:84%
And then you have
to fix the change.

00:00:54.554 --> 00:00:57.374 align:middle line:84%
It is easier, in my
opinion to modify versus

00:00:57.374 --> 00:00:58.944 align:middle line:90%
starting from scratch.

00:00:58.944 --> 00:01:01.491 align:middle line:84%
So in the notebook that I'm
going to provide to you,

00:01:01.491 --> 00:01:03.074 align:middle line:84%
if you see something
in your database,

00:01:03.074 --> 00:01:05.054 align:middle line:84%
and you're, like, I wish Heather
would have included that,

00:01:05.054 --> 00:01:05.864 align:middle line:90%
include it.

00:01:05.864 --> 00:01:07.934 align:middle line:84%
You're going to
learn how to modify.

00:01:07.934 --> 00:01:09.856 align:middle line:84%
If you create amazing
queries and you

00:01:09.856 --> 00:01:11.564 align:middle line:84%
think it would be
relevant to this class,

00:01:11.564 --> 00:01:14.534 align:middle line:84%
please email them to me, so I
can add them to our notebook.

00:01:14.534 --> 00:01:16.664 align:middle line:84%
The class notebook
will always grow.

00:01:16.664 --> 00:01:19.784 align:middle line:84%
You have access to it for
the rest of your life.

00:01:19.784 --> 00:01:22.012 align:middle line:84%
If you take
Forensics 500, you're

00:01:22.012 --> 00:01:23.804 align:middle line:84%
going to get a glimpse
of all the queries I

00:01:23.804 --> 00:01:25.322 align:middle line:90%
created for that class as well.

00:01:25.322 --> 00:01:26.864 align:middle line:84%
So if you do Windows
forensics, cloud

00:01:26.864 --> 00:01:28.641 align:middle line:90%
forensics, mobile forensics--

00:01:28.641 --> 00:01:30.224 align:middle line:84%
I will say in advance,
you're welcome,

00:01:30.224 --> 00:01:32.924 align:middle line:84%
because you're getting
access to an amazing notebook

00:01:32.924 --> 00:01:34.214 align:middle line:90%
full of information.
