TEELTECH SQLite FORENSICS

Since their initial introduction in 2007, Smartphones have come to dominate the cellular phone marketplace quickly making feature phones nearly obsolete. This domination is split fairly evenly between two major companies: Google with their Android OS and Apple touting their own iOS. Even though both of these companies are business rivals and their file systems are significantly different, both share a commonality in that they both store a majority of their user data within a data storage container type called SQLite. “SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.”[1] Mobile Forensic Analysts can easily leverage this commonality, by learning the skills required to perform low-level analysis and recovery on SQLite databases. Once learned and mastered, examiners can then support nearly 99% of the device data they will come across in the majority of their mobile device examinations.

To illustrate the vast amount of work to be done, as of January 2015, the Google Play Store reported 1.43 Million Applications being available in their Google Play Store[2]. At the same time, Apple’s iTunes Store reported over 1.4 Million apps currently being available for download. That’s a total of over 2.8 MILLION apps. Even the most popular mobile forensic tool only supports parsing of 200 different applications. This support accounts for a miniscule %001 of the total apps and leaves a 99.999% gap!

silver-apple-logowSQLite
AndroidwSQLite

What Will I Learn?

This class will help examiners close that gap by teaching the students:

  • How SQLite works at the byte-level
  • What are the different types of SQLite data components
  • What are the 5 common locations to recover SQLite data
  • How to perform report data validation
  • How to Reverse Engineer ANY SQLite database
  • Converting and identifying virtually any date format easily
  • Display BLOB data within the forensic tool
  • How to use a tool designed from the ground-up as a forensic tool
  • How to recover data from .SHM, .WAL and .journal files
  • How to generate reports quickly from any SQLite database to include external linked images

Laptop Minimum Requirements

We encourage students to bring their own laptops whenever possible. If this is not possible, please contact us in order to find a solution. If you do plan on bringing your own laptop, please ensure the meet the following requirements.

Laptop Minimum Requirements

  • Windows 7
  • Windows 8.x and 10.x using these instructions (turn off driver sig enforcement)
  • macOS with Bootcamp Windows 7
  • macOS with Bootcamp Windows 8.x and Win 10.x using these instructions
  • macOS alone will not work (No Virtual Machines)
  • 8GB RAM (minimum)
  • 100GB storage (minimum)
  • You must have Admin rights or have the admin password for software installation.
  • NOTE: ALL Windows updates should be done prior to class

Optional

  • Cellebrite P.A. Dongle
  • Encase, FTK, X-Ways Dongle
  • Access to a HEX editor
  • External USB 3.0 Storage Device

Registration

Description TeelTech SQLite Forensics
Date 08. August 2018 – 10. August 2018
Place Zürich
Duration 3 days
Language English
Min. Participants 6
Max. Participants 12
Registrations 3
Price CHF 2995.00 excl. VAT

Important Information! Classes are not confirmed until 30 days prior to course start. Please do not consider an acknowledgement letter or invoice as confirmation that a class will definitely run. Please feel free to contact us to before making travel arrangements, to confirm the class is going forward. A confirmation notice will be issued when a class is confirmed, or a cancellation notice if it will not be held.

Overview Mobile Forensics Training

Description Date Place Registration
TeelTech In-System Programming (ISP) 02.07.2018 – 06.07.2018 Zürich, Switzerland Open
TeelTech CHIP-OFF 2.0 Forensics 09.07.2018 – 13.07.2018 Zürich, Switzerland Open
TeelTech SQLite Forensics 08.08.2018 – 10.08.2018 Zürich, Switzerland Open
TeelTech Advanced BootLoader/Flasherbox 13.08.2018 – 16.08.2018 Zürich, Switzerland Open
TeelTech JTAG 2.0 Forensics 17.09.2018 – 21.09.2018 Zürich, Switzerland Open

Mehr über unsere Trainings erfahren?