From the course: Azure Serverless Computing
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Stream Analytics query language - Azure Tutorial
From the course: Azure Serverless Computing
Stream Analytics query language
- [Instructor] Stream analytics uses a query language that's very SQL-like. It includes things like SELECT, FROM, WHERE, grouping by, as well as counting, average, DIFF, like different aggregation. If you are familiar with set calculus and writing good SQL queries, stream analytics is going to be a dream for you because it exposes out access to the data in a language that lets us do set calculus and work with a lot of the things that you're already familiar with. And it adds extensions so that we can actually look at the windowing and the data over time. So it supports the temporal grouping of events, what we call windowing. When you first look at the language, you'll notice that it looks a lot like SQL. For instance, if I have a stream of data from a tollbooth, I might be able to go out and select from the stream of data where the entry data is coming in, where the state is equal to a particular state, and then I can see just the cars that are coming from Connecticut. In that same…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.