| title | Python tutorials |
|---|---|
| description | This article describes Python tutorials for SQL Server Machine Learning Services. Learn how to run scripts and build machine learning models in SQL Server. |
| ms.prod | sql |
| ms.technology | machine-learning |
| ms.date | 09/04/2019 |
| ms.topic | tutorial |
| author | dphansen |
| ms.author | davidph |
| monikerRange | >=sql-server-2017||>=sql-server-linux-ver15||=sqlallproducts-allversions |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
This article describes the Python tutorials and quickstarts for SQL Server Machine Learning Services.
- Learn how to run Python scripts.
- Build, train, and deploy Python models to SQL Server.
- Learn about remote and local compute contexts.
- Explore the Microsoft Python packages for data science and machine learning.
| Tutorial | Description |
|---|---|
| Predict ski rental with linear regression | Use Python and linear regression to predict the number of ski rentals. Use notebooks in Azure Data Studio for preparing data and training the model, and T-SQL for model deployment. |
| Categorizing customers using k-means clustering | Use Python to develop and deploy a K-Means clustering model to categorize customers. Use notebooks in Azure Data Studio for preparing data and training the model, and T-SQL for model deployment. |
| Create a model using revoscalepy | Demonstrates how to run code from a remote Python client using SQL Server as compute context. The tutorial creates a model using rxLinMod from the revoscalepy library. |
| Python data analytics for SQL developers | This end-to-end walkthrough demonstrates the process of building a complete Python solution using T-SQL. |
If you are new to SQL Server Machine Learning Services, you can also try the Python quickstarts.
| Quickstart | Description |
|---|---|
| Hello World in Python and SQL Server | Learn the basics of how to call Python in T-SQL using sp_execute_external_script. |
| Handle data types and objects using Python in SQL Server | Shows how SQL Server uses the Python pandas package to handle data structures. |
| Create and score a predictive model in Python | Explains how to create, train, and use a Python model to make predictions from new data. |