HPCC Systems offers distinct HPCC training programs suitable for different roles within your organization. In addition we offer free training videos on several topics.

Onsite training at your location is also available for large groups. Minimum of 6 students is required. Maximum of 20 students. Price is based on per person plus travel expenses.

Contact Us for Pricing and More information

Introductory Training Classes

If you want to get on the fast track to becoming productive with ECL on the HPCC system, these classes are essential for all developers new to the ECL Language. Each course includes a series of hands-on exercises using concepts and language statements introduced during the class.

Introduction to HPCC for Managers

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.

Topics include:

• HPCC Overview (THOR and ROXIE)
• Introduction to ECL Concepts and Syntax
• Introduction to the ECL IDE and ECL Watch programming tools
• Creating Simple ECL Queries

This class is for Managers who want to understand the HPCC (High Performance Computing Cluster) system and see how ECL can build powerful data queries. Any manager who needs a basic familiarity with HPCC Systems should take this course.

Visit Training & Events for more information on dates and registration.

Introduction to ECL – Concepts and Queries

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 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

This class is for developers who want to understand the HPCC (High Performance Computing Cluster) system and learn ECL to build powerful data queries. Anyone who needs a basic familiarity with ECL should take this course.

Visit Training & Events for more information on dates and registration.

Introduction to THOR – the Extract, Transform and Load (ETL) Process

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL Training class. Students are welcome to bring their own laptops to take away the code and examples from the class.

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

This class is for developers who want to extend their knowledge of ECL to Extract, Transform, and Load (ETL) any data with the HPCC environment. Anyone planning to write and work with ECL code should attend this course.

Visit Training & Events for more information on dates and registration.

Introduction to ROXIE – Indexes and Queries

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL and Introduction to Thor Training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

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

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.

Visit Training & Events for more information on dates and registration.

Introduction to HPCC System Administration – THOR Clusters

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.

Topics include:

• HPCC 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 HPCC THOR Systems
• Troubleshooting

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

Visit Training & Events for more information on dates and registration.

Advanced Training Classes

The Advanced Training Classes are designed for the developer who has a specific need beyond the introductory courses. Each course includes a series of hands-on exercises using concepts and techniques introduced during the class. Each class stands alone, so they may be taken in any order.

Advanced ECL – Working with Relational Data

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL and Introduction to Thor 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

This class examines in detail the ECL functions that make it easy to work with Relational data in the HPCC system. 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.

Visit Training & Events for more information on dates and registration.

Advanced THOR – Super files, Working with XML, and Free-form Text Parsing

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL and Introduction to Thor Training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.

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

This course explores the concept of Super Files in ECL and the techniques for working with XML data, getting it into your HPCC systems 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.

Visit Training & Events for more information on dates and registration.

Advanced ROXIE - Complex Query Development

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL, Introduction to Thor, and Introduction to Roxie Training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

• ROXIE-specific functions (PRELOAD, ALLNODES, etc.)
• Complex Compound INDEXes (Phonetics, skipping based on cardinality)
• Relating to seeks and scans in the graph
• Non-blocking activities
• GROUP function
• In-memory datasets
• Post filtering

Learn how to optimize ROXIE queries for optimal performance.

Visit Training & Events for more information on dates and registration.

Advanced HPCC System Administration – ROXIE Clusters

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to HPCC System Administration Training class. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

• Configuration of HPCC ROXIE Systems
• Maintenance of HPCC ROXIE Systems
• Troubleshooting

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

Visit Training & Events for more information on dates and registration.

Applied Training Classes

The Applied Training Classes are designed for the developer who has a specific need in a targeted ECL specialty area. Each course includes a series of hands-on exercises using concepts and techniques introduced during the class. Each class stands alone, so they may be taken in any order.

Applied ECL – ECL Code Generation Tools

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL and Introduction to Thor Training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

• Creating and using MACROs
• ECL’s Template Language
• Automating Processes

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

Visit Training & Events for more information on dates and registration.

Onsite training at your location is also available for large groups. Minimum of 6 students is required. Maximum of 20 students. Price is based on per person plus travel expenses.

Contact Us for Pricing and More information