Advanced Python: Practical Database Examples

Focused View

Kathryn Hodge

1:48:48

149 View

01 - Introduction

01 - Use databases to level up your Python applications.mp4

01:12

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

01 - What is an API.mp4

02:45

02 - API frameworks in Python.mp4

01:29

03 - Set up FastAPI in a Python application.mp4

04:06

04 - Define a database schema.mp4

02:56

05 - Create a MySQL database.mp4

03:45

06 - Create an API contract.mp4

02:22

07 - Build a POST endpoint with FastAPI.mp4

02:27

08 - Call a new API using Postman.mp4

03:35

09 - Add data to a database in Python using SQLAlchemy.mp4

04:45

10 - Integrate a database with a FastAPI application.mp4

03:33

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

01:35

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

07:22

03 - 2. Developing Analysis Applications with Pandas

01 - Introduction to pandas.mp4

02:12

02 - Set up pandas and Jupyter Notebook.mp4

02:10

03 - Analyze data with pandas.mp4

03:30

04 - Analyze data with Matplotlib.mp4

01:29

05 - Connect to a DB using SQLAlchemy within Juypter Notebook.mp4

02:33

06 - Visualize data using SQLAlchemy, pandas, and Matplotlib.mp4

03:30

07 - Challenge Ingest data and visualize it with Matplotlib.mp4

01:07

08 - Solution Ingest data and visualize it using Matplotlib.mp4

04:09

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

01 - Set up Flask in a Python application.mp4

02:20

02 - Create a webpage with Flask.mp4

02:52

03 - Build a landing page.mp4

03:07

04 - Develop additional routes to enhance your application.mp4

04:56

05 - Build a project tasks page.mp4

02:16

06 - Create a Postgres database.mp4

02:01

07 - Instantiate a Postgres table using Python.mp4

03:43

08 - Connect a database to a Python Flask project.mp4

01:52

09 - Integrate project data from a Database into Flask.mp4

02:57

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

03:09

11 - Develop add functionality to add a project.mp4

05:07

12 - Develop add functionality to add a task.mp4

02:10

13 - Challenge Develop delete functionality.mp4

01:00

14 - Solution Develop delete functionality.mp4

07:13

05 - Conclusion

01 - Continue building applications with databases.mp4

01:33

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Database Programming

Kathryn Hodge

Instructor's Courses

Working at the interaction of media, education, and technology, I have around half a decade of experience as a small business owner and software engineer. As a small business owner, I've created the 30 Days of Code tutorial series with HackerRank, authored several popular technology courses with LinkedIn Learning, and amassed over 65,000 subscribers and 5 million lifetime views on the blondiebytes YouTube channel. As a software engineer, I've deconstructed a large Java Springboot monolith into microservices, automated deployment processes by building CI/CD pipelines, migrated complex infrastructure to AWS, and driven conversations around software engineering architectures and work culture in the tech industry. 30 Days of Code: https://www.hackerrank.com/domains/tutorials/30-days-of-code YouTube Channel: https://www.youtube.com/channel/UC4DwZ2VXM2KWtzHjVk9M_xg?view_as=subscriber LinkedIn Learning Courses: https://www.linkedin.com/learning/instructors/kathryn-hodge

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.