Skip to content

sql-server-python-tutorials.md

Latest commit

 

History

History
48 lines (36 loc) · 2.68 KB

sql-server-python-tutorials.md

File metadata and controls

48 lines (36 loc) · 2.68 KB
title SQL Server Python tutorial overview - SQL Server Machine Learning
description Introduction to the Python tutorials for SQL Server in-database analytics.
ms.prod sql
ms.technology machine-learning
ms.date 12/18/2018
ms.topic tutorial
author HeidiSteen
ms.author heidist
manager cgronlun

SQL Server Python tutorials

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]

This article lists the Python tutorials for in-database analytics on SQL Server 2017.

  • Learn how to wrap and run Python code in stored procedures.
  • Serialize and save Python-based models to SQL Server databases.
  • Learn about remote and local compute contexts, and when to use them.
  • Explore the Microsoft Python modules for data science and machine learning tasks.

Python quickstarts and tutorials

Link Description
Running Python in T-SQL Learn the basics of how to call Python in T-SQL.
Train and score your first model Explains the mechanics of embedding Python code in a stored procedure, providing inputs, and stored procedure execution.
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.
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.

Code samples

These samples and demos provided by the SQL Server development team highlight ways that you can use embedded analytics in real-world applications.

Link Description
Build a predictive model using Python and SQL Server Learn how a ski rental business might use machine learning to predict future rentals, which helps the business plan and staff to meet future demand.
Perform customer clustering using Python and SQL Server Learn how to use the Kmeans algorithm to perform unsupervised clustering of customers.

See also