| title | Python tutorials |
|---|---|
| description | This article describes the Python tutorials 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. |
| 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 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.
| Quickstart | Description |
|---|---|
| Hello World in Python and SQL Server | Learn the basics of how to call Python in T-SQL. |
| Handle inputs and outputs using Python in SQL Server | Learn how to handle inputs and outputs for Python in sp_execute_external_script. |
| Python data structures in SQL Server | Shows how SQL Server uses the Python pandas package to handle data structures. |
| Train and use your first model | Explains how to create, train, and use a Python model to predict new data. |
| Link | Description |
|---|---|
| Quickstart: "Hello world" Python script in SQL Server | Learn the basics of how to call Python in T-SQL. |
| Quickstart: Create, train, and use a Python model with stored procedures in SQL Server | Explains the mechanics of embedding Python code in a stored procedure, providing inputs, and stored procedure execution. |
| Tutorial: Create a model using revoscalepy | Demonstrates how to run code from a remote Python terminal, using SQL Server compute context. You should be somewhat familiar with Python tools and environments. Sample code is provided that creates a model using rxLinMod, from the new revoscalepy library. |
| Tutorial: Learn in-Database Python analytics for SQL developers | This end-to-end walkthrough demonstrates the process of building a complete Python solution using T-SQL stored procedures. All Python code is included. |