Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server Machine Learning Services: Python

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Learn how to analyze SQL Server data with Python. Discover how to perform statistical analyses, generate graphics, and process tabular data—directly in SQL Server.

Syllabus

Introduction
  • Analyze SQL Server data with Python
  • What you should know
  • Using the exercise files
1. Get Started with MLS
  • What is machine learning services?
  • Install ML services for Python
  • Enable script execution in SQL Server
  • Use variables in Python
  • Create a Python while loop
2. Write Python Scripts for SQL Server
  • Import a dataset from SQL Server
  • Manipulate a data frame
  • Output a result set to SQL Server
  • Python syntax pitfalls
  • Challenge: Import a data frame
  • Solution: Import a data frame
3. Python Package Modules and Libraries
  • The Anaconda open-source packages
  • Functions in the revoscalepy package
  • Model, train, and score with microsoftml
  • Produce graphics with MatPlotLib
  • Get descriptive statistics with pandas
  • Challenge: Sample a data frame
  • Solution: Sample a data frame
4. Processing Tabular Data
  • Return values with indexes and series
  • Convert a series to a data frame
  • Add multiple series to a data frame
  • Include the index in a data frame
  • Slice a data frame to series
  • Challenge: Import and process data
  • Solution: Import and process data
5. Create a SQL Stored Procedure
  • Create a Python stored procedure
  • Parameterize the procedure
  • Challenge: Write a stored procedure
  • Solution: Write a stored procedure
6. Create an External Data Science Client
  • Install MLS on a standalone server
  • Add development tools to the client
  • Work with Jupyter Notebooks
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.7 rating at LinkedIn Learning based on 381 ratings

Start your review of SQL Server Machine Learning Services: Python

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.