Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Working with Python on Windows and SQL Server Databases

Name: Working with Python on Windows and SQL Server Databases
Rating: 4.4 (215 reviews)

Connect Python to SQL Server with pyodbc and learn CRUD, stored procedures, CSV imports, and database automation.

Created byArtemakis Artemiou

Last updated 10/2026

English

English [Auto],

What you'll learn

Connect a Python program to SQL Server using pyodbc.
Execute SELECT, INSERT, UPDATE, and DELETE statements from Python.
Use query parameters and handle exceptions in the demonstrated database operations.
Call SQL Server stored procedures and functions from Python.
Read database information through DMVs, aggregate functions, and system variables.
Follow a CSV-to-SQL Server import example.
Distinguish external Python database access from the separate SQL Server Machine Learning Services material.

Course content

12 sections • 70 lectures • 7h 3m total length

Introduction4:13
This is the introduction to the course. We will talk about how this course is structured and what will you learn by attending the course.
Let’s Talk About Python on Windows1:46
In this lecture, we will talk about Python on Windows, its requirements and the available installation options.
Python Integrated Development Environments (IDEs)1:32
In this lecture, we will talk about some of the Integrated Development Environments (IDEs) that support Python development.
This Course’s Demo Environment23:54
In this lecture, we will talk about the demo environment that will be used for the course’s examples and live demonstrations.
Section Recap1:33
This lecture, is a recap of what you have learned in this introductory section.
Introduction

Section Overview0:44
This lecture, is an overview of what you will learn in this section.
Installing Python on Windows4:53
In this lecture and live demonstration, we will talk about and install Python on our demo Windows environment.
Installing and Setting up the IDE to be Used in the Demos - Visual Studio Code4:59
In this lecture and live demonstration, we will install Visual Studio Code on Windows, along with installing the Python extension.
Writing, Compiling and Running Python Programs6:58
In this lecture and live demonstration, you will learn how to write, compile and run your first Python program in Visual Studio Code.
Basic Python Commands and Data Structures19:02
In the lecture and live demonstration, we will refresh our memory on the basic Python commands and data structures.
Section Recap1:01
This lecture, is a recap of what you have learned in this section.
Basic Python Knowledge

Section Overview1:32
This lecture, is an overview of what you will learn in this section.
About the pyodbc Module4:18
In this lecture and live demonstration, we will talk about the pyodbc module and we will also install it on our demo environment.
Setting up the Connection String5:31
In this lecture, we will talk about the different ways and options, for setting up a connection string for SQL Server data access, in your Python programs using pyodbc and the ODBC Driver for SQL Server.
Connecting to SQL Server6:34
In this lecture and live demonstration, you will learn about the procedure for connecting to SQL Server via a Python Program.
Exception Handling4:44
In this lecture and live demonstration, we will talk about exception handling and learn how to apply exception handling capabilities to your SQL Server data access code in Python.
Running a Simple SQL Server Query and Display the Results4:33
In this lecture and live demonstration, we will run our first SQL Server T-SQL query from within our Python program, and display the query results.
Common Pitfalls When Working with SQL Server from Python (New)4:20
Learn about common pitfalls you may encounter when working with SQL Server from Python and more importantly, how to avoid them.
Section Recap1:35
This lecture, is a recap of what you have learned in this section.
Basic Interaction with SQL Server

Section Overview1:12
This lecture, is an overview of what you will learn in this section.
Running SELECT T-SQL Statements6:20
In this lecture and live demonstration, you will learn how to execute SQL Server SELECT T-SQL statements from within your Python programs. Moreover, you will learn how to use parameters for this type of queries.
Running INSERT T-SQL Statements8:12
In this lecture and live demonstration, you will learn how to execute SQL Server INSERT T-SQL statements from within your Python programs. Moreover, you will learn how to use parameters for this type of queries.
Running UPDATE T-SQL Statements6:17
In this lecture and live demonstration, you will learn how to execute SQL Server UPDATE T-SQL statements from within your Python programs. Moreover, you will learn how to use parameters for this type of queries.
Running DELETE T-SQL Statements5:51
In this lecture and live demonstration, you will learn how to execute SQL Server DELETE T-SQL statements from within your Python programs. Moreover, you will learn how to use parameters for this type of queries.
Running Other SQL Server T-SQL Statements7:58
In this lecture and live demonstration, you will learn how to run other SQL Server T-SQL statements from within your Python programs, such as aggregations and DMVs, along with calling SQL Server system global variables.
Section Recap1:54
This lecture, is a recap of what you have learned in this section.
Running SQL Server Queries from within a Python Program

Section Overview1:01
This lecture, is an overview of what you will learn in this section.
Let’s Create a SQL Server Stored Procedure from within a Python Program6:26
In this lecture and live demonstration, you will learn how to create SQL Server Stored Procedures from within your Python Programs.
Let’s Execute the Stored Procedure and Get the Results5:16
In this lecture and live demonstration, you will learn how to execute SQL Server Stored Procedures from within your Python Programs and get the results.
Executing Stored Procedures that do not Return a Result8:30
In this lecture and live demonstration, you will learn how to execute SQL Server Stored Procedures from within your Python Programs that do not return a result.
Section Recap0:59
This lecture, is a recap of what you have learned in this section.
Working with SQL Server Stored Procedures

Section Overview0:45
This lecture, is an overview of what you will learn in this section.
Let’s Create a SQL Server Function from within a Python Program4:45
Let’s Create a SQL Server Function from within a Python Program
Let’s Execute the Function and Get the Results4:55
In this lecture and live demonstration, you will learn how to execute SQL Server Functions from within your Python Programs and get the results.
Calling SQL Server System Functions6:58
In this lecture and live demonstration, you will learn how to call SQL Server System Functions from within your Python Programs and get the results.
Section Recap1:04
This lecture, is a recap of what you have learned in this section.
Working with SQL Server Functions

About Advanced Topics1:13
This lecture, is an overview of what you will be learning in this section.
How to Import Data from a CSV File to SQL Server via a Python Program13:50
In this lecture and live demonstration, you will learn how to import data from a CSV file, directly to SQL Server via your Python program.
How to Convert a Python Script to a Windows Executable16:06
In this lecture and live demonstration, you will learn how you can convert your Python scripts, to Windows executables.
How to Create a Basic GUI Dialog in Python and Connect to SQL Server12:13
In this lecture and live demonstration, you will learn how to create a basic GUI dialog in Python using the tkinter interface, and how to connect your GUI program to SQL Server and retrieve data.
How to Run the SQL Server BULK INSERT Command from Within a Python Program2:27
In this lecture, we will see step by step, how we can run the SQL Server BULK INSERT command from within a Python Program.
How to Run Multiple .SQL Scripts from a Folder on SQL Server using Python and PS14:22
In this advanced topic, via a live demonstration, we see step by step, how we can run multiple .sql scripts from a folder, on SQL Server using PowerShell calls via our Python code.
Mastering Python & SQL Server: Best Practices1:45
In this lecture, we'll be discussing about some helpful best practices that can improve your learning process and help you become more skilled at combining Python with SQL Server for your data-driven applications.
Using LangChain with Microsoft Learn Docs MCP Server9:53
In this lecture, I’ll walk you through a demo implementation of how to use LangChain to connect to the Microsoft Learn Docs MCP server, discover available tools, and invoke a semantic documentation search.
Privileged Access Management (PAM) for SQL Server3:59
In this lecture, we'll explore Privileged Access Management, or PAM, in SQL Server. Privileged accounts, like sysadmin logins, are powerful but also pose the highest security risks if they’re misused or compromised. We'll look at common challenges, best practices to minimize and control privileged access, how to implement Just-in-Time access, and why auditing is essential.
Safe Retries for Python Data Imports (New)3:51
In this lecture, we discuss safe Retries for Python Data Imports. We will use a concrete example to understand the decision, work through the reasoning, and finish with a short knowledge check.

About Special Database Topics0:24
This lecture, is an overview of what you will be learning in this section.
SQL Server Installation Best Practices12:31
Via this lecture, you will learn more about the best practices for when installing SQL Server.
Exploring SQL Server Data Types2:22
In this session, I’ll be providing a conceptual overview of the main data types in SQL Server and discuss how they map to Python types. Even though, these mappings are automatically handled by relevant Python database libraries, this understanding is essential for writing effective Python applications that interact with SQL Server databases.
Benefits of Primary Keys in Database Tables5:36
In this lecture, we will be discussing about the benefits of primary keys in database tables.
Benefits of Using Stored Procedures in Databases4:07
In this lecture, we will be discussing about the benefits of using stored procedures in databases.
Useful T-SQL Scripts for SQL Development11:42
In this lecture, you will learn many useful T-SQL tips and tricks that will help you with SQL Server development.
How to Find the Version of a SQL Server Instance11:14
Via this lecture and live demonstration, you will learn how to easily retrieve version information about your SQL Server instances.
What are T-SQL Snippets in SSMS?5:34
Via this lecture and live demonstration, you will learn all about T-SQL snippets in SSMS.
Operating Systems Supported by SQL Server3:49
In this lecture, we will be discussing about the different Operating Systems supported by SQL Server.
How to Install SQL Server 2019 Express and the Latest SSMS Version38:54
In this lecture and live demo, we will talk about SQL Server Express Edition, its characteristics and limitations, and how you can download it and install it on a new Windows environment, along with installing the latest version of SQL Server Management Studio (SSMS).
Overview of Index Types and Uses in SQL Server2:30
In this lecture, we’ll review the fundamentals of clustered and non-clustered indexes, then explore specialized types like columnstore, filtered, and full-text indexes.
SQL Server Authentication Modes (New)6:01
In this lecture, we'll be discussing about SQL Server authentication modes, that is the available ways of getting authenticated when accessing SQL Server.

Overview0:32
This lecture, is an overview of what you will be learning in this section.
What are SQL Server Machine Learning Services?2:54
In this lecture, we will be discussing about SQL Server Machine Learning Services, as this feature allows you to run Python (and R) scripts in SQL Server in-database.
How to Install SQL Server Machine Learning Services14:59
In this lecture and demo, we will be installing SQL Server Machine Learning Services, as part of performing a new installation of SQL Server.
Python and R Packages Included in SQL Server Machine Learning Services5:05
In this lecture, we will be discussing about the Python and R Packages included in SQL Server Machine Learning Services.
Executing Python Scripts via SQL Server Machine Learning Services7:09
In this lecture and live demonstration, you will learn how to execute Python scripts directly in SQL Server, via SQL Server Machine Learning Services.
Exploratory Data Analysis (EDA) with Python3:35
In this lecture, we'll explore how Exploratory Data Analysis (EDA) can help you uncover valuable insights in your data using Python's powerful libraries.
A Practical Guide to the Layers of Artificial Intelligence2:56
In this lecture, we'll be discussing about the different layers of Artificial Intelligence, their main characteristics, and why is important to identify them.
The Evolution of Collaborative Intelligence6:58
In this lecture, we’ll trace the evolution of Collaborative Intelligence — from static, rule-based tools to dynamic, self-improving human–AI ecosystems.
Python and SQL Server Machine Learning Services

Choosing the Right Execution Layer: SQL Server vs Python2:28
This lecture helps you understand where logic should be executed in a system. The goal is not to favor a tool, but to make correct architectural decisions that improve performance, simplicity, and reliability.
Data Movement Patterns: Batch vs Streaming2:11
In this lecture, we discuss about how data moves within systems and how to choose the right pattern. The goal is to avoid unnecessary complexity while meeting business requirements.

Requirements

Basic Python programming knowledge and SQL Server fundamentals are required.
A Windows learning environment with Python, pyodbc, and a compatible SQL Server ODBC driver is needed for hands-on practice.
Use a non-production SQL Server database and the permissions needed for the examples. Machine Learning Services examples have separate feature and setup requirements.

Description

Learn how to connect Python applications to Microsoft SQL Server and perform practical database operations directly from your code.

This focused course shows you how Python and SQL Server can work together in real database-development scenarios.

You will learn how to establish database connections, execute SQL statements, work with parameters, handle errors, call stored procedures and functions, import data, and interact with SQL Server system information using Python.

If you already understand the basics of Python and SQL Server and want to bring the two technologies together, this course gives you a practical path forward.

Connect Python to SQL Server

The course begins by preparing the Windows development environment and reviewing the Python concepts needed for the database examples.

You will then learn how to connect Python to SQL Server using pyodbc and understand the main components involved in establishing and managing a database connection.

From there, you will move into the database operations that appear frequently in applications, scripts, automation tasks, and data-processing workflows.

Topics include:

Connecting Python to SQL Server with pyodbc.
Executing SQL statements from Python.
Retrieving data with SELECT queries.
Inserting new records.
Updating existing data.
Deleting records.
Working with parameters.
Handling database exceptions.
Executing stored procedures.
Working with SQL Server functions.
Retrieving SQL Server system information.
Importing CSV data into SQL Server.

Perform CRUD Operations with Python

One of the most useful skills when integrating Python with a relational database is understanding how to perform the core database operations commonly known as CRUD:

Create data.
Read data.
Update data.
Delete data.

You will see how Python code can execute these SQL Server operations and process the results returned by the database.

The examples help you understand the complete flow from Python code to SQL Server and back again.

Write Safer and More Reliable Database Code

Database access involves more than simply sending SQL statements.

You will also explore important development concepts such as parameterized queries and exception handling.

These topics help you understand how to write Python database code that is more structured, maintainable, and suitable for real applications and automation scripts.

Work with Stored Procedures and SQL Server Features

The course goes beyond basic SQL statements and shows how Python can interact with additional SQL Server functionality.

You will explore examples involving:

Stored procedures.
SQL Server functions.
Aggregate functions.
Dynamic Management Views.
SQL Server system variables.

These examples demonstrate that Python can be used not only for application data access, but also for administrative, monitoring, and data-processing scenarios.

Import Data from CSV Files

A practical CSV import example demonstrates how Python can be used as a bridge between external data and SQL Server.

This type of workflow is common in:

Data integration.
Automation.
ETL-style processing.
Reporting preparation.
Database utilities.

The example helps connect the individual Python and SQL Server concepts with a practical data-processing task.

Explore Python Inside SQL Server

The course also introduces SQL Server Machine Learning Services and the concept of executing Python code from within SQL Server.

This is different from a Python application connecting externally to SQL Server through pyodbc.

Understanding both approaches gives you a broader view of how Python can participate in SQL Server solutions and helps you distinguish between external database access and server-side Python execution.

Who Is This Course For?

This course is suitable for:

Python developers who want to work with SQL Server.
SQL Server professionals who want to start using Python.
Database developers.
Data engineers and data professionals.
Automation engineers.
Developers building database-driven Python applications.
IT professionals interested in integrating Python with Microsoft data technologies.

Basic knowledge of Python and SQL Server is recommended.

The course includes a Python refresher, but it is not intended to be a complete introduction to Python programming or relational database concepts.

About the Learning Environment

The demonstrations use a Windows-based development environment.

If you reproduce the examples, use a test SQL Server database, an appropriate ODBC driver, and permissions suitable for the operations you want to perform.

Some installation screens and software interfaces may differ in newer versions, but the core concepts behind Python-to-SQL Server connectivity and database operations remain applicable.

The SQL Server Machine Learning Services examples have additional installation and configuration requirements and are presented as a separate integration approach.

Build Practical Python and SQL Server Skills

By the end of the course, you will understand how Python applications can connect to SQL Server, execute queries and data-modification statements, work with stored procedures and SQL Server features, handle database errors, and process data programmatically.

Most importantly, you will have a practical foundation for using Python as a development, automation, and data-processing tool with SQL Server.

If you already know the basics of Python and SQL Server and want to connect the two technologies in practical scenarios, this course provides a focused place to start.

Who this course is for:

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
Data practitioners who want practical database-access examples on Windows.
Database professionals who already know basic Python and want to connect it to SQL Server.

Working with Python on Windows and SQL Server Databases

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 33min

Basic Python Knowledge6 lectures • 38min

Basic Interaction with SQL Server (Updated)8 lectures • 33min

Running SQL Server Queries from within a Python Program7 lectures • 38min

Working with SQL Server Stored Procedures5 lectures • 22min

Working with SQL Server Functions5 lectures • 18min

Advanced Topics (Updated)10 lectures • 1hr 20min

Special Database Development Topics (Updated)12 lectures • 1hr 45min

Python and SQL Server Machine Learning Services (Updated)8 lectures • 44min

Strategic Decision Frameworks (Enterprise Level) - New2 lectures • 5min

Requirements

Description

Who this course is for: