Skip to main content

20250114-124112-04

Attention

This website is under construction. Please send questions or comments to bjanttac@usdoj.gov.

Questions?

Submitted by Bryan Lee Dail on
Mobile devices dominate the intake list, and the desks of most digital forensics analyst globally. Devices are becoming more secure, with an increase in security the need for detailed analysis is increasing as well. SQLite is a self-contained, serverless database engine. It is found on nearly every operating system and dominates iOS, Android, and macOS as one of the most prevalent and relevant data storage mechanisms. Rather than hope our forensic tools support the newest applications or be tethered to how a certain utility parses data we can arm ourselves with the skills and techniques needed to conquer the analysis of nearly any application. What is SQLite and how to identify and analyze logically Recognizing relevant locations of valuable data within SQLite database. Develop skills needed for crafting custom SQLite queries. Learn how to recognize and decode a variety of common timestamp formats. Learn how to perform SQLite analysis with automation.
TTA Short Name
IDFA-SQLite
Status of Deliverable
Type of Agency
TTA Title
DF205 Intermediate Digital Forensic Analysis: SQLite Primer
TTA Point of Contact
TTAR Source
Category
Deliverable Markup for Questions

Please check the box next to the following questions if the answer is 'yes'.

Is this TTA in support of implementing or maintaining an evidence-based or promising practice?
No
Is this TTA in response to emerging public safety needs?
No
Demographic - Gender
Target Audience
TTA Program Area
Program Area - Sub Topics
Demographic - Age
Demographic - Race
TTA Estimated Costs
Demographic - Ethnicity
Demographic - Other
Recipient Agency Scope
Yes
Primary Recipient Contact Name
Pasco County Sheriff's Office
Event Date Markup

Please enter the applicable Event Date if there is an Event associated with this TTA.
When entering an Event Date, the Time is also required.

Display event on public TTA Catalog
Yes
Demographics Markup

If the TTA is targeted to a particular audience or location, please complete the questions below.

Milestones Markup

Milestones are an element, activity, work product, or key task associated with completing the TTA (e.g. kick-off meeting, collect data from stake holders, deliver initial data analysis).

Please complete the fields below, if applicable, to create a milestone for this TTA.

Performance Metrics Markup

Please respond to the Performance Metrics below.  The Performance Metrics questions are based on the TTA Type indicated in the General Information section of the TTA.

TTA Event Date
-
Cover Letter Instructions

Please submit a signed letter of support from your agency’s executive or other senior staff member. The letter can be emailed to or uploaded with this request. The letter should be submitted on official letterhead and include the following information:

  1. General information regarding the request for TTA services, i.e., the who, what, where, when, and why.
  2. The organizational and/or community needs specific to the request for TTA services.
  3. The benefits or anticipated outcomes from the receipt of TTA services.

By submitting this application to BJA NTTAC, I understand that upon approval of this application for TTA, the requestor agrees to keep BJA NTTAC informed of any circumstances that may impact the delivery of the TTA, including changes in the date of the event, event cancellation, or difficulties communicating with the assigned TTA provider.

Please call [site:phone] if you need further assistance completing this application.

I Agree
Off
Archived
Off
Remote TTAC ID
0