Advanced Python: Working with Databases

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

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.

01 - Introduction

01 - Using databases to level up your Python applications

02 - 1. Introduction to Databases in Python

01 - What is a database

02 - Relational databases

03 - Non-relational databases

04 - Python Database API

03 - 2. Using SQLite in Python

01 - What is SQLite

02 - Creating an SQLite database

03 - Inserting your first record into an SQLite database

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

05 - Filtering records in an SQLite database

06 - What is SQLAlchemy

07 - Setting up a virtual environment for SQLAlchemy

08 - Executing a SQL query with SQLAlchemy

09 - Using the SQL expression language to write maintainable code

10 - Challenge Create an SQLite database

11 - Solution Create an SQLite database

04 - 3. Using MySQL in Python

01 - What is MySQL

02 - Creating a MySQL database

03 - Building tables in a MySQL database

04 - Adding data to a MySQL database

05 - Connecting a Python application to a MySQL database

06 - Encapsulating database operations

07 - Setting up MySQL in Python using SQLAlchemy

08 - Building a model with SQLAlchemy ORM

09 - Adding up a foreign key with SQLAlchemy ORM

10 - Using SQLAlchemy Sessions to transact on a MySQL database

11 - Retrieving data using SQLAlchemy ORM

12 - Challenge Create a MySQL database

13 - Solution Create a MySQL database

05 - 4. Using PostgreSQL in Python

01 - What is PostgreSQL

02 - Creating a PostgreSQL database

03 - Creating a table in Postgres using Python

04 - Inserting data into a Postgres database

05 - Interacting with a Postgres database using Python

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

07 - Manipulating with Postgres data using SQLAlchemy Core

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

09 - Manipulating with Postgres data using SQLAlchemy ORM

10 - Challenge Create a Postgres database

11 - Solution Create a Postgres database

06 - Conclusion

01 - Continue using databases in Python applications

179,000 تومان

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

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

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

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