The National White Collar Crime Center (NW3C) was asked to conduct several presentations during the 2023 National Cyber Crime Conference in April 2023 in Norwood, Massachusetts. This entry represents the speaker and presentation as follows:
Presenter: Chris Atha/Robert Leazenby
Title: SQLite Shenanigans; when your investigation is not a menu item!
Description: While your favorite restaurant may desire more flare, the most prevalent data storage format relevant to mobile devices cases merely wants to be talked to...the right way. This lab is a crash course in crafting SQLite queries to maximize the evidence available to you in your investigations. Specifically focusing on third-party applications and system artifacts which are not supported by your available tools. The newest iOT apps are often developed quicker than even the best forensic tools can keep up, work smarter, not harder to expand your capabilities. Even if you have never written an SQLite query, you will be able to participate in this lab and build your database of skills.
Please check the box next to the following questions if the answer is 'yes'.
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.
If the TTA is targeted to a particular audience or location, please complete the questions below.
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.
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.
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:
- General information regarding the request for TTA services, i.e., the who, what, where, when, and why.
- The organizational and/or community needs specific to the request for TTA services.
- 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.