Python for SQL Server Specialists


Python as a more general language is getting more and more popular. Lately, Python is more widely used for data science as well. SQL Server 2017 adds support for running Python code inside the Database Engine.

PDF Description

Duration: 8 hours

Labs: none, plain seminar

“Dejan Sarka knows what he is talking about!”



Python is more organized language than R. In last years, many data analytics libraries for Python evolved, and thus Python is catching up with R even in the data science area.

Microsoft added support for Python code in SQL Server in version 2017. Now you can use either R or Python inside the Database Engine for advanced tasks like predictive analytics. Therefore, you can use the language that suits you better. Statisticians and mathematicians might prefer R, while developers tend to be more Python oriented.

WHERE and WHEN will this course running?

In this course you will learn…

Attendees of this seminar learn to program with Python from the scratch. Basic Python code is introduced using the Python engine installed with SQL Server 2017 and Visual Studio 2017. The seminar shows some more advanced data manipulations, matrix calculations and statistical analysis together with graphing options. The mathematics behind is briefly explained as well. Then the seminar switches more advanced data mining and machine learning analyses.

Who is this courser for?

Database Developers, who want  to get more knowledge about Python

Pre Requirements: What do you need to know to complete the course?

Participants in this training should have knowledge in:

  • Notions of data analysis and database developing


All courses can be delivered privately and customized to meet the requirements of your company.

More information


Module 1: Introduction to Python
Module 2: Data Overview and Manipulation
Module 3: Basic and Advanced Visualizations
Module 4: Data Mining and Machine Learning Methods
Module 05: Scalable Python in SQL Server

WHEN and WHERE is this course running?

This course can be scheduled in more than one region. Please check availability in your country.

See Course Schedule