课程: SQL Server Machine Learning Services: Python

Analyze SQL Server data with Python

课程: SQL Server Machine Learning Services: Python

开始一个月试用 购买团队方案

Analyze SQL Server data with Python

“

- [Adam] Python is a very popular programming language that's commonly used in data science. But until recently, it was cumbersome to use with data stored in a SQL server database. A copy of that data would need to be exported outside of the security and protection of the database engine in order to process it with Python. And that added complexity and time to any analysis that a data scientist wanted to perform. That all changed when Microsoft introduced machine learning services, which paved the way for running Python scripts right inside of the same server environment where the data was already stored. Hi, my name is Adam Wilbert and I've been introducing people to databases and the world of data analysis for well over a decade. I'd love to show you how to leverage the power and flexibility of Python scripting in SQL server. I'll demonstrate how to enable code execution, output status messages and import data into a script using standard T-SQL queries. Then, after processing the data, you'll see how to export the results back to a valid SQL server result set and complete the analysis loop all in a single platform using the database management tools that you already know. So join me in my LinkedIn learning course to see how to process data quickly and securely using Python in SQL server.

内容