Pull and Push Data to SQL Server using Python

Following on from our similar PowerShell video, this gives a quick guide as to how we can pull data from and push data to a SQL Server using Python. Specifically we'll use Pandas data frames and pyodbc to achieve this. It seems a little complicated, but it's actually not too bad when you realise the code is "copy and paste-able".

We'll do this in Visual Studio code to highlight the Development flows you can achieve in the product when using multiple tabs and languages within the same overarching 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 and other areas.

Please don't forget to Like and Subscribe.