Introduction to StreamInsight

27th February 2013 - 28th February 2013

Who is it for?

This course is designed for BI professionals, analysts and database developers. No experience of real-time processing and analysis of data is necessary.

What you will learn

The course outline, in detail, is as follows:

Day 1

What is StreamInsight, what is Event Stream Processing and why would I use it?
Understanding the StreamInsight architecture and objects
StreamInsight Concepts
Streaming Data
Temporal Streams
Working with Time.
Working with Event Sources and Event Sinks.
Writing queries over Historic and Live data.
Projection
Filtering
Joins
Unions
Group and Apply
Time Stamp Modifications
User-Defined Functions
User-Defined Stream Operators
Using Event Windows

Day 2

Durability
Deploying StreamInsight applications
Debugging a StreamInsight Application
Labs: write analytical queries against a live/historic data source

Key Benefits

Upon completion of this course attendees will have a solid understanding of SQL Server StreamInsight. This course will start from the fundamentals and build rapidly enabling attendees to understand what StreamInsight is, to start to write their first queries and deploy their applications.

Cost: £Ł499 to Dec 31 2012, Ł549 from 1 Jan 2013 +VAT

Trainer

A SQL Server MVP since 2004, Allan Mitchell is a very active member of the SQL Community, he presents regularly around the world and is a member of the SQLBits organising committee. He has helped author books on SSIS and is passionate about data quality and data integration using products such as SSIS, DQS and StreamInsight.

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee. No refunds will be given to registrants who cancel less than 1 week before the beginning of the course or who fail to attend. Substitutions for paid registrants may be made at any time. However, written notice is required and for complete accuracy must include all pertinent changes for the substituting attendee.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.

Calvin Ferns

Consultant, Adatis

Chris has an incredible ability to explain even the most complex logic of Analysis Services and MDX in an easy and funny way. He is one of the best Microsoft Business Intelligence trainers I've ever met.