Training

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.

Select your LEARNING track

HIGH LEVEL
ETL DEVELOPERS
ROXIE
OPERATIONS

Introduction to HPCC for Managers

This class is for high-level managers who want to understand HPCC Systems 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
Creating Simple ECL Queries

ONLINE CLASSES

IN-PERSON CLASSES

In-person course length: 1 day

Class prerequisites: None

Students are welcome to bring their own laptops to take away the code and examples from the 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.

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

ONLINE CLASS

IN-PERSON CLASS

In-person 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.

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.

Topics include:

Principles of ETL in ECL
The TABLE Function (Memory Tables)
TRANSFORM Functions (PROJECT, etc.)
Data Hygiene (Cleaning and Standardization)
Lookup Tables
OUTPUT to Disk Files
Simple JOINs

ONLINE CLASS

IN-PERSON CLASS

In-person course length: 2 days

Class prerequisites: Introduction to ECL (Part 1)

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.

Topics include:

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

ONLINE CLASS

IN-PERSON CLASS

In-person 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.

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)
Complex XML Spraying and De-spraying
PARSE with XML Data
Spraying and defining free-form text data
PARSE with free-form text

ONLINE CLASS

IN-PERSON CLASS

In-person course length: 2 days

Class prerequisites: Advanced ECL (Part 1)

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

Applied ECL: ECL Code Generation Tools

This class is for developers who want to extend their knowledge of ECL to use the ECL code generation tools to automate operational tasks.

Topics include:

Creating and Using MACROs
ECL’s Template Language
Automating Processes

ONLINE CLASS

IN-PERSON CLASS

In-person course length: 2 days

Class prerequisites: Advanced ECL (Part 1)

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.

Topics include:

Defining and Creating INDEXes
Using FETCH
Creating ROXIE Queries (STORED)
Testing Queries in Thor
Deploying to ROXIE
Payload Indexes
Full and Half-Keyed JOINs
Optimizing Queries (LIMIT, ATMOST, KEEP)

ONLINE CLASS

IN-PERSON CLASS

In-person course length: 2 days

Class prerequisites: All courses in ETL Developers Track

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)
Designing Queries Using Multiple Datasets
Case Insensitive Searches
Use of Superkeys in ROXIE Queries
Use of Package Maps for Query Organization
ROXIE-Specific Functions (PRELOAD, ALLNODES, etc.)
ROXIE Post Filtering

ONLINE CLASS

IN-PERSON CLASS

In-person course length: 2 days

Class prerequisites: ROXIE ECL (Part 1)

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

Applied ECL: Special Projects

This class helps developers level up their skills from Student ECL Coder to Journeyman ECL Coder through a supervised real-world project.

Topics include:

One real-world project proposed by the student(s) and agreed to by the Instructor.
Mentoring at every step, with guidance from project planning through completion.
Regularly scheduled remote (Lync/Webex) meetings.
Code Review
Progress Evaluation

In-person course length: 2 days

Class prerequisites: All courses in ROXIE Query Developers Track

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

Introduction to HPCC Systems Administration: Thor Clusters

This class is for system administrators who will be maintaining Thor environments.

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)
Configuration and Maintenance of Thor Systems
Troubleshooting

ONLINE CLASS

IN-PERSON CLASS

In-person course length: 3 days

Class prerequisites: None

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

Advanced HPCC Systems Administration: ROXIE Clusters

This class is for system administrators who will be maintaining ROXIE environments.

Topics include:

Configuration of ROXIE Systems
Maintenance of ROXIE Systems
Troubleshooting

ONLINE CLASS

IN-PERSON CLASS

In-person course length: 2 days

Class prerequisites: Introduction to HPCC Systems Administration: Thor Clusters

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

Onsite training

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 training@hpccsystems.com.

Have questions about training?

Learn more about HPCC Systems

What people are saying about HPCC Systems

Search

Training

Onsite training

Have questions about training?

Learn more about HPCC Systems