Getting Started with Python on SQL Server

Python has recently become a favorite of data scientists because of its gentle learning curve and extensive data analysis and machine learning libraries. This course covers how to install, manage, and use Python on SQL Server for machine learning.
Course info
Rating
(16)
Level
Intermediate
Updated
Apr 18, 2018
Duration
1h 25m
Table of contents
Course Overview
Getting Started with SQL Server for Machine Learning
Running Python Programs in SQL Server
Performing Data Analytics with the revoscalepy Package
Using the microsoftml Library
Managing and Monitoring Python on SQL Server
Course Summary
Description
Course info
Rating
(16)
Level
Intermediate
Updated
Apr 18, 2018
Duration
1h 25m
Description

At the core of using Python for data analysis and machine learning in SQL Server is a thorough knowledge of how SQL Server implements external scripting, which includes Python programs. In this course, Getting Started with Python on SQL Server, you'll learn the fundamentals of SQL Server machine learning with a focus on Python. First, you’ll learn how to install SQL Server with support for machine learning in Python. Next, you’ll explore the three principle methods of harnessing this new power and how to run Python programs both in a database and on the desktop. Finally, you’ll discover how to secure, monitor, and manage the usage of Python on SQL Server. When you’re finished with this course, you’ll have a foundational knowledge that will help you as you move forward to use Python with SQL Server as a data scientist or monitor and manage it as a DBA.

About the author
About the author

Gerald is a multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater). 

More from the author
Managing SQL Server Database Concurrency
Intermediate
1h 45m
Jun 7, 2019
More courses by Gerald Britton
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi. I'm Gerald Britton, a Pluralsight author, SQL Server MVP, and longtime Pythonista. If you're interested in using Python with SQL Server, especially for data science and machine learning, this course is for you. If you're a DVA who needs to manage SQL Server instances that has Python installed, this course will get you up to speed. Python is consistently ranked among the top 5 programming languages in the world today. For data science and machine learning, it frequently holds the top spot. Recognizing its importance in this domain, Microsoft now includes Python in its SQL Server distribution, Understanding the implementation of Python support is key to using it properly and efficiently. Getting started with Python on SQL Server digs into how SQL Server implements Python support, while isolating it from other typical database activities. You will start off learning how to install this new functionality, and then move on to using Python, along with the included libraries, to learn how to analyze data sets, train and test data models, and produce charts and graphs. You will also see how to secure, monitor, and manage the activities on the server that are using Python and other external scripting languages. Finally, you'll discover great resources for further study so that you can get the most out of this new capability.