Tout ce dont vous avez besoin pour analyser vous-même les données relatives aux mobiles et aux applications

Formation certifiée à l'analyse forensique de SQLite, programme complet

advanced level | 24 cpe's | updated 2026

Apprendre la criminalistique SQLite 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.

Conçue autour de scénarios réels et de nouveaux défis CTF, la formation se concentre sur l'interprétation médico-légale approfondie, le décodage au niveau de la page et les compétences pratiques pour les enquêtes numériques avancées.

Formation certifiée

Formation certifiée à SQLite Forensics

Advanced SQLite forensics training for investigators who need to recover, decode, validate, and explain SQLite evidence from mobile apps and digital systems.

What you will learn

  • Understand SQLite internals, pages, records, freelists, and overflow structures
  • Analyze WAL/SHM files and reconstruct forensic timelines
  • Recover deleted data and rebuild records from fragments
  • Validate findings for reporting, review, and testimony
  • Apply practical workflows using SQLite Visualizer software

Who it is for

Forensic examiners, investigators, incident responders, and analysts who need to go beyond standard tool output and understand SQLite evidence at a deeper level.

Why teams choose it

  • Certificate of completion and 24 CPE credits
  • Built for modern mobile and app-based investigations
  • Hands-on labs with realistic forensic scenarios
  • Available On-Demand, Live Online, or Onsite
  • Bundled with SQLite Visualizer Basic or Advanced

Want the full syllabus or help choosing a training format?

Training Formats

Choisissez votre format de formation

Choose the delivery format that fits your team. Each training package includes certified SQLite Forensics training and a SQLite Visualizer license.

Certificate + 24 CPE credits
Hands-on labs and CTF challenges
SQLite Visualizer included
Not sure which training format is right? Ask us for a recommendation ⟶
Contenu du cours - Certified SQLite Forensics
Résultats de l'apprentissage

What You’ll Learn

Build the skills to interpret SQLite evidence with confidence — from raw database structures to deleted records, WAL activity, and court-defensible reporting.

Core Skills

  • Comprendre comment SQLite stocke les données See how apps write, delete, and structure data inside SQLite databases.
  • Lire les fichiers de base de données bruts en toute confiance Explore SQLite files manually without relying only on black-box tools.
  • Récupérer les données supprimées ou cachées Extract freelist content, overflow records, and fragments others often miss.
  • Use a repeatable forensic workflow Navigate unsupported databases and validate findings step by step.
  • Explain findings clearly Present what you found and how you found it in reports or testimony.

Included in Your Training

  • Realistic mobile app datasets Work hands-on with data based on practical forensic scenarios.
  • Défis médico-légaux de type CTF Apply recovery and validation skills in structured practical exercises.
  • SQLite internals explained visually Learn headers, pages, freelists, overflow chains, WAL, and SHM step by step.
  • Flexible delivery formats Train on-demand, live online, or onsite depending on your team’s needs.
  • Certificate and 24 CPE credits Receive verifiable completion documentation for professional records.

Ready to explore the full training package?

Contenu du cours

Training Modules

A practical, structured course covering SQLite fundamentals, database internals, deleted data recovery, and WAL/SHM analysis.

01 Introduction à la criminalistique SQLite +
  • Comprendre les listes PL et les fichiers XML
  • Travailler avec des données encodées en base64
  • Introduction to SQLite databases
  • Vue d'ensemble des tampons de protocole
  • Explorer le format B-Tree
  • Quiz + pratique inclus
02 Structure de la base de données SQLite +
  • The database header
  • Page headers
  • Variable-length integers, or VarInts
  • Manual record parsing
  • Blocages et fragmentation
  • Freelist pages and deleted data
  • Overflow pages and large record chains
  • Quiz + pratique inclus
03 Création et navigation dans les bases de données SQLite +
  • Creating tables and schema
  • Inserting and adding records
  • Running and analyzing SQL statements
  • Deleting records and forensic implications
  • Quiz + pratique inclus
04 Reconstruction et récupération des bases de données +
  • Case study introduction
  • Structural analysis of SQLite files
  • Freeblock recovery techniques
  • Rebuilding freelist trunk pages
  • Recreating interior table leaf pages
  • Finalizing reconstruction
  • Quiz + pratique inclus
05 WAL & SHM Analysis +
  • Pourquoi SQLite utilise WAL et SHM
  • Dissecting the WAL file
  • Understanding SHM and page frame mapping
  • Visualizing WAL growth over time
  • Forensic use of WAL/SHM in investigations
  • Quiz + pratique inclus
Also Included

Ce qui est inclus

The course is designed to support practical learning, repeatable workflows, and defensible forensic analysis.

Interactive CTF Challenges Work through realistic forensic puzzles using mobile app data.
SQLite Visualizer Software Training packages include SQLite Visualizer Basic or Advanced.
Downloadable Labs Practice with deleted, fragmented, and overflowed SQLite content.
Expert Guidance Instructor support and guidance for course-related questions.
Flexible Access Choose on-demand, live online, or onsite delivery formats.
Certificate + CPE Receive a certificate of completion and 24 CPE credits.

Need help choosing the right training format?

A qui s'adresse ce cours - Certified SQLite Forensics
Who It’s For

Built for Digital Forensic Professionals

This course is designed for investigators and analysts who need to go beyond standard tool output and interpret SQLite evidence with confidence, precision, and defensibility.

Il est particulièrement utile si vous :

  • 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.
Aucun codage ou script n'est nécessaire.

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’ll work hands-on with realistic data, solve investigative challenges, and learn how SQLite behaves in real cases.

CTF-Style Challenges Solve forensic puzzles, decode structures, and uncover hidden SQLite evidence.
SQLite Visualizer Included Use visual workflows to examine pages, records, WAL activity, and deleted data.
Step-by-Step Recovery Labs Practice recovery from freelist pages, overflow chains, WAL frames, and fragments.
Realistic Datasets Train with instructor-created examples based on modern apps and case scenarios.
Tool-Agnostic Skills Use your existing tools while learning how to validate and explain the underlying data.
SQLite Internals Master B-Trees, VarInts, serial types, freelists, overflow pages, WAL and SHM.
Premium Packages
Available as software + training bundles.

Choose On-Demand + Basic, On-Demand + Advanced, Live Online + Advanced, or Onsite + Advanced depending on your workflow and team size.

Not sure which training format fits your team?

Votre instructeur - Certified SQLite Forensics
Votre instructeur

Learn From James Eichbaum

James Eichbaum is a seasoned 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.

Connectez-vous avec James sur LinkedIn
Faits marquants de la carrière
  • 17+ years teaching digital and mobile forensics
  • Ancien responsable mondial de la formation chez MSAB
  • Instructeur certifié P.O.S.T. de Californie
  • Former Detective, Sacramento Valley High Tech Crimes Task Force
  • Former Special Deputy U.S. Marshal, FBI Cyber Crimes Task Force
  • Récipiendaire du prix HTCIA "Cas de l'année".

Want to review the full curriculum or discuss training options?

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
Approche de la formation

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

Options de formation - Certified SQLite Forensics

Choisissez votre format de formation

Choose the training format that fits your workflow. Each option includes Certified SQLite Forensics training and a SQLite Visualizer license.

À la demande Self-paced

On-Demand + Basic

Certified self-paced training with Basic software

€1,490
$1,750 · CAD $2,400
Par participant
  • Certified SQLite Forensics training
  • SQLite Visualizer Basic included
  • Online learning platform access
  • Hands-on labs & CTF-style challenges
  • Updates, support & onboarding
  • Certificate + 24 CPE credits
Best for self-paced training
with Basic software.
Contacter les ventes
À la demande Self-paced

On-Demand + Advanced

Certified self-paced training with Advanced software

€1,950
$2,300 · CAD $3,125
Par participant
  • Certified SQLite Forensics training
  • SQLite Visualizer Advanced included
  • LevelDB Viewer included
  • Online learning platform access
  • Hands-on labs & CTF-style challenges
  • Certificate + 24 CPE credits
Best for advanced analysis
and self-paced training.
Contacter les ventes
Vivre en ligne Instructor-led

Live Online + Advanced

Certified instructor-led remote training for teams

€2,290
Par participant
Available for groups of 3+
  • Certified SQLite Forensics training
  • Instructor-led live online delivery
  • SQLite Visualizer Advanced included
  • LevelDB Viewer included
  • Real-time Q&A and guided labs
  • Certificate + 24 CPE credits
Best for teams that want
guided remote training.
Contacter les ventes
Onsite In-person

Onsite + Advanced

Certified in-person training for teams

From €3,890
Par participant
Available for groups of 5+
  • Certified SQLite Forensics training
  • Onsite instructor-led delivery
  • SQLite Visualizer Advanced included
  • LevelDB Viewer included
  • Delivered at your location or partner-hosted venue
  • Certificate + 24 CPE credits
Best for larger teams
and partner-hosted training.
Contacter les ventes
Planning to train your whole team? We can help you choose the right training format based on group size, delivery preference, and software needs.
Get in touch for training options ⟶
Certification - Certified SQLite Forensics
Certification

Certificate + 24 CPE Credits

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

Certificat de fin d'études A signed, verifiable certificate confirming successful completion of the Certified SQLite Forensics Course.
24 CPE Credits Supports continuing education requirements for forensic, cyber, and investigative professionals.
Sécurisé et vérifiable Each certificate is individually issued with identifying details suitable for documentation and audit purposes.
Pertinent au niveau mondial Designed for investigators and forensic teams working across law enforcement, corporate, and private sectors.
Professional Record
Built for defensible professional development.

The course is designed to support 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’ll 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 packed days — or through the self-paced 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

  • Décodage manuel des fichiers WAL et SHM
  • Récupération des chaînes de freelists et des pages non allouées
  • Exercices basés sur des cas concrets utilisant des ensembles de données réalistes
  • SQLite Visualizer software included in Premium packages
  • CTF-style challenges designed for forensic use
  • 24 crédits CPE et un certificat vérifiable
Premium Packages
Available as software + training bundles.

Choose On-Demand + Basic, On-Demand + Advanced, Live Online + Advanced, or Onsite + Advanced depending on your workflow and team size.

Want help choosing the right training package?

FAQ - Certified SQLite Forensics
FAQ

Questions fréquemment posées

Answers to common questions about course format, access, certification, tools, labs, and Premium software + training bundles.

01 Combien de temps faut-il pour suivre l'intégralité de la formation ? +

En direct : Cette formation se déroule sur trois jours complets avec des sessions dirigées par un instructeur, des laboratoires et des études de cas interactives.

A la demande : Same core content, but self-paced. Access terms may vary by package and delivery format.

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 Est-il adapté à des équipes ou à une formation à l'échelle de l'agence ? +

Yes. Live Online training is available for groups of 3+, and Onsite training is available for groups of 5+. We can help recommend the right package based on team size and delivery preference.

04 Dois-je avoir une expérience préalable des bases de données ? +

No prior database expertise is required. The course starts from the ground up and explains SQLite internals visually, with practical labs and forensic use cases throughout.

05 Quels types de laboratoires sont inclus ? +

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

06 Qui enseigne ce cours ? +

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.

07 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.

08 Le certificat est-il reconnu ? +

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

09 Puis-je poser des questions ou obtenir de l'aide pendant le cours ? +

Yes. Live participants can ask questions during sessions. On-Demand participants receive support according to their package and access terms.

10 Serai-je en mesure d'appliquer ces connaissances dans le cadre d'enquêtes réelles ? +

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

11 Le cours comprend-il des défis de type CTF ? +

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

12 Do I get access to SQLite Visualizer? +

Yes. Premium software + training bundles include SQLite Visualizer Basic or Advanced, depending on the selected package. Advanced packages also include LevelDB Viewer.

13 What training package options are available? +

There are four Premium software + training bundle options: On-Demand + Basic, On-Demand + Advanced, Live Online + Advanced, and Onsite + Advanced.

14 Quel est le degré de technicité du cours ? +

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 Avec quels types d'ensembles de données vais-je travailler ? +

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 Ce cours s'adresse-t-il à des praticiens de niveau expert ? +

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

17 Comprend-il une analyse WAL et 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 La formation est-elle neutre par rapport aux fournisseurs ? +

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

19 What background is recommended? +

Some experience in digital forensics, mobile analysis, DFIR, or investigative work is helpful. Coding, scripting, or prior database training is not required.

20 Puis-je appliquer ces connaissances en dehors de la criminalistique mobile ? +

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.

Ce que les professionnels disent de ce cours

Akira H.

Analyste en criminalité numérique
⭐️⭐️⭐️⭐️⭐️
Ce cours a dépassé toutes mes attentes. L'explication des structures WAL/SHM et des flux de travail de récupération manuelle m'a donné confiance pour défier les limites des outils dans des enquêtes réelles.

Renata S.

Consultant en criminalistique mobile
⭐️⭐️⭐️⭐️⭐️
J'ai suivi de nombreuses formations, mais aucune aussi immersive et pratique que celle-ci. La combinaison de laboratoires pratiques, de CTF et de principes internes de SQLite a rendu cette formation incroyablement utile pour mon travail avec les données des applications Android.

Jeroen V.

Enquêteur de l'unité de cybercriminalité
⭐️⭐️⭐️⭐️⭐️
La reconstruction manuelle des pages de la liste de diffusion et le décodage des variantes m'ont permis de résoudre une affaire quelques semaines seulement après la formation. James a une rare capacité à expliquer des sujets complexes de manière claire et pratique.

SQLite Visualizer.
Visualize, Decode, Explore. All-in-One SQLite Analysis Suite.

SQLite Visualizer was developed to enhance the way forensic professionals interact with SQLite data, both during training and in real investigations. This forensic suite was originally designed specifically for this course to complement the techniques you’ll learn and make advanced database analysis more accessible and efficient.

Cette suite regroupe le décodage, la visualisation et l'interprétation en une seule interface. Elle simplifie le processus de travail avec les fichiers WAL, les varints, les pages de débordement et les enregistrements structurés, en vous aidant à obtenir des informations plus claires sur les données complexes des applications mobiles.

Dans le cours SQLite Forensics, vous utiliserez l'outil tout au long du cours dans des laboratoires et des scénarios réels, et vous le conserverez par la suite. C'est une ressource sur laquelle vous pouvez compter pour examiner les données d'application, récupérer les enregistrements supprimés ou valider les résultats avec précision.

This reflects our belief that effective training should leave you with practical skills and the tools and methods to apply them right away.

ED SQLite Visualizer — forensic SQLite analysis tool showing database structure, WAL frames and deleted record recovery
SQLITE forensics
Mobile Forensics 2026

Why SQLite Still Matters in Mobile Forensics

SQLite remains the backbone of mobile app storage, powering everything from chat histories and location logs to app settings, cached media, and application artifacts.

Tools extract the data. SQLite knowledge explains it.

While forensic tools handle basic extraction well, they often stop short of revealing what is stored deeper inside database internals such as Write-Ahead Logs, overflow chains, freelists, or custom schemas unique to each app.

As mobile software evolves rapidly, examiners increasingly face situations where data is only partially decoded, misinterpreted, or missed altogether. Understanding the inner workings of SQLite has become essential for reliable mobile analysis.

This course was built with that reality in mind. You’ll learn how to break down SQLite at the structural level, recover data manually, interpret how records are organized, and spot patterns or anomalies that tools alone may not explain.

Practical outcome More control in complex or time-critical mobile investigations.

Related content

Ce guide pratique fournit aux enquêteurs des techniques claires et concrètes pour extraire les Apple Notes chiffrées des appareils iOS 16.x. Vous suivrez un processus pratique, étape par étape, conçu pour aller au-delà des résultats de l'outil par défaut, en vous donnant les connaissances et la confiance nécessaires pour traiter efficacement des affaires complexes.

Le décodage manuel des VarInts peut bloquer votre processus d'analyse, en particulier lorsque vous naviguez dans des bases de données incohérentes ou peu familières. Cet outil accélère l'interprétation et vous aide à vous concentrer sur une analyse plus approfondie. Il est gratuit et conçu pour les enquêteurs qui travaillent sur les aspects internes de SQLite.

SQLiteVisualizer unifies visual exploration, decoding, SQL analysis, and deleted-data recovery into one seamless workflow. No exports, no tool switching, no lost context.

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.

Lorsqu'une seule page SQLite ne peut contenir un contenu volumineux tel que des images ou des médias, ces données se répandent dans des pages de débordement. Ce guide vous explique comment récupérer manuellement des enregistrements fragmentés, en révélant des éléments que les outils de découpage classiques négligent souvent.

rester informé

Restez informé. Inscrivez-vous à notre lettre d'information mensuelle.

Soyez le premier à être informé des nouvelles opportunités de formation, des outils gratuits, des articles de blog basés sur des cas concrets et des idées pratiques. Notre lettre d'information mensuelle est conçue pour vous aider à apprendre plus rapidement, à résoudre des cas plus intelligemment et à rester à jour dans un domaine qui n'est jamais figé.

Remplissez votre email pour vous inscrire.

Demande de formation

Cette demande n'est en aucun cas contraignante. Indiquez-nous les dates qui vous conviennent et le nombre de participants que vous souhaitez inclure. Nous vous contacterons rapidement pour discuter ensemble des meilleures options.

This SQLite forensics training is designed for digital forensics investigators who need to go beyond tool output. You’ll learn to manually parse SQLite database structures including B-tree pages, cell arrays, freelist pages, overflow chains, WAL files, SHM data, VarInt encoding, freeblock recovery, and protocol buffer interpretation. Whether you are investigating mobile device data, app databases, browser artifacts, or cloud-synced SQLite files, the course gives you the skills to extract, validate, and explain SQLite evidence with confidence. SQLite Visualizer is included with training packages to support hands-on analysis throughout the course.

Vous préférez apprendre à votre propre rythme ?

Disponible en on-demand →