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.
Kutech.co.uk - Our one stop SQL shop for Training, Consultancy, and Remote DBA and Support Services
Sur cette page du site, vous pouvez voir la vidéo en ligne Pull and Push Data to SQL Server using Python durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Kutech Solutions Ltd 07 avril 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 548 fois et il a aimé 12 téléspectateurs. Bon visionnage!
