Advanced ECL (Part 1) – Working with Relational Data

May 15, 9:00 am – May 16, 5:00 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 5 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 examines in detail the ECL functions that make it easy to work with Relational data in the HPCC Systems platform. ECL began as an extremely powerful query language built around easily querying into Relational Data. The techniques taught here reveal that power to its fullest.

Note: This course is the first in a two-part advanced series. People who attend the Advanced ECL (Part 1) – Working with Relational Data class, should also attend the Advanced ECL (Part 2) – Super files, Working with XML, and Free-form Text Parsing. Both classes are presented in the same week.

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL (Part 1) – Concepts and Queries and Introduction to ECL (Part 2) – Super files, Working with XML, and Free-form Text training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

  • Creating hierarchical relational datasets (Nested Child Datasets)
  • Nested Child Dataset Definitions (RECORD/DATASET)
  • NORMALIZE and DENORMALIZE
  • Complex Multi-level Relational Querying

Class begins Monday at 9am and concludes at 5pm.
Class begins Tuesday at 9am and concludes at 5pm.

RELX and LexisNexis employees should register using your work email address and the approved promo code provided by their manager or contact training@hpccsystems.com.

Enroll in Advanced ECL (Part 1)

Enroll in Advanced ECL (Part 2)