full program | advanced level | 24 cpe's | updated 2026

Certified SQLite
Forensics Training

All you need to analyze mobile & app data on your own

Learn SQLite forensics through a certified, hands-on training course built for professionals investigating mobile app data. Available On-Demand, Live Online and On-Site, it gives you the same depth, labs and case data in the format that fits your schedule. Updated for 2026, the course teaches you how to manually analyze and recover data that standard tools may miss, including deleted records, WAL files and unallocated space.

Formación certificada

Formación forense certificada en SQLite

Learn SQLite Forensics through a certified, hands-on training course built for professionals investigating mobile app data. Updated for 2026, this course teaches you how to manually analyze and recover data that standard tools often miss, including deleted records, WAL files and unallocated space.

Diseñada en torno a escenarios reales y nuevos retos de CTF, la formación se centra en la interpretación forense en profundidad, el descifrado a nivel de página y las habilidades prácticas para investigaciones digitales avanzadas.

  • Advanced level
  • 3 days / 24 hours
  • 24 créditos CPE
  • Certificado de aprovechamiento
  • No coding or scripting required
  • On-Demand: €1,299 per student
  • Live Online: By quote
  • On-Site: By quote

Objetivos del curso

  • Comprender la estructura interna y la mecánica de funcionamiento de las bases de datos SQLite.
  • Analyze and manually parse SQLite files, including headers, pages, freelists and overflow pages.
  • Explicar la relevancia forense de los archivos WAL y SHM en el análisis de SQLite.
  • Realice una recuperación de bajo nivel de los registros eliminados y reconstruya las bases de datos manualmente.
  • Desarrollar habilidades para analizar críticamente e interpretar artefactos SQLite para investigaciones digitales.

Who should attend

This course is for mobile forensic professionals ready to go beyond default tool output. It is ideal if you are familiar with standard forensic platforms and want a deeper understanding of what gets parsed and, just as importantly, what often gets left behind.

Basic digital forensic knowledge is helpful. Prior advanced SQLite or SQL experience is not required. The course is designed for investigators, not developers. Techniques are visual, practical and explained step by step.

Principales características del curso

  • Scenario-based learning from evidence discovery to expert reporting.
  • Tool-agnostic methods you can apply across forensic platforms.
  • Real datasets, practical labs and CTF-style forensic challenges.
  • Custom app parsing for deleted messages, media files and data fragments.
  • Practical validation methods for unsupported or incomplete tool output.
Course structure

What you’ll cover

A structured SQLite forensics course that moves from foundations and page-level analysis to deleted data recovery, database reconstruction, WAL/SHM interpretation and final assessment.

Daily focus

Day 1

Foundations and internal SQLite structures

Identify SQLite structures, decode varints and serial types, and manually parse live and deleted records from database pages.

Day 2

Database creation, behaviour and recovery fundamentals

Build and manipulate a database, observe how evidence changes at the byte level, and begin recovering deleted records from freeblocks and freelist pages.

Day 3

Advanced recovery, WAL/SHM analysis and assessment

Complete reconstruction work, analyze transaction files, recover evidence not present in the main database and complete the final practical and knowledge assessment.

Core skills

  • Manual SQLite interpretation Understand headers, pages, records, varints, serial types and B-tree structures.
  • Deleted data recovery Recover evidence from freeblocks, freelist pages, overflow pages and fragments.
  • Database reconstruction Rebuild damaged or incomplete structures and validate recovered records.
  • WAL and SHM analysis Interpret transaction files, map page versions and recover evidence outside the main database.
  • Tool-agnostic validation Verify commercial tool output and explain how evidence is stored and recovered.

Want the full syllabus with the day-by-day structure?

Training modules

Course modules

Five practical modules covering SQLite fundamentals, internal structures, database creation, reconstruction, deleted data recovery and WAL/SHM analysis.

01 Introducción al análisis forense de SQLite +
  • The forensic value of SQLite databases in modern mobile and application investigations
  • Limitations of automated tools and the importance of independent validation
  • Property lists, XML files and common application configuration data
  • Base64 encoding and manual decoding of embedded data
  • SQLite database fundamentals: tables, records, fields and data types
  • Introduction to B-tree organization and page-level storage
  • Protocol Buffers and their use in modern applications
  • Guided exercises, knowledge check and practical activity
02 SQLite Database and Page Structures +
  • The SQLite database header and key file-level values
  • Database page types and page header structures
  • Variable-length integers, or varints, and their role in SQLite
  • Record headers, serial types, payload lengths and manual record parsing
  • Freeblocks and remnants of deleted or modified records
  • Freelist trunk and leaf pages
  • Overflow pages and recovery of large records or BLOB data
  • Hex-level parsing practical using realistic forensic evidence
03 Creación y navegación por bases de datos SQLite +
  • Create a working SQLite database based on a fictional messaging application
  • Define tables, fields, data types and relationships
  • Insert, update, query and delete records using SQLite statements
  • Navigate databases with a graphical SQLite browser and a hex editor
  • Compare the logical database view with the underlying byte-level structure
  • Observe how new records, page growth and deletions affect the database file
  • Use controlled changes to understand where forensic artifacts originate
  • Knowledge check and practical database-building exercise
04 Database Reconstruction and Recovery +
  • Case study: recovering deliberately deleted communications from a damaged database
  • Assess the database structure and identify missing or inaccessible B-tree components
  • Determine why standard viewers and automated recovery methods cannot access the evidence
  • Locate and interpret deleted records stored within freeblocks
  • Examine freelist trunk and leaf pages for recoverable table data
  • Identify page types, cell pointers, record boundaries and candidate evidence
  • Recover table data from freelist pages and convert page structures for analysis
  • Reconstruct missing B-tree navigation required to access recovered records
  • Create or repair an interior table page and restore logical page relationships
  • Validate recovered evidence against page-level structures and known database behavior
  • Document the reconstruction process and distinguish recovered data from original live records
05 Write-Ahead Log (WAL) and Shared Memory (SHM) Files +
  • Why SQLite uses WAL mode and the forensic value of associated transaction files
  • WAL header structure, frame headers, database pages, salts and checksums
  • How WAL files develop as records are inserted, modified, committed or overwritten
  • Identify multiple historical versions of the same database page
  • Understand the SHM file and its role as an index into WAL frames
  • Map database page numbers to WAL frames using SHM index information
  • Distinguish relevant page versions and recover evidence not present in the main database
  • Hands-on WAL/SHM mapping and evidence-recovery practical
Practical outcomes

What you’ll be able to do

The course combines guided explanation with hands-on work, realistic datasets, practical recovery exercises and a final assessment.

Manual analysis

Interpret SQLite structures and records without relying solely on automated tools.

Database reconstruction

Repair damaged or incomplete B-tree structures and validate the result.

Evidence recovery

Locate deleted data in freeblocks, freelist pages and transaction files.

Tool validation

Independently verify commercial tool output and explain how evidence is stored.

Forensic reporting

Explain what was recovered, where it came from and why it matters.

Practical assessment

Demonstrate your skills by interpreting SQLite structures, recovering evidence and explaining findings.

Need help choosing the right training format?

Who should attend

Built for mobile forensic professionals

This course is for mobile forensic professionals ready to go beyond default tool output. It is ideal if you are familiar with standard forensic platforms and want a deeper understanding of what gets parsed and, just as importantly, what often gets left behind.

It is especially valuable if you:

  • Work with mobile app data Analyze SQLite evidence from iOS, Android and other app-based sources.
  • Need to validate tool output Understand what commercial tools found and what they may have missed.
  • Investigate unsupported apps Build confidence working with databases that are not fully parsed by existing tools.
  • Recover deleted or hidden evidence Extract deleted records, freelist content, overflow data, WAL activity and fragments.
  • Prepare reports or expert opinions Explain database artifacts clearly for review, reporting, testimony or court.
  • Want structured, expert-led training Learn SQLite forensics through a practical workflow rather than isolated theory.

No es necesario codificar ni programar.

Basic digital forensic knowledge is helpful. Prior advanced SQLite or SQL experience is not required. The course is designed for investigators, not developers. Techniques are visual, practical and explained step by step.

Want to see the full course outline?

Why it’s different

Practical, visual and case-focused

This course is built to develop real forensic capability. You work hands-on with realistic data, solve investigative challenges and learn how SQLite behaves in real cases.

Scenario-based learning

Afronte auténticos retos de investigación, desde el descubrimiento de pruebas hasta la elaboración de informes periciales.

Enfoque agnóstico de las herramientas

Learn methods you can apply across forensic platforms and manual validation workflows.

Conjuntos de datos realistas

Use real datasets in virtual environments with standard forensic tools.

Custom app parsing

Extract deleted messages, media files and data fragments, even without tool support.

SQLite interno

Understand B-trees, varints, serial types, freelists, overflow pages, WAL and SHM.

Reporting and validation

Learn to explain what was found, where it came from and how it was validated.

Not sure if this course fits your team?

Su instructor

Learn from James Eichbaum

James Eichbaum is a well known digital forensics instructor and practitioner with deep expertise in mobile forensics, SQLite analysis and real-world investigative workflows.

Over the past 17+ years, James has trained thousands of professionals in more than 30 countries, with a consistent focus on practical skills, investigative accuracy and defensible forensic interpretation.

He has led advanced forensic training programs for law enforcement, defense and private-sector teams worldwide, including national police agencies and forensic labs.

In this certified course, James guides you step by step through SQLite internals, from page structures and WAL files to deleted data recovery and validation, using structured labs, realistic app data and CTF-style challenges.

Conecta con James en LinkedIn

Career highlights

  • 17+ years teaching digital and mobile forensics
  • Ex Director de Formación Global de MSAB
  • Instructor certificado P.O.S.T. de California
  • Former Detective, Sacramento Valley High Tech Crimes Task Force
  • Former Special Deputy U.S. Marshal, FBI Cyber Crimes Task Force
  • Recipient of HTCIA Case of the Year award

Want to review the course outline or discuss training?

Certified SQLite Forensics

Practical training for real casework

Built around real-world forensic problems, practical recovery methods and clear interpretation of SQLite evidence.

James Eichbaum, digital forensics instructor teaching SQLite analysis to investigators
17+ Years teaching forensics
30+ Countries trained
24 CPE credits included
Training approach

The course is designed to make complex SQLite structures easier to understand, validate and explain without requiring coding or scripting experience.

Delivery formats

Choose the format that fits your work

The labs, case data and depth are the same. The only thing that changes is how you fit the learning into your schedule.

A la carta

Self-paced training

EUR 1,299 per student

Learn when it works for you, at your own pace, with access to the course content, videos, lab files and practical exercises.

  • Equivalent to 3 days / 24 hours of training
  • Self-paced content, videos and lab files
  • Hands-on labs and CTF-style challenges
  • Knowledge and practical assessment
  • Certificate of completion and 24 CPE credits

En directo en línea

Instructor-led remote training

By quote, groups of 3 or more

Join live sessions from anywhere, ask questions in the moment and work through labs with instructor guidance.

  • Instructor-led sessions with labs
  • Real-time questions and discussion
  • Shared delivery for teams
  • Same course depth and case data as classroom delivery
  • Certificate of completion and 24 CPE credits

En el sitio

In-person team training

By quote, groups of 5 or more

Bring the course to your team with in-person training built around practical labs, discussion and your training goals.

  • Delivered at your location or agreed venue
  • Best for larger teams and organizations
  • Hands-on labs with instructor guidance
  • Scheduling by agreement
  • Group rates available

Not sure which format fits best?

Tell us whether you are looking for individual training or team delivery, and we will help you choose the right format.

Need manager approval? Download a short justification letter you can share with your manager, training coordinator or budget approver.

Download justification letter
Certificación

Certificate and 24 CPE credits

Participants receive completion documentation for professional records, internal reporting, audits and continuing education requirements.

Certificado de aprovechamiento

A signed certificate confirming completion of the Certified SQLite Forensics course.

24 créditos CPE

Supports continuing education records for forensic, cyber and investigative professionals.

Knowledge and practical assessment

Participants complete both knowledge checks and hands-on practical work.

Built for professional records

Suitable for internal documentation, training records and audit support.

Professional record

Built for defensible professional development.

The course supports practical skills, formal training records and repeatable forensic workflows that can be explained clearly.

Need confirmation about certification or CPE documentation?

Full course track

What you gain from the full course

A deep, practical training track for professionals who work with mobile extractions, forensic tools, app databases and SQLite-based evidence.

Course focus

Over three days, or through the equivalent on-demand format, you learn how to read, interpret, recover and validate data directly from raw SQLite structures.

The training combines guided explanation with hands-on practice using realistic datasets, deleted records, freelist recovery, overflow content, WAL/SHM interpretation and CTF-style forensic challenges.

The full course includes

  • Descodificación manual de archivos WAL y SHM
  • Recovery from freelist chains, freeblocks and unallocated pages
  • Database reconstruction and page-level validation
  • Ejercicios basados en casos utilizando conjuntos de datos realistas
  • CTF-style challenges designed for forensic use
  • 24 CPE credits and a certificate of completion
Delivery formats

Available on-demand, live online or on-site.

The course can be delivered as self-paced training, instructor-led live online training or on-site team training by request.

Want help choosing the right delivery format?

PREGUNTAS FRECUENTES

Frequently asked questions

Answers to common questions about course format, pricing, certification, labs, delivery and technical level.

01 ¿Cuánto tiempo se tarda en completar el curso? +

En directo: Delivered over 3 full days with instructor-led sessions, labs and interactive case studies.

A la carta: The same core content in a self-paced format, equivalent to 24 hours of training.

02 Is the training updated for 2026? +

Yes. The course content is updated for 2026 and reflects current SQLite forensic workflows, modern app data, WAL/SHM analysis and practical recovery scenarios.

03 What delivery formats are available? +

The course is available On-Demand, Live Online and On-Site.

A la carta: EUR 1,299 per student.

En directo por Internet: By quote, for groups of 3 or more.

In situ: By quote, for groups of 5 or more.

Group rates are available.

04 ¿Es adecuado para la formación de equipos o de toda la agencia? +

Yes. Live Online and On-Site training are available for teams by request. We can help recommend the right format based on team size, delivery preference and training goals.

05 Do I need prior SQLite or SQL experience? +

Basic digital forensic knowledge is helpful. Prior advanced SQLite or SQL experience is not required. The course explains SQLite internals visually, step by step, with practical labs and forensic use cases throughout.

06 Do I need coding or scripting experience? +

No. The course is designed for investigators, not developers. Techniques are visual, practical and explained step by step. You do not need coding or scripting experience to complete the training.

07 ¿Qué tipo de laboratorios se incluyen? +

Labs include parsing deleted records, rebuilding overflow chains, exploring WAL/SHM files, recovering fragmented content and solving scenario-based challenges using realistic forensic datasets.

08 ¿Quién imparte este curso? +

The course is taught by James Eichbaum, a digital forensics instructor and practitioner with 17+ years of experience training law enforcement, forensic examiners, DFIR consultants and investigative teams worldwide.

09 What if I use tools like Magnet, Cellebrite, Oxygen or MSAB? +

This course complements commercial forensic platforms. You learn how to validate tool output, investigate unsupported apps and understand SQLite evidence beneath automated parsing results.

10 ¿Está reconocido el certificado? +

Participants receive a certificate of completion with 24 CPE credits. It is designed for professional records, internal documentation, audits and continuing education tracking.

11 ¿Puedo hacer preguntas o recibir ayuda durante el curso? +

Live participants can ask questions during sessions. On-Demand participants can contact us with course-related questions while working through the material.

12 ¿Podré aplicarlo en investigaciones reales? +

Yes. The course is built around realistic app data, practical recovery workflows and forensic scenarios that map directly to mobile and application database investigations.

13 ¿Incluye el curso desafíos de tipo CTF? +

Yes. You work through CTF-style forensic challenges designed to reinforce technical SQLite concepts with practical investigation scenarios and realistic datasets.

14 ¿Qué nivel técnico tiene el curso? +

It is a deep forensic course, but it is designed to be accessible. You go into SQLite internals such as WAL, B-trees, varints, freelists and overflow pages, with visual explanations and practical labs.

15 ¿Con qué tipo de conjuntos de datos trabajaré? +

The labs use realistic app databases involving messaging, location, application activity, deleted records, WAL activity, fragmented content and unsupported or partially parsed app data.

16 ¿Es este curso apropiado para profesionales de nivel experto? +

Yes. Experienced examiners, trainers and tool specialists use the course to deepen their understanding of SQLite internals, deleted data recovery and validation workflows.

17 ¿Incluye análisis WAL y SHM? +

Yes. WAL and SHM analysis are core parts of the course, including how to interpret database changes, reconstruct timelines and identify data not present in the main database file.

18 Is the training tool-agnostic? +

Yes. The course focuses on SQLite forensic principles and validation methods that apply regardless of which forensic platform you use.

19 ¿Puedo aplicar estos conocimientos fuera de la investigación forense móvil? +

Yes. SQLite is used in desktop applications, IoT devices, browsers, cloud sync tools and many other systems. The recovery and validation skills apply anywhere SQLite appears.

20 How does this course connect to Firefly? +

SQLite remains central to modern app investigations. The course teaches the forensic methods behind SQLite analysis, including page-level interpretation, recovery and validation. Firefly carries the same principles into a broader forensic workspace for app data investigations across SQLite, RealmDB, LevelDB, IndexedDB and Apple Biome / SEGB.

Opinión de los profesionales sobre este curso

Akira H.

Analista de delitos digitales
⭐️⭐️⭐️⭐️⭐️
Este curso superó con creces mis expectativas. La explicación de las estructuras WAL/SHM y los flujos de trabajo de recuperación manual me dieron confianza para desafiar las limitaciones de las herramientas en investigaciones reales.

Renata S.

Consultor forense para móviles
⭐️⭐️⭐️⭐️⭐️
He tomado muchos cursos de formación, pero ninguno tan inmersivo y práctico como este. La combinación de laboratorios prácticos, CTFs, y SQLite internos hizo increíblemente valioso para mi trabajo con los datos de aplicaciones Android.

Jeroen V.

Investigador de la Unidad de Ciberdelincuencia
⭐️⭐️⭐️⭐️⭐️
Reconstruir páginas freelist manualmente y descodificar varints me ayudó a resolver un caso pocas semanas después de la formación. James tiene una rara habilidad para explicar temas complejos de forma clara y práctica.

Related content

Este tutorial específico proporciona a los investigadores técnicas claras y prácticas para extraer notas de Apple cifradas de dispositivos iOS 16.x. Seguirá un proceso práctico, paso a paso, diseñado para ir más allá de los resultados predeterminados de la herramienta, lo que le proporcionará los conocimientos y la confianza necesarios para gestionar casos complejos con eficacia.

La descodificación manual de VarInts puede atascar el proceso forense, especialmente cuando se navega por bases de datos incoherentes o desconocidas. Esta herramienta acelera la interpretación, ayudándole a centrarse en un análisis más profundo. Es gratuita y está diseñada para investigadores que trabajan con SQLite.

Meet Firefly. One forensic workspace for app data investigations, built on provenance. Recover, interpret, validate and report evidence across SQLite, RealmDB, LevelDB, IndexedDB and Apple Biome / SEGB, with every finding traceable back to its source.

This article shows how protobuf varints differ from SQLite varints and why that distinction matters in mobile forensics. It includes a full hands-on walkthrough of decoding a protobuf blob, extracting fields, and decrypting the final message.

A transformative, certified program designed to take digital forensic professionals from basic experience to confident Python proficiency. Newly updated for 2026, this hands-on training teaches you to build your own scripts to extract, parse, and analyze hidden evidence from app data.

Cuando una sola página SQLite no puede albergar contenidos de gran tamaño, como imágenes o archivos multimedia, esos datos se desbordan en páginas de desbordamiento. Esta guía te muestra cómo recuperar manualmente registros fragmentados, revelando pruebas que las herramientas típicas de tallado suelen pasar por alto.

mantente informado

Manténgase informado. Suscríbase a nuestro boletín mensual.

Be the first to hear about new training opportunities, new tools and updates, case-based blog posts, and practical insights. Our monthly newsletter is built to help you learn faster, solve cases smarter, and keep up in a field that never stands still.

Introduce tu correo electrónico para inscribirte.

Solicitar formación

Esta solicitud no es vinculante. Díganos qué fechas le convienen y cuántos participantes le gustaría incluir. Nos pondremos en contacto con usted lo antes posible para estudiar juntos las mejores opciones.

Mobile forensics 2026

Why SQLite still matters in mobile forensics

SQLite remains one of the most important storage formats in mobile app investigations, powering everything from chat histories and location data to app settings, cached media and application artifacts.

Tools can extract data. SQLite knowledge explains it.

Forensic platforms are essential, but they do not always parse every structure, support every app or show where a result came from. Evidence can remain in WAL and SHM files, overflow pages, freelists, deleted records, custom schemas and fragments that require deeper interpretation.

As mobile apps change quickly, examiners increasingly face unsupported databases, incomplete decoding and artifacts that need independent validation. In those situations, SQLite knowledge helps determine what the data means, how it was stored and whether a finding can be explained.

Certified SQLite Forensics is not a tool-button course. It teaches the forensic reasoning behind SQLite evidence: where data is stored, how deleted records remain, how transaction files preserve changes and how findings can be validated when automated parsing is incomplete or unsupported.

Practical outcome

More control when SQLite evidence is incomplete, unsupported or needs to be explained in a report, review or testimony.

Recuperar

Deleted records, fragments and unallocated content

Interpretar

Pages, records, B-trees, varints and schemas

Validar

Tool output, WAL/SHM activity and recovered data

Explain

Findings for reports, review and testimony

Learn the SQLite evidence behind the tool output.

Certified SQLite Forensics is built for investigators who need to recover what standard views may miss, validate findings independently and explain SQLite evidence with confidence.