« Home

ROXIE ECL (Part 1) - Indexes and Queries - Atlanta

Monday, April 23, 2018, 8:00 PM

NOTE: RELX and LexisNexis employees should register using the approved promo code provided by their manager or contact training@hpccsystems.com. ROXIE ECL (Part 1) - Indexes and Queries Note: This course is the first in a two-part ROXIE series. People who attend the Roxie ECL (Part 1) – Indexes and Queries class, should also attend the Roxie ECL (Part 2) – Complex Query Development. Both classes are presented in the same week. 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. Course Length: 2 days Class Prerequisites: Students must have attended the Introduction to ECL (Part 1) - Concepts and Queries, the Introduction to ECL (Part 2) - the Extract, Transform, and Load (ETL) Process, and the Advanced ECL (Part 2) –  Super files, Working with XML, and Free-form Text Parsing 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) Class begins Monday at 1pm and concludes at 5pm. Class begins Tuesday at 9am and concludes at 5pm. Class begins Wednesday at 9am and concludes at 12pm.

Tickets: https://www.eventbrite.com/e/roxie-ecl-part-1-indexes-and-queries-atlanta-tickets-41392520142?aff=aff0eventful

Improve this event listing


1000 Alderman Drive
Alpharetta, GA 30005

View Map | Get Directions

More Event Ideas

Powered by Datasphere

Event data provided by Eventful

Free Coupons in Add Your Coupon to LocalSaver


What can we do for you?

Thank you for your input. Please fill out the form below and provide as much information as possible about updates to this event or venue.