RaqForum 25 No.
1 Reply  •  698 View  • 
     ...

Sample Program

 
Sample Program(31)

Contents

1. Data retrieval and analysis
2. Test data preparation
3. Pivot
4. Reverse pivot and sorting by the specified order
5. Inter-table join query
6. Precipitation data computation
7. Merge computation
8. Using cursor on large data sets
9. Cursor merge
10. Cumulative sum query
11. Cumulative count of continuous values
12. Intra-group operations and rankings
13. Text analysis using regular expression
14. Computations according to intervals
15. Displaying data in a dynamic number of column groups
16. Using JSON strings
17. Large join query
18. Text search
19. Password strength-related analysis
20. Handling big, multiline data using the cross-cellset cursor
21. Computing PI to 10000 decimal places
22. The simple use of graph plotting
23. Random mental arithmetic questions and auto paper-marking

Download exercise data

exercise-data.zip

Sample Program(31)
 
 •  698 View  •