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
На этой странице сайта вы можете посмотреть видео онлайн Pull and Push Data to SQL Server using Python длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Kutech Solutions Ltd 07 Апрель 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 548 раз и оно понравилось 12 зрителям. Приятного просмотра!