Connect to MySQL with Python, SQLAlchemy, Pandas and Heroku
Here is the project instructions and code:
https://4geeks.com/interactive-coding-tutorial/beginner/connecting-to-a-sql-database-project-tutorial
00:00 - Introduction
01:03 - What is SQL
05:10 - Practice SQL with SQLBolt
06:15 - Cloning the Github repository
07:20 - Creating the MySQL Database in Heroku.com
09:47 - Your database credentials
12:33 - Understanding the project template and basic structure
12:57 - PIP Python Package Manager
13:44 - Requirements.txt
14:50 - Dot Env File (Environment Variables)
18:33 - Running and testing the code for the first time
21:38 - Connecting to the database using SQL Alchemy
22:30 - Running your first SQL Statement to create a table
25:43 - Inserting data into the database
27:03 - Use pandas to select and retrieve data from the database
Видео Connect to MySQL with Python, SQLAlchemy, Pandas and Heroku канала 4Geeks Academy
https://4geeks.com/interactive-coding-tutorial/beginner/connecting-to-a-sql-database-project-tutorial
00:00 - Introduction
01:03 - What is SQL
05:10 - Practice SQL with SQLBolt
06:15 - Cloning the Github repository
07:20 - Creating the MySQL Database in Heroku.com
09:47 - Your database credentials
12:33 - Understanding the project template and basic structure
12:57 - PIP Python Package Manager
13:44 - Requirements.txt
14:50 - Dot Env File (Environment Variables)
18:33 - Running and testing the code for the first time
21:38 - Connecting to the database using SQL Alchemy
22:30 - Running your first SQL Statement to create a table
25:43 - Inserting data into the database
27:03 - Use pandas to select and retrieve data from the database
Видео Connect to MySQL with Python, SQLAlchemy, Pandas and Heroku канала 4Geeks Academy
Комментарии отсутствуют
Информация о видео
15 июня 2022 г. 6:12:22
00:31:18
Другие видео канала