Advanced Python: Working with Databases

Focused View

Kathryn Hodge

2:06:50

216 View

01 - Introduction

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

00:50

02 - 1. Introduction to Databases in Python

01 - What is a database.mp4

02:14

02 - Relational databases.mp4

05:04

03 - Non-relational databases.mp4

04:15

04 - Python Database API.mp4

03:08

03 - 2. Using SQLite in Python

01 - What is SQLite.mp4

02:21

02 - Creating an SQLite database.mp4

03:44

03 - Inserting your first record into an SQLite database.mp4

02:33

04 - Adding multiple records at a time to an SQLite database.mp4

02:43

05 - Filtering records in an SQLite database.mp4

02:47

06 - What is SQLAlchemy.mp4

04:16

07 - Setting up a virtual environment for SQLAlchemy.mp4

02:03

08 - Executing a SQL query with SQLAlchemy.mp4

04:11

09 - Using the SQL expression language to write maintainable code.mp4

03:10

10 - Challenge Create an SQLite database.mp4

01:05

11 - Solution Create an SQLite database.mp4

06:33

04 - 3. Using MySQL in Python

01 - What is MySQL.mp4

04:26

02 - Creating a MySQL database.mp4

02:53

03 - Building tables in a MySQL database.mp4

02:25

04 - Adding data to a MySQL database.mp4

03:21

05 - Connecting a Python application to a MySQL database.mp4

04:24

06 - Encapsulating database operations.mp4

05:06

07 - Setting up MySQL in Python using SQLAlchemy.mp4

02:32

08 - Building a model with SQLAlchemy ORM.mp4

03:01

09 - Adding up a foreign key with SQLAlchemy ORM.mp4

02:48

10 - Using SQLAlchemy Sessions to transact on a MySQL database.mp4

03:51

11 - Retrieving data using SQLAlchemy ORM.mp4

02:21

12 - Challenge Create a MySQL database.mp4

01:20

13 - Solution Create a MySQL database.mp4

04:00

05 - 4. Using PostgreSQL in Python

01 - What is PostgreSQL.mp4

02:37

02 - Creating a PostgreSQL database.mp4

02:20

03 - Creating a table in Postgres using Python.mp4

02:17

04 - Inserting data into a Postgres database.mp4

02:06

05 - Interacting with a Postgres database using Python.mp4

03:40

06 - Setting up SQLAlchemy Core to connect to a Postgres database.mp4

02:51

07 - Manipulating with Postgres data using SQLAlchemy Core.mp4

02:50

08 - Setting up SQLAlchemy ORM to connect to a Postgres database.mp4

01:21

09 - Manipulating with Postgres data using SQLAlchemy ORM.mp4

02:51

10 - Challenge Create a Postgres database.mp4

02:07

11 - Solution Create a Postgres database.mp4

06:41

06 - Conclusion

01 - Continue using databases in Python applications.mp4

01:44

Description

To create functional and useful Python applications, you need a database. Databases allow you to store data from user sessions, track inventory, make recommendations, and more. However, Python is compatible with many options: SQLite, MySQL, and PostgreSQL, among others. Selecting the right database is a skill that advanced developers are expected to master. This course provides an excellent primer, comparing the different types of databases that can be connected through the Python Database API. Instructor Kathryn Hodge teaches the differences between SQLite, MySQL, and PostgreSQL and shows how to use the ORM tool SQLAlchemy to query a database. The final chapters put your knowledge to practical use in two hands-on projects: developing a full-stack application with Python, PostgreSQL, and Flask and creating a data analysis app with pandas and Jupyter Notebook. By the end, you should feel comfortable creating and using databases and be able to decide which Python database is right for you.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

MySQL

PostgreSQL

Database Programming

Flask Framework

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.