High Performance Statistical Queries
SQL Server 2012 and 2014 Database Engine has so
many business intelligence improvements that it might become your primary
analytical database system. However, in order to get the maximum out of these
features, you need to learn how to properly use them. This in-depth session
shows some extremely efficient statistical queries that use the new Window
functions and are optimized through algorithms that use mathematical knowledge
and creativity. During the session, the formulas and usage of those statistical
procedures are explained as well. This session is useful not only for BI
developers; database and other developers can successfully learn how to write
efficient queries as well. Or maybe you want to learn how to become a data
scientist? Then you need to know statistics and programming. You get the best
of both in this session.
Sorry, there are no downloads available for this session.
Dejan Sarka, MCT and
SQL Server MVP, is an independent trainer and consultant that focuses on
development of database & business intelligence applications. Besides projects, he spends about half of the
time on training and mentoring. He is the founder of the Slovenian SQL Server
and .NET Users Group. Dejan Sarka is the main author or coauthor of twelve
books about databases and SQL Server. Dejan Sarka also developed many courses
and seminars for Microsoft, SolidQ and Pluralsight.
The video is not available to view online.