fbpxl
Instructor-Led Online | 1 Day Classroom | Private Onsite

Python for SQL Server Specialists

Although R is the most popular environment and language for statistical analyses, data mining, and machine learning, Python as a more general language might be even 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.

Upcoming Dates

Public dates tbd
Please contact us for a private class!

Course Delivery Options

1d onsite | 8h online

Description

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.

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 and Visual Studio. 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 to more advanced data mining and machine learning analyses.

Outline

1. Introduction to Python

2. Data overview and manipulation

3. Basic and advanced visualizations

4. Data mining and machine learning methods

5. Scalable Python in SQL Server

Author and Instructor

Dejan Sarka

Dejan Sarka focuses on development of database & business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of numerous books about databases and SQL Server (among these Training Kits for Microsoft Exams 70-461 and 70-463). Dejan Sarka also developed serveral courses for SolidQ. As an MCT, Dejan Sarka speaks on many local and international events. Some of the international events include conferences such as PASS, TechEd, and DevWeek.

Contact us
Do you want more info about these courses?
  • By submitting this information, you acknowledge that you have read the Privacy Policy and that you consent to our data processing in accordance with this Statement.
  • This field is for validation purposes and should be left unchanged.

Invite & Earn

X
Signup to start sharing your link
Signup