SQL Server Machine Learning Services: Python

Learn how to analyze SQL Server data with Python. Database expert Adam Wilbert shows how to use a powerful combination of tools, including high-performance Python libraries and the Machine Learning Services add-on, directly inside SQL Server to streamline analysis. Adam shows how to use Python scripts to perform statistical analysis, generate graphics such as scatterplots and bar charts, and process tabular data. He also explains how to turn a Python script into a stored procedure and set up standalone ML services to execute scripts without impacting SQL Server performance.

Topics include:

• Analyzing SQL Server data with Python
• Installing Machine Learning Services
• Writing Python scripts for SQL Server
• Python packages and libraries
• Producing graphics with Matplotlib
• Processing tabular data
• Creating a SQL stored procedure
• Creating an external data science client

About the Author

Adam Wilbert is a data visualization expert who helps clients get better insights from their data.

As a consultant and trainer, Adam has spent over 5 years helping government, enterprise, and nonprofit clients use Access and Excel efficiently. Adam has developed Access databases for National Park Service managers and U.S. Geological Survey scientists, in addition to leading Access and Excel workshops throughout the United States through a partnership with Northwest Environmental Training Center. His in-depth multi-day training events benefit private firms such as Boeing and Verizon, NGOs, and government employees in agencies such as the Environmental Protection Agency, Bureau of Land Management, and the Army Corps of Engineers.

As the founder of CartoGaia, a cartography firm, Adam produces publication quality mapping products to explore awareness in the spatial arrangement of data in order to help guide policy and decision makers in a wide variety of environmental and business applications. He was chosen as a featured contributor to the inaugural edition of the North American Cartographic Information Society’s Atlas of Design.

Product Details

• Full Video Tutorials
• Video File Format: MP4
• Skill Level: Advanced
• Video Duration: 2h 28m
• Instructor: Adam Wilbert