High Performance Statistical Queries
SQL Server 2012 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 proper algorithm. In 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.Finally, it is worth mentioning that the Data Scientist role is the big IT role in the 21st century. A data scientist should know statistics and programming. This session prepares you for that role.
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.