Data File Processor

• Data File Processor

• Structured Text Computing with esProc

• Structured Text File Processing in SPL (II)

• CSV File Comparison

• An Easy Way to Merge and Summarize Excel Files

• Excel integrate esProc

• SPL parsing and exporting Excel

• XML data parsing and calculation

• JSON data calculation and importing into database

SQL Enhancer

• SQL Enhancer

• Overcome SQL Headaches – For Loop Operations

• Overcome SQL Headaches - For Set Operations and Getting Row Numbers

• Overcome SQL Headaches – For Special Cases

• Overcome SQL Headaches – For Record Reference

• Overcome SQL Headache - Intuitive Grouping

• Overcome SQL Headache – Generating a Sequence

• SPL Simplified SQL - Intra-group Computing

• SPL Simplified SQL - Calculate the first N rows of each group

• SPL Simplified SQL - Interline Computing

• SPL Simplified SQL - Multilevel Join

• SPL Simplified SQL - Multilayer Fixed Grouping

• SPL Simplified SQL Case Details - Grouping & Join

• Grouping Data by a Non-field Condition in SPL

• SPL Achieves Oracle Special Uses for MySQL

• SPL Achieves Window Function Functionality for MySQL

Course materials

• Crash SPL - Set

• Crash SPL - Order

• Crash SPL - Grouping

• Crash SPL - Join

• Crash SPL - Program

• Crash SPL - Cursor

• Complex logic - Transposition

• Complex logic - Recursion

• Complex logic - Alignment Grouping

• Complex logic - TopN and variants

• Complex logic - Grouped subsets

• Complex logic - JOINS

• Complex logic - Order related calculation