Advanced Python: Practical Database Examples

Course details

Looking for a hands-on opportunity to take your Python skills to the next level? In this course, instructor Kathryn Hodge takes you through a series of practical database examples to help level up your Python applications.

Learn how to create an API that serves data from a database using FastAPI, Flask, MySQL, Postman, SQLAlchemy, endpoints, and more. Get proven tips on how to develop analysis applications with pandas, the high-performance Python library featuring robust and integrated built-in data structures. Test out your new coding skills as you go in the exercise challenges at the end of each section. By the end of this course, you’ll be ready to start building full-stack task list applications with Flask, a microframework designed uniquely for Python that lets you integrate data from a database directly to an app.

Concepts

Introduction

Use databases to level up your Python applications

Creating an API that Serves Data from a Database with FastAPI

What is an API
API frameworks in Python
Set up FastAPI in a Python application
Define a database schema
Create a MySQL database
Create an API contract
Build a POST endpoint with FastAPI
Call a new API using Postman
Add data to a database in Python using SQLAlchemy
Integrate a database with a FastAPI application
Challenge - Develop a GET endpoint with FastAPI and a DB
Solution - Develop a GET endpoint with FastAPI and a Database

Developing Analysis Applications with Pandas

Introduction to pandas
Set up pandas and Jupyter Notebook
Analyze data with pandas
Analyze data with Matplotlib
Connect to a DB using SQLAlchemy within Juypter Notebook
Visualize data using SQLAlchemy, pandas, and Matplotlib
Challenge - Ingest data and visualize it with Matplotlib
Solution - Ingest data and visualize it using Matplotlib

Building a Full-Stack Task List Application with Flask

Set up Flask in a Python application
Create a webpage with Flask
Build a landing page
Develop additional routes to enhance your application
Build a project tasks page
Create a Postgres database
Instantiate a Postgres table using Python
Connect a database to a Python Flask project
Integrate project data from a Database into Flask
Integrate task data from a database into a Flask app
Develop add functionality to add a project
Develop add functionality to add a task
Challenge - Develop delete functionality
Solution - Develop delete functionality

Conclusion

Continue building applications with databases

Advanced Python: Practical Database Examples

Authors

Kathryn Hodge