Introduction to ECL (Part 1) – Concepts and Queries

November 11, 9:00 am – November 12, 4:30 pm – Remote via Microsoft Teams

As we continue with a remote format, Part 1 classes will start on Monday at 9 AM, and will conclude on Tuesday by 4:30 PM. When enrolling, please note these times are different from our onsite schedule in the past. Your instructor will send you a welcome email with details on what you will need after enrolling and login information before the class begins.

This class is for developers who want to understand the HPCC Systems platform and learn ECL to build powerful data queries. Anyone who needs a basic familiarity with ECL should take this course.

Note: This course is the first in a two-part introductory series. People who attend the Introduction to ECL (Part 1) – Concepts and Queries class, should also attend the Introduction to ECL (Part 2) – Data Profiling and Transformation. Both classes are presented in the same week.

Course Length: 2 days

Class Prerequisites: None. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

  • HPCC Systems Overview (THOR and Roxie)
  • Introduction to ECL Concepts and Syntax
  • Using the ECL IDE and ECL Watch programming tools
  • Flat and CSV File Sprays
  • Defining Files (RECORD/DATASET)
  • Record Filtering
  • Basic definition types – Boolean, Value, Set, Recordset
  • Creating Simple ECL Queries
  • Managing your ECL code
  • Despraying Files

Class begins Monday at 9am and concludes at 4:30pm.
Class begins Tuesday at 9am and concludes at 4:30pm.

RELX and LexisNexis Risk Solutions employees should register using your work email address and the approved promo code provided by their manager or contact

Enroll in Introduction to ECL (Part 1)

Enroll in Introduction to ECL (Part 2)