SQLite Forensics Data Structures micro-course

Get immediate, practical skills to uncover the app evidence your tools miss.

This focused micro-course shows exactly how SQLite stores and deletes data. In just a few hours, you’ll gain practical skills you can apply in your work immediately.

A sneak peek before you join

What you'll learn

Expand
  • See how SQLite structures, saves, and deletes data inside apps
  • Recover deleted and hidden data missed by tools
  • Read raw files confidently without relying on automation
  • Follow a proven forensic workflow step by step
  • Clearly explain findings in reports or court
  • Practice hands-on with real mobile app data
  • Tailored for mobile and app investigations
  • Visual, no-code methods — no SQL required
  • On-demand or live options available
  • Certificate upon completion

Course Content

Expand All Sections
01 – The Database Header
  • Learn what SQLite headers reveal about structure and data format
  • Extract and interpret key values manually
02 – Page Headers
  • Understand how pages are organized in SQLite
  • Identify and interpret key page-level structures
03 – Variable-Length Integers (VarInts)
  • Decode SQLite’s compact number system
  • Apply VarInt logic to manually parse database records
04 – Parsing Records
  • Reconstruct complete rows manually
  • Understand serial types and payload structures
05 – Freeblocks
  • Locate deleted records in freeblocks
  • Understand fragmentation and record remnants
06 – Freelist Pages
  • Recover data from freelist structures
  • Track page reuse and deleted record flow
07 – Overflow Pages
  • Rebuild large records stored across multiple pages
  • Recover images, files, or messages missed by tools

Prefer live online learning with Q&A? Fill out the form to request a session.

This request is non-binding. Share your details, preferred dates and number of participants, and we’ll get back to you shortly.

Prefer a live session? Please share your information below, and we’ll be in touch shortly.

FAQ

FAQ

Expand All
01 –How long does it take to complete the course?

On-Demand: Access all 5 hours of content at your own pace. Ideal for working professionals who want flexibility to train between active cases.

Live Online: Instructor-led sessions conducted remotely. Timing can be customized for your team.

02 –Is the course content updated for 2025?

Yes — this course has been completely redesigned and updated for 2025. It reflects the latest findings, updated SQLite behavior, and modern forensic challenges based on real-world casework.

03 –Can this course be delivered to teams or agencies?

Yes! We offer flexible group training options — including discounted rates for teams of 5 or more. Agencies, labs, and organizations can request custom scheduling and onboarding support tailored to their needs.

04 –Can I get help if I get stuck during the OnDemand course?

Absolutely. We provide instructor email support so you can keep progressing confidently at your own pace.

05 –What if I’ve already taken a mobile forensics training?

Perfect. This course complements those skills by going deeper into database structures. You’ll learn what automated tools often overlook — like deleted records, freelist pages, and raw data reconstruction.

06 –Who teaches this course, and what’s their background?

The course is led by Elusive Data’s senior instructor, James Eichbaum, a forensic specialist who has trained professionals from national police forces, federal, state and local law enforcement, government and military agencies, and global DFIR teams. You’ll learn from someone with deep, practical experience in real investigations. James has been teaching database forensics for over 15 years.

07 –Do I get access to lab files and hands-on practice?

Yes. Every module includes interactive labs using real SQLite data. You’ll apply your learning immediately through guided exercises and downloadable datasets.

08 –Why should I choose this course over others?

This microcourse was designed to fill a crucial gap in forensic training: understanding how SQLite databases actually store, structure, and retain data.

In just a few focused hours, you'll learn how records are laid out across fixed-size pages, how deleted data can persist in freelists, and how large entries are spread across overflow chains.

Through realistic examples and unsupported apps, you’ll work hands-on to decode headers, interpret VarInts, and trace records with precision.

Continuously updated and built for working professionals, this course delivers fast, focused, and practical training without cutting corners.

09 –Do I need programming or advanced SQL skills?

You should be comfortable navigating forensic tools and working with mobile artifacts, but you don’t need to be a developer. We’ll guide you through low-level concepts like freeblock parsing, varints, and freelist recovery with clear explanations and hands-on labs.

10 –Is the course recognized or court-admissible?

Yes. The course is certificate-based and designed by a former law enforcement examiner with real testimony experience. The workflows taught are courtroom-ready and built to hold up under review.

11 –Will I actually be able to use this on my current cases?

Yes. The course is built around real-world app data, not generic examples. You’ll learn practical workflows you can apply immediately — even when your tools fall short.

12 –What if I use tools like Cellebrite, MSAB, Magnet, or Oxygen?

Great — this course is designed to work alongside them. You'll learn how to verify tool output, investigate unsupported apps, and recover evidence those tools often overlook.

13 –If I take this microcourse now, do I have to pay full price for the complete course later?

No — if you later decide to enroll in the complete SQLite Forensics course, we’ll deduct the full cost of this microcourse from your total. Just reach out to us before enrolling in the full course.

Choose Your Training Format

Final price shown at checkout in your currency, depending on your country.

OnDemand

Learn at your own pace with 5 hours of expert-led content. Flexible, self-guided learning.

€299
Price per participant
  • Start anytime
  • 90 days of full access
  • Work at your own pace
  • Certification included
  • Email support & resource library
Start On-Demand Training

Live Online

Join instructor-led sessions remotely. Choose a scheduled class or request a private team session.

€349
Price per participant
  • Scheduled virtual sessions
  • Live instruction & Q&A
  • Interactive labs
  • Certification included
  • Email support & resource library
Get in Touch for Details
Need to train a group? We offer discounts for 5+ participants and can customize delivery for teams.
Contact us for group pricing ⟶

Your Instructor

This course is taught by James Eichbaum, a leading expert in digital forensics and one of the most experienced instructors in mobile and database analysis. With over 15 years of experience teaching SQLite forensics, James has trained professionals across 30+ countries.

He previously served as Global Training Manager at MSAB and has led advanced training for hundreds of organizations worldwide including national police agencies, governments, and private DFIR labs. His instruction combines deep technical skill with extensive field experience from real investigations.

In this micro-course, James guides you through the internal workings of SQLite databases, including deleted records, freelist pages, and overflow structures, using a practical, tool-independent approach designed to give you skills you can apply right away.

Connect with James on LinkedIn
Career Highlights
  • 15+ years teaching digital and mobile forensics
  • Former Global Training Manager at MSAB
  • Former California P.O.S.T. Instructor
  • Detective with Sacramento Valley High Tech Crimes Task Force
  • Special Deputy U.S. Marshal on FBI Cyber Crimes Task Force
  • HTCIA Case of the Year award recipient (2011)