Advanced Python: Practical Database Examples

Introduction

• Use databases to level up your Python applications

1. 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

2. 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

3. 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