SQL Server remains one of the most popular data platforms on the planet. Many industries want to leverage popular predictive models using SQL Server and recent features, enhancements, and the power of the cloud have made this more accessible than ever. In this course, Predictive Analysis with SQL Server, you’ll learn how to prepare data for predictive analytics within SQL Server. First, you’ll see some of the most popular methods for predictive models, such as regressions and clustering, demonstrated with hands-on demos and code samples. Next, you’ll dig into analyzing the effectiveness of these queries. Finally, you’ll explore optimizing the SQL Server platform for these types of analytical workloads. By the end of this course, you’ll have the skills and knowledge of building a predictive model directly in SQL Server needed to leverage this platform to perform practical and effective analysis using real-world data.
Author Name: Russ Thomas
Author Description:
Currently an IT leader in Denver Colorado’s FinTech sector Russ has focused on database engineering, modelling, administration, and BI since 1997. Russ is a passionate trainer and community volunteer presenting regularly at tech events and local user groups around the US. In 2019 much of Russ’ focus turned to cloud based data lakes specifically on Google BigQuery, and the emerging world of large language models.

Table of Contents

• Course Overview
  1min
• Preparing SQL Server for Predictive Analytics
  16mins
• Practical Predictive Analytics with SQL Server
  13mins