title | titleSuffix | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | monikerRange |
---|---|---|---|---|---|---|---|---|---|
Python tutorials |
SQL machine learning |
This article describes Python tutorials for SQL machine learning. Learn how to run scripts and build machine learning models. |
VanMSFT |
vanto |
05/21/2020 |
sql |
machine-learning |
tutorial |
>=sql-server-2017||>=sql-server-linux-ver15||=azuresqldb-mi-current |
[!INCLUDE SQL Server 2017 SQL MI]
::: moniker range=">=sql-server-ver15||>=sql-server-linux-ver15" This article describes the Python tutorials and quickstarts for Machine Learning Services on SQL Server and on Big Data Clusters. ::: moniker-end ::: moniker range="=sql-server-2017" This article describes the Python tutorials and quickstarts for SQL Server Machine Learning Services. ::: moniker-end ::: moniker range="=azuresqldb-mi-current" This article describes the Python tutorials and quickstarts for Azure SQL Managed Instance Machine Learning Services. ::: moniker-end
::: moniker range=">=sql-server-2017||>=sql-server-linux-ver15"
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. |
::: moniker-end | |
::: moniker range="=azuresqldb-mi-current" | |
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. |
::: moniker-end |
If you are new to SQL machine learning, you can also try the Python quickstarts.
Quickstart | Description |
---|---|
Run simple Python scripts | Learn the basics of how to call Python in T-SQL using sp_execute_external_script. |
Data structures and objects using Python | Shows how SQL 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. |