What is SQL & Regex?
SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is the most common query language for interacting with database engines. With databases (especially SQLite) becoming more of a focus during investigations it is essential that investigators are well equipped to understand and extract data form these databases in a structured and meaningful way.
Regular Expressions (Regex, sometimes known as “grep”) provide a flexible method to match patterns of characters. Regular Expressions can be used to validate (and therefore search for) patterns of data (usually text) without knowing the exact content. They can contain string literals, options, exclusions and quantifiers in order to create flexible patterns. The theory behind regular expressions originated in the 1950s, and implementation started in the 1960s. Today regular expressions are widely supported in programming languages, including Java and Python, and is built into the syntax of others, including Perl and ECMAScript.
This course provide delegates with the understanding and skills needed to be able to extract and understand the structure and schema of an SQL database. Delegates will be able to examine the areas of regular expressions (Regex) to search for patterns of data in text and binary without knowing the exact content. Static keywords are not always enough for searching and Regular Expressions allow investigators to search flexibly for patterns of data. This is an extremely useful tool for use in digital forensics, whether in isolation or as parts of scripts and other tools.
Who should attend?
Digital Forensic Officers, Analysts and Investigators (Ideally delegates will have had at least 6 months experience in digital investigations) an understanding of SQL is especially important for those involved in analysing mobile devices.
- demonstrate how to extract and understand the structure and schema of an SQL database
- understand and apply simple “SELECT” queries to extract the data desired, with filtering and ordering of the data
- identify and examine where relationships between tables exist and write “JOIN” queries and extract data with these relationships realised
- understanding SQL functions
- explore the areas of regular expressions which allow the matching of a range of flexible patterns in text and binary data, including Booloan OR, Ranges, Wildcards, Quantifiers, Lookaround and Greediness and Laziness
- demonstrate how to write regular expressions
- highlight and identify irregular expressions
- design and apply regular expressions which will validate web addresses
22nd September 2017
CCL Training Academy- Stratford Upon Avon
£595 + VAT
How to book
Booking for this course will be done directly through the CCL Training Academy.
Places will be allocated on a first come, first served basis and we reserve the right to cancel this course if we do not secure a minimum number of delegates.