SQL Queries and Regex

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.

Course overview

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.

Learning outcomes;

  • 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

Course duration

1 day

Available dates;

April

Course locations

CCL Training Academy- Stratford Upon Avon

London

Cost;

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

Please call us on 01789 261200 or email  if you would like more information and prices for our SQLite training course.
ENQUIRE NOWDownload your booking formDownload the course fact sheet

Your Name (required)

Your Email (required)

Subject

Your Message

×

Your Name (required)

Your Email (required)

Subject

Your Message

×

Case Studies
Case Study – Nuix and ICIJ
Case Study – Nuix and Abbyy
Case Study – Nuix and Bitsec
Case Study – Nuix and Celerity
Case Study – Nuix and Gulfstream
Case Study – Nuix and EDRM
Case Study – Nuix and Guernsey Police
Case Study – Nuix – Financial Institution Saves Two Years and Millions of Dollars

White Papers
White Paper – Nuix and NetClean
White Paper – Digital Investigations

×

Your Name (required)

Your Email (required)

Subject

Your Message

×
Interested in Buying - Epilog

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Training - Epilog

First Name (required)

Last Name (required)

Company (required)

Phone Number (required)

Your Email (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country(required)

Product

Quantity(required)

Interested in any other products?

×
Interested in Buying - Dunk

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - Encase V7

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - Nuix

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - PIP

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - Rubus

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - Signal

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - Clearwell

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - Tracks Inspector

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - X1 Social Discovery

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Interested in Buying - Ribbon

First Name (required)

Last Name (required)

Company (required)

Your Email (required)

Phone Number (required)

Address (required)

Town/City (required)

Post/Zip Code(required)

Country (required)

 

Product

Quantity(required)

 

Interested in any other products?

Thank you for your enquiry, all applications for the purchase of CCL software are evaluated in accordance with the company’s ethics policy and current Government guidelines on trade embargoes and sanctions.

You will receive a communication from our Customer Service department shortly.

Please leave this field empty.

×
Contact us

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close