Store Python Models in SQL Server for your ETL Processing скачать в хорошем качестве

Store Python Models in SQL Server for your ETL Processing

In this video we'll show how you can generate a very basic Machine Learning Model in Python, then store that model in SQL Server so that we can call on it and use it as part of an ETL process. First we generate a model using pure Python, then we migrate that into SQL Server's sp_execute_external_script procedure. From here we can export the generated Python Model into a SQL Server table. Once stored, we can use that Model to process data within our ETL in order to classify data prior to making the data live, allowing us to better clean and normalise our data within the ETL process. Check out our other videos as well, we cover basic PowerShell and Docker alongside our SQL Server based content and we're hoping to expand out further into Power BI, Python, R and other areas. Please don't forget to Like and Subscribe. I'll make sure I put all code onto the company blog so that everything in the video can be reproduced. Kutech.co.uk - Our one stop SQL shop for Training, Consultancy, and Remote DBA and Support Services