By Andy Brown

Download files and exercises for this tutorial from https://www.wiseowl.co.uk/python/videos/python-programming/sql-server/

Learn how to use connections and cursors to get rows of data from SQL Server databases from within Python, how to commit insert, update or delete statements and how to execute stored procedures, passing parameters.

Chapters
00:00 Topic list
01:17 A Pandas warning
02:21 Our example database
03:24 Connecting to SQL Server
08:25 Fetching rows
14:25 Running action queries
21:53 Running stored procedures

Python playlist https://youtube.com/playlist?list=PLNIs-AWhQzckGrdnwITFlXGqiXTCAhWWi

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!