SQL Machine Learning is a field of Artificial Intelligence or Computer Science which makes use of (data) models that improve their accuracy with time through experience somewhat similar to humans but with a lot more limitations. Machine learning is all about making machines learn independently (automatically with limitations) without any pre-programmed or hard-coded logic or instructions.
Table of contents
About Machine LearningWhat is Machine LearningSimple definitionWho works in this fieldAbout SQL Machine Learning (ML)Two modes of installationThree flavors (languages) of installationThree BenefitsUsing and running Python Code (SQL Machine Learning)SQL Machine Learning (ML) InstallationVerifying SQL Server Machine Language InstallationEnable External Scripts (sp_configure)Check the status of the external scriptTest Python CodePrint outGet System VersionUsing Variables in PythonSubtracting two numbers in PythonLoop in PythonSQL Machine Learning (ML) using PythonThe Role of InputDataSet variable from Query Output (results) to Python ProcessingSetting up the Sample databaseLoad data from SQL into Python (Import data into Python using T-SQL) – InputData1The importance of the Input_Data_1 property and InputDataSet variableManipulating the Python Data Frame (Processing/Manipulation)Finding integer location iloc of the data (pandas.DataFrame.iloc)Using the head function to manipulate the data frame (pandas.DataFrame.head)Export Data Frame (back to SQL)Export Manipulated data using OutputDataSet VariableExample: Finding the shape of the student tableConclusionSort: