WEBVTT

00:00:01.785 --> 00:00:05.175 align:middle line:84%
SQLite databases are a huge
part of smartphone forensics.

00:00:05.175 --> 00:00:10.238 align:middle line:84%
You have to learn even the
basics at approaching SQLite.

00:00:10.238 --> 00:00:12.655 align:middle line:84%
I'm going to show you different
ways that you can do this.

00:00:12.655 --> 00:00:14.415 align:middle line:84%
I'm going to show
you my preferred way.

00:00:14.415 --> 00:00:16.165 align:middle line:84%
And then I will show
you some easier ways,

00:00:16.165 --> 00:00:19.275 align:middle line:84%
especially if you
are newer to doing

00:00:19.275 --> 00:00:21.315 align:middle line:90%
SQLite forensic examination.

00:00:21.315 --> 00:00:24.915 align:middle line:84%
There is a cheat sheet that
Lee, myself, and Sarah Edwards

00:00:24.915 --> 00:00:27.735 align:middle line:84%
wrote that is available for
you in your SANS portal.

00:00:27.735 --> 00:00:30.345 align:middle line:84%
If you go to your Media files,
you'll be able to find that.

00:00:30.345 --> 00:00:31.065 align:middle line:90%
Leverage it.

00:00:31.065 --> 00:00:34.965 align:middle line:84%
It is a lot of what we have
in this course from here

00:00:34.965 --> 00:00:39.475 align:middle line:84%
and on day five put into
one simple cheat sheet.

00:00:39.475 --> 00:00:42.865 align:middle line:84%
We are going to teach
you query basics.

00:00:42.865 --> 00:00:46.825 align:middle line:84%
On day five, or on section 5,
and actually all the sections

00:00:46.825 --> 00:00:49.705 align:middle line:84%
leading up to it, you will
have options to do queries.

00:00:49.705 --> 00:00:52.015 align:middle line:84%
We're going to force you
to do it in this next lab.

00:00:52.015 --> 00:00:54.170 align:middle line:84%
And in section 5,
you're going to be

00:00:54.170 --> 00:00:55.795 align:middle line:84%
I shouldn't say
forced, but encouraged,

00:00:55.795 --> 00:00:58.195 align:middle line:84%
strongly encouraged,
to write queries

00:00:58.195 --> 00:01:00.585 align:middle line:90%
to get through these labs.

00:01:00.585 --> 00:01:02.865 align:middle line:84%
It's so important
that you actually

00:01:02.865 --> 00:01:05.305 align:middle line:84%
understand how to
write the queries,

00:01:05.305 --> 00:01:07.885 align:middle line:90%
but also how to modify them.

00:01:07.885 --> 00:01:11.625 align:middle line:84%
I have created a Class
Notebook for this course.

00:01:11.625 --> 00:01:14.655 align:middle line:84%
The Class Notebook is
constantly being updated.

00:01:14.655 --> 00:01:18.255 align:middle line:84%
I'm not going to give you
access to it just yet.

00:01:18.255 --> 00:01:20.455 align:middle line:84%
You will get access to
it later in this course.

00:01:20.455 --> 00:01:22.125 align:middle line:84%
I just want to make
sure you're learning

00:01:22.125 --> 00:01:24.555 align:middle line:84%
the key concepts behind
SQLite because it's so

00:01:24.555 --> 00:01:27.555 align:middle line:90%
important in digital forensics.

00:01:27.555 --> 00:01:30.693 align:middle line:84%
If you could learn just
one additional skill when

00:01:30.693 --> 00:01:32.235 align:middle line:84%
it comes to mobile
forensics, I would

00:01:32.235 --> 00:01:35.295 align:middle line:84%
say SQLite queries is definitely
what you want to focus on.
