Using SQL in Python: How to Query Databases Using Python

This on-demand course provides a concise yet comprehensive overview of integrating Python with SQL. Software developers, data scientists, and data engineers who use Python will inevitably want their Python code to talk to a database. It’s hard to create a useful application without data backing it, right?

That’s where integrating Python with SQL comes in. Python can compose SQL queries to send to a database regardless of if it is using PostgreSQL, Microsoft SQL Server, Oracle, or MySQL. However, it has to be done right to avoid performance issues and security concerns like SQL injection.

This on-demand course provides a concise yet comprehensive overview of integrating Python with SQL. Through short presentations and demonstrations, you will learn how to use practical patterns for querying databases with Python’s built-in DB API, how to write data using transactions, inject parameters safely, pool connections, and manage concurrency. You will also learn how to use SQL in Pandas, Jupyter Notebooks, and ORM using SQLAlchemy.

What you’ll learn and how to apply it

• Run SQL queries from a Python environment
• Leverage transactions in Python for safe CRUD operations
• Understand best practices and common patterns, like connection pooling and parameter injection

This course is for you because

• You are a data scientist who wants to plug Python models directly into databases.
• You are a software engineer who wants to better control of Python applications backed by databases.
• You are a data engineer who wants to be more proficient at data pipelines using Python
• You are a SQL user who is curious how Python can augment your capabilities.

Prerequisites

• Basic proficiency in Python (variables, functions, loops, lists, tuples, dicts, conditional logic)
• Some experience in SQL is helpful but not required

Course Materials

• GitHub repository for the course