Learn your way! Get started

Forensic Investigator, Part 7: Database Forensics

with expert David Bigger

Watch trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date 8/16/2017
Level Intermediate
Runtime 0h 53m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code N/A
Exams Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

MySQL, Oracle or MS SQL server….which is it running? How do you know? Oracle may be the number one database on the market today, but what does that mean for us as investigators? Coming up, we will be looking at various database management systems and how they work with data. We will dive into Oracle databases, MySQL databases and MS SQL databases so we know where we can look for potential evidence. We will also take a look at some tools and techniques that will allow us to gather the data for our case against the perpetrators.


Recommended: Understanding of networking; How data flows from source and destination Computer security basics such as passwords, encryption and physical security Basic understanding of computing and computer systems Experience with various operating systems

Learning Paths

This course will help you prepare for the following certification and exam:
Computer Hacking Forensic Investigator

Meet the expert

David Bigger David Bigger is the lead trainer at Bigger IT Solutions. He has been information technology for a little over 20 years and has been training all over the US. He has worked with companies like US Military, Lockheed Martin, General Dynamics, Dominos Pizza, University of Utah and Expedia

Course outline

Database Forensics

Database Forensics (12:54)
  • Introduction (00:26)
  • Database Forensics (02:17)
  • Database Review (05:12)
  • Popular DBMS (04:39)
  • Summary (00:19)
Oracle (15:38)
  • Introduction (00:19)
  • Oracle (01:24)
  • Oracle Logical Structure (01:14)
  • Data Blocks (01:41)
  • System Change Number (SCN) (01:41)
  • Where to Look in Oracle (00:54)
  • System Global Area (03:23)
  • Where to Look in Oracle, Continued (03:47)
  • Oracle Forensic Tools (00:48)
  • Summary (00:22)
MySQL (13:21)
  • Introduction (00:20)
  • MySQL (01:36)
  • Data Directory (02:37)
  • Log Files for MySQL (04:02)
  • Were to Look in MySQL (01:31)
  • MySQL Forensic Tools (02:53)
  • Summary (00:19)
Microsoft SQL Server (11:27)
  • Introduction (00:24)
  • Microsoft SQL Server (01:44)
  • Data Storage (03:08)
  • Where to Look on MS SQL Server (03:18)
  • Tools for MS SQL Forensics (00:27)
  • SQL Server Management Studio (00:43)
  • ApexSQL (01:15)
  • Summary (00:25)