Database Programming with Pyodbc: Python Playbook
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.
Table of contents
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