Working with Python on Windows and SQL Server Databases

Learn how you can efficiently work with SQL Server databases, via the Python Programming Language

Created by: Artemakis Artemiou
Award-Winning Database & AI Expert, Trainer, Author, Speaker

What Will I Learn?

• How to access and work with SQL Server databases from within your Python programs
• How to run T-SQL queries against your SQL Server databases from within your Python programs
• How to Call Dynamic Management Views (DMVs), Aggregation Functions and global system variables
• How to execute SQL Server functions and stored procedures from within your Python programs
• How to use parameters and exception handling in all database operations in your Python code
• How to set up your Python development environment on Windows
• How to work with Visual Studio Code for Python development

Requirements

• Basic knowledge of the Python programming language
• Basic knowledge of SQL Server fundamentals

Target audience

• Python developers who want to learn how to work with SQL Server via their Python programs
• Data Scientists who want to learn more about SQL Server database access via Python programming
• Technology enthusiasts who want to learn more about Python programming and SQL Server database access
• Programmers who want to get started with Python programming focused on data access topics