Simple play icon Course
Skills Expanded

Database Programming with Pyodbc: Python Playbook

by Warner Chaves

Pyodbc brings Python and the ODBC standard together, a powerful combination for doing database development. This course covers what you need to develop your database code with Pyodbc and also understand what happens on the database side.

What you'll learn

Python is one of the world's most popular languages, ODBC one of the most popular database driver standards, and Pyodbc brings them together. In this course, Database Programming with Pyodbc: Python Playbook, you will learn foundational knowledge of database development using this popular Python module. First, you will learn how to execute queries and process results. Next, you will discover how to handle data type mismatches and managing transactions. Finally, you will explore the different error categories and how to handle them. When you’re finished with this course, you will have the skills and knowledge of Pyodbc development needed to boost your Python database development skills.

About the author

Warner is a SQL Server Certified Master, MVP, and Solutions Architect at Pythian, a global Canada-based company specializing in data and infrastructure services. A brief stint in .NET programming led to his early DBA formation, working for enterprise customers in Hewlett-Packard's ITO organization. From HP he transitioned to his current position at Pythian, managing multiple clients of different sizes and industries. He leads a highly-talented team of data professionals that keep things running ... more

Ready to upskill? Get started