Level UP Database Python (Full Course)
Database Level UP
--------
👉 Learn more courses : • PYTHON (Full Tutorial)
--
🕒 Timestamp:
====
0. Introduction\
0:00:00 - Using databases to level up your Python applications
0:01:36 - What you need to know
1. Introduction to Databases in Python\
0:03:21 - What is a database
0:05:59 - Relational databases
0:10:14 - Non-relational databases
0:14:41 - Python Database API
2. Using SQLite in Python\
0:17:48 - What is SQLite
0:20:03 - Creating an SQLite database
0:23:35 - Manipulating records in a SQLite database
0:30:55 - What is SQLAlchemy
0:34:52 - Setting up a virtual environment for SQLAlchemy
0:37:31 - Using SQLAlchemy Core with an SQLite database
0:47:08 - Challenge- Create an SQLite database
0:48:07 - Solution- Create an SQLite database
0:57:13 - What is MySQL
1:01:17 - Creating a MySQL database
1:05:15 - Building tables in a MySQL database
1:14:16 - Connecting a Python application to a MySQL database
1:20:52 - Encaspulating database operations to make better applications
1:30:32 - Developing Pythonic applications with SQLAlchemy ORM
1:39:46 - Using SQLAlchemy Sessions to transact on a MySQL database
1:46:54 - Using SQL to import CSV data
1:59:55 - Leveraging SQLAlchemy and pandas to import CSV data
2:07:14 - Challenge- Create a MySQL database
2:08:33 - Solution- Create a MySQL database
4. Using PostgreSQL in Python\
2:16:52 - What is PostgreSQL
2:19:15 - Creating a PostgreSQL database
2:24:08 - Creating a table in Postgres using Python
2:29:03 - Inserting data into a Postgres database
2:36:53 - Interacting with a Postgres database using Python
2:46:38 - Pythonic Postgres interactions with SQLAlchemy Core
2:56:06 - Pythonic Postgres interactions with SQLAlchemy ORM
3:03:57 - Grouping SQL statements with stored procedures
3:06:09 - Creating a stored procedure in PostgreSQL
3:12:55 - Using Postgres stored procedures and functions in Python
3:21:45 - Challenge- Create a Postgres database
3:23:57 - Solution- Create a Postgres database
5. Developing Full-Stack Applications\
3:36:17 - Setting up Flask in a Python application
3:38:36 - Creating a webpage with Flask
3:44:54 - Developing additional routes to enhance your application
3:53:14 - Instantiating a Postgres database using Python
3:58:26 - Connecting a database to a Pythonic Flask project
4:05:35 - Feeding data from a database into a Flask application
4:10:21 - Develop add functionality to a Flask application
4:19:05 - Challenge- Develop delete functionality
4:20:06 - Solution- Develop delete functionality
6. Developing Analysis Applications\
4:31:15 - Introduction to pandas
4:33:25 - Setting up pandas and Jupyter Notebook
4:35:43 - Analyzing data with pandas
4:41:27 - Integrating SQLAlchemy with pandas
Sur cette page du site, vous pouvez voir la vidéo en ligne Level UP Database Python (Full Course) durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur CodeTekTeach 03 février 2025, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 971 fois et il a aimé 38 téléspectateurs. Bon visionnage!
