ECL is a remarkably powerful language for solving big data challenges — as you start learning the language, the ideas will begin to flow.
Our training options are sorted into learning tracks to make it easy to figure out what classes you should take in what order.
First, select the learning track that best fits your needs. Once you have identified the courses you need, you can get started
right away with our online classes or check the schedule and attend the next in-person class.
Introduction to ECL (Part 1): Concepts and Queries
This class is for developers who want to understand HPCC Systems and learn ECL to build powerful data queries. Anyone who needs a basic familiarity with ECL should take this course.
Students are welcome to bring their own laptops to take away the code and examples from the class.
Introduction to ECL (Part 2): The Extract, Transform, and Load (ETL) Process
This class is for developers who want to extend their knowledge of ECL to Extract, Transform, and Load (ETL) any data with the HPCC Systems environment. Anyone planning to write and work with ECL code should attend this course.
Students are welcome to bring their own laptops to take away the code and examples from the class.
Advanced ECL (Part 1): Working with Relational Data
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.
Class prerequisites: Introduction to ECL (Part 1) and Introduction to ECL (Part 2)
Students are welcome to bring their own laptops to take away the code and examples from the class.
Advanced ECL (Part 2): Super Files, Working with XML, and Free-Form Text Parsing
This course explores the concept of Super Files in ECL and the techniques for working with XML data, getting it into your HPCC Systems cluster, and defining it to work with other data elements. This flows naturally into the detailed ECL support of Natural Language Parsing – creating pattern-matching definitions and using the PARSE function to extract data from either XML or free-form text.
Topics include:
SuperFiles and SuperKeys
Simple XML Spray and Dataset Definition
Working with XML Data (simple, complex, and nested)
Students are welcome to bring their own laptops to take away the code and examples from the class.
ROXIE ECL (Part 1): Indexes and Queries
This class is for developers who want to extend their knowledge of ECL to developing ROXIE queries for end-user use. In this course you will learn the benefits of payload indexes, as well as use of the indexed joins that make query results fast. Anyone planning to write ECL code to provide final-product data to end-users should attend this course.
Class prerequisites: Introduction to ECL (Part 1) and Introduction to ECL (Part 2)
Students are welcome to bring their own laptops to take away the code and examples from the class.
ROXIE ECL (Part 2): Complex Query Development
Learn how to optimize and organize your ROXIE queries for optimal performance. This class reviews and recommends best practices used in ROXIE development, including INTERFACE, Half Keyed JOINS, LIMIT, superkeys, and package maps.
Topics include:
Using INTERFACE Structures with ROXIE Queries
Limiting Your ROXIE Results (LIMIT, JOIN, CHOOSEN)
This class is for anyone who wants to understand the HPCC Systems platform and see how ECL can build powerful data queries. Any manager who needs a basic familiarity with HPCC Systems should take this course.
Topics include:
HPCC Systems Overview (Thor and ROXIE)
Introduction to ECL Concepts and Syntax
Introduction to the ECL IDE and ECL Watch programming tools
Students are welcome to bring their own laptops to take away the code and examples from the class.
HPCC Systems Administration
This course is for anyone who wishes to maintain and manage an HPCC Systems Cluster. Lessons focus on the daily
operations of an HPCC Systems Administrator, and introduces best practices that have been recommended by members of
our in-house LexisNexis RISK Solutions HPCC Systems team.
Informal Thor and ROXIE Administration classes are presented by the LexisNexis Risk Solutions HPCC Systems
Operations team in Boca Raton when requested. Please contact us at [email protected] for more information.
Advanced HPCC Systems Administration: ROXIE Clusters
This class is for system administrators who will be maintaining ROXIE environments.
Class prerequisites: Introduction to HPCC Systems Administration: Thor Clusters
Informal Thor and ROXIE Administration classes are presented by the LexisNexis Risk Solutions HPCC Systems
Operations team in Boca Raton when requested. Please contact us at [email protected] for more information.
How to... YouTube Video Library
How to... recordings have been prepared by our developers to help you get started quickly on a variety of topics.
This series is a great place to visit
if you don't have much time and want to find a quick answer about a specific task. We are adding to the list all the time, so keep
checking back for new tips and tricks to help you get the most out of using HPCC Systems.
HPCC Systems Badges
Complete each learning track to earn a digital badge! Each badge includes embedded data that verifies the recipient’s skills and achievements.
View all HPCC Systems badges available, select your learning track, and work your
way to earning your first badge.
We also provide onsite training at your location. A minimum of 10 students is required with a maximum of 20 students. Price is per-person plus
travel expenses. Contact us for more information at [email protected].
ECL and the whole paradigm of crossing data is just simpler and so much easier to use. It also lets us program to the data that we're dealing with, as opposed to the hardware that it’s running on.
The ECL language proved to be very efficient in expressing complex concepts in few lines of code.
Opera Solutions
The advantage of HPCC Systems technology is being Open Source. Is it allows students to hook into it and modify it and then connect it to other technologies that they’re using.
Jon Preston
Kennesaw State University
We really like working with the HPCC Systems platform. I just like the whole concept of open source. It is very good for our research community.
Dr Vincent Freeh
North Carolina State University
It handles certain sets of large information processing with a native intelligence. With other programs, it’s like you’re teaching them how to speak your language. With HPCC Systems, it’s like you speak the same language as the data that I’m presenting to you. I believe that’s a net positive.