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
Auf dieser Seite können Sie das Online-Video Level UP Database Python (Full Course) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer CodeTekTeach 03 Februar 2025 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 971 Mal angesehen und es wurde von 38 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
