Remote Training: Introduction to ECL (Part 1) - Concepts and Queries
The class will be held remotely via Microsoft Teams. Your instructor will contact you before the class with login information.
NOTE: 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.
This class is for developers who want to understand the HPCC (High Performance Computing Cluster) 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.
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 will begin at 9am and conclude at 4:30pm. Breaks will be provided throughout the day for lunch and lab assignments. Your instructor will provide more information before the class begins.
