Advanced Python: Practical Database Examples

سرفصل های دوره

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.

01 - Introduction

01 - Use databases to level up your Python applications

02 - 1. Creating an API that Serves Data from a Database with FastAPI

01 - What is an API

02 - API frameworks in Python

03 - Set up FastAPI in a Python application

04 - Define a database schema

05 - Create a MySQL database

06 - Create an API contract

07 - Build a POST endpoint with FastAPI

08 - Call a new API using Postman

09 - Add data to a database in Python using SQLAlchemy

10 - Integrate a database with a FastAPI application

11 - Challenge Develop a GET endpoint with FastAPI and a DB

12 - Solution Develop a GET endpoint with FastAPI and a Database

03 - 2. Developing Analysis Applications with Pandas

01 - Introduction to pandas

02 - Set up pandas and Jupyter Notebook

03 - Analyze data with pandas

04 - Analyze data with Matplotlib

05 - Connect to a DB using SQLAlchemy within Juypter Notebook

06 - Visualize data using SQLAlchemy, pandas, and Matplotlib

07 - Challenge Ingest data and visualize it with Matplotlib

08 - Solution Ingest data and visualize it using Matplotlib

04 - 3. Building a Full-Stack Task List Application with Flask

01 - Set up Flask in a Python application

02 - Create a webpage with Flask

03 - Build a landing page

04 - Develop additional routes to enhance your application

05 - Build a project tasks page

06 - Create a Postgres database

07 - Instantiate a Postgres table using Python

08 - Connect a database to a Python Flask project

09 - Integrate project data from a Database into Flask

10 - Integrate task data from a database into a Flask app

11 - Develop add functionality to add a project

12 - Develop add functionality to add a task

13 - Challenge Develop delete functionality

14 - Solution Develop delete functionality

05 - Conclusion

01 - Continue building applications with databases

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)