November 9, 9:00am - November 10, 5:00pm - Remote via Microsoft Teams
Note: Due to the continued need for social distancing the class will be held remotely via Microsoft Teams. Switching to the remote format, Part 1 classes will start earlier on Monday (9 AM), and will conclude on Tuesday by 5 PM. When enrolling, please note this time change. 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) - the Extract, Transform, and Load (ETL) Process. 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.
- 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 5pm.
Class begins Tuesday at 9am and concludes at 5pm.
RELX and LexisNexis employees should register using the approved promo code provided by their manager or contact firstname.lastname@example.org.
Click to enroll in Part 1. To enroll in Part 2, click on the following link: Enroll in Introduction to ECL (Part 2) - the Extract, Transform, and Load (ETL) Process