This lab is focused on advanced query writing skills to solve real world problems. Few of the real-world problems includes Gaps and Islands problem. In the first exercise, we will learn to find the gaps in a sequence of data using subqueries, ranking functions and also finds the performance differences between all the approaches. In the second exercise, we will learn to find the islands in a sequence of data using ranking functions, subqueries and group identifier method and also finds the performance differences between all the approaches. In the third and final exercise, we will learn to implement dynamic sorting which enables end users to sort the results as per their wish.

Subscribe to Download


Version1.0
Download4
File Size1.00 MB
Create DateApril 7, 2017
Last UpdatedApril 7, 2017
Implementing Linear Regression with Azure ML Studio
Predicting DiamondRates with Azure ML