Advanced Python: Practical Database Examples

Advanced Python: Practical Database Examples

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 48m | 267 MB

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.

Table of Contents

1 Use databases to level up your Python applications

Creating an API that Serves Data from a Database with FastAPI
2 What is an API
3 API frameworks in Python
4 Set up FastAPI in a Python application
5 Define a database schema
6 Create a MySQL database
7 Create an API contract
8 Build a POST endpoint with FastAPI
9 Call a new API using Postman
10 Add data to a database in Python using SQLAlchemy
11 Integrate a database with a FastAPI application
12 Challenge Develop a GET endpoint with FastAPI and a DB
13 Solution Develop a GET endpoint with FastAPI and a Database

Developing Analysis Applications with Pandas
14 Introduction to pandas
15 Set up pandas and Jupyter Notebook
16 Analyze data with pandas
17 Analyze data with Matplotlib
18 Connect to a DB using SQLAlchemy within Juypter Notebook
19 Visualize data using SQLAlchemy, pandas, and Matplotlib
20 Challenge Ingest data and visualize it with Matplotlib
21 Solution Ingest data and visualize it using Matplotlib

Building a Full-Stack Task List Application with Flask
22 Set up Flask in a Python application
23 Create a webpage with Flask
24 Build a landing page
25 Develop additional routes to enhance your application
26 Build a project tasks page
27 Create a Postgres database
28 Instantiate a Postgres table using Python
29 Connect a database to a Python Flask project
30 Integrate project data from a Database into Flask
31 Integrate task data from a database into a Flask app
32 Develop add functionality to add a project
33 Develop add functionality to add a task
34 Challenge Develop delete functionality
35 Solution Develop delete functionality

36 Continue building applications with databases