Advanced SQLite Queries with Belkasoft - On-Demand Training Course

This hands-on course is built for digital forensics professionals and incident responders looking to level up their skills in SQLite forensics. You will learn how to leverage SQLite queries to validate DFIR tool extractions, dig deeper into case data, and approach unsupported databases. Using real-world examples like WhatsApp and Facebook on Android and iOS, you will gain practical experience creating advanced queries effectively to make the most of digital evidence.

What does the course include?

• Training materials: Video tutorials, pre-recorded webinars, and expert articles.

• Practical hands-on approach: Practical tasks designed to reinforce knowledge.

• Duration: 6+ hours of content (self-paced learning, can take up to a few days depending on the participant's pace).

• Clear structure: Content is conveniently divided into 5 sections.

In this training, you will learn:

• How to use Belkasoft X's SQLite Viewer to find important information both in "normal" and special areas of SQLite.
• How to write and execute SQLite queries.
• How to convert SQLite timestamps into a human-readable format.
• How to get data from several SQLite tables at the same time, using various join statements and conditions.
• How to modify existing SQLite queries and handle common errors.
• How to use Belkasoft Query Builder to explore database structures and design queries in an intuitive graphical interface.

Certification and CPE credits:

• Certificate of completion: Awarded to all participants who complete 100% of the training course.
• Certificate of achievement: Awarded to those who complete an optional certification exam.
  • Access to the certification exam can be purchased for $99.
  • The certification exam is free for Belkasoft X paid license owners.
• CPE credits: Successful completion of the course will earn you 6 CPE credits (Continuing Professional Education).

Warnings and Safety Guidelines for Software Use

Based on the requirements of Regulation (EU) 2023/988 on General Product Safety (GPSR), we present a list of safety warnings. The purpose is to protect users from potential hazards resulting from improper use of products/devices/software. The warnings are formulated in a simple and understandable way to ensure accessibility for a wide audience, including elderly people and individuals with mobility limitations.

List of hazards and safety precautions for software use

1. Risk of data loss or system damage
* Hazard: improper installation, deletion of system files, or lack of backups.
* Precautions: always perform regular backups; install software only from trusted sources.

2. Exposure to cyberattacks (viruses, malware)
* Hazard: downloading files from unverified websites, lack of antivirus protection.
* Precautions: use up-to-date antivirus programs, avoid opening suspicious email attachments, enable automatic updates.

3. Hardware overload and overheating
* Hazard: intensive software use (e.g., graphics processing, floating-point calculations, BF) may lead to device overheating.
* Precautions: use the device in a well-ventilated area, do not cover ventilation openings. If overheating occurs – turn off the device and wait several minutes for it to cool down.

4. Risk of electric shock and cuts (indirect)
* Hazard: although software itself poses no physical risk, improper use of computer equipment (e.g., touching cables in a damp environment) while using programs can be hazardous.
* Precautions: never operate computer devices with wet hands, avoid working in damp rooms, and regularly check cables and casings.

5. Health risks from prolonged use
* Hazard: eye strain, back pain, wrist and shoulder discomfort caused by long hours of computer work using office software.
* Precautions: take regular breaks every 45–60 minutes, use an ergonomic chair and keyboard, and position the monitor at eye level.

6. Dangers for children and inexperienced users
* Hazard: children may accidentally download harmful programs or share personal data.
* Precautions: enable parental controls, do not leave children unattended at the computer, and educate them about safe online behavior.

7. Problems in high-humidity or high-temperature environments
* Hazard: using software in high-temperature conditions (e.g., laptop on the lap in direct sunlight) or in humid environments (e.g., kitchen, bathroom) can cause hardware failure and indirect user risks.
* Precautions: use the equipment in suitable climate conditions, avoid using it near heat sources or in high-humidity areas.

8. Risks related to maintenance and updates
* Hazard: lack of software updates may create security vulnerabilities – unskilled attempts to modify the system may result in data loss.
* Precautions: always install official updates; do not modify system files without technical knowledge. Use authorized service support.

Importance of Following Warnings
Adhering to the above warnings minimizes the risk of bodily injury, equipment failure, and material loss. Ignoring these recommendations may lead to serious health and property hazards. Ensure your safety and that of others by following the indicated precautions. Detailed warnings or safety information about the product can be found in the user manual included with the product or available as a PDF on the manufacturer’s/supplier’s website.