Тёмный

How to connect SQL with Python [Read and Write] 

Yiannis Pitsillides
Подписаться 26 тыс.
Просмотров 27 тыс.
50% 1

Learn how to pull data from SQL into Python and automate your scripts. First, we go through how to automate your data import from CSV to SQL. Then, we explain how to create a connection between SQL and Python. Then we pull in data from a table. Afterwards, we run a machine learning model and we save the results back in SQL. Hope you enjoy this video!
Support the channel on Patreon:
/ data360yp
Data Analytics Course Link:
ipidata.teachab...
Overview:
• How to connect SQL with Python
• How to read data into Python from SQL
• How to send data from SQL to Python
• How to write data from Python to SQL
• How to save my Python dataframe to an SQL table
• How to connect SQL with Jupyter Notebook
Excel - SQL - Python Files:
github.com/Pit...
Excel to SQL Store procedure:
• • How to Automate Excel ...
Power BI Tutorial Links:
• • How to build a Power B...
Power BI Dashboard creation:
• • COVID 19 Trends & Fore...
• • How to Deploy a Machin...
• • Building a Power BI Da...
SQL Tutorial Links:
a. • SQL Tutorial for Begin...
b. • SQL Tutorial for Data ...
c. • How to Join Tables in ...
SQL most common queries:
• SQL Examples For Pract...
Yiannis Pitsillides on Social Media:
/ pitsillides91
www.instagram....
www.pinterest....
/ 1500092413449073

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 19   
@andreasp.189
@andreasp.189 3 года назад
Excellent brief and concise video. Keep it up Yiannis!
@YiannisPi
@YiannisPi 3 года назад
Much appreciated!
@tomjohnas134
@tomjohnas134 3 года назад
Thanks for the video Yiannis!
@ethan2104
@ethan2104 2 года назад
Easy to follow. Ty for sharing :)
@chrysis7989
@chrysis7989 3 года назад
really helpful! nice explanations!
@YiannisPi
@YiannisPi 3 года назад
Glad to hear that!
@olsay
@olsay 3 года назад
Appreciate your sharing
@YiannisPi
@YiannisPi 3 года назад
Do you follow a different process? Please let me know in the comments below! Thanks!
@DocentStalker
@DocentStalker 2 года назад
nice video, thank you
@BlessedNumbers
@BlessedNumbers 2 года назад
Hello Sir, Why you are not making any videos, it was so great and helpful
@marclukombo2
@marclukombo2 Месяц назад
I have two tables in SQL server : sales and products. I want to insert the product key into the sales table via the combobox using the python. How to do it?
@muhammadnauman3048
@muhammadnauman3048 3 года назад
Great vid
@trailbleza
@trailbleza 3 года назад
Great videos
@khalidaafghan6358
@khalidaafghan6358 3 года назад
thank you so much sir
@YiannisPi
@YiannisPi 3 года назад
Most welcome
@sreejx
@sreejx 3 года назад
kindly make a video on explaining the models used in this tutorial
@YiannisPi
@YiannisPi 3 года назад
I just did! It's in the new series - Time Series Models
@zainab-wl3fi
@zainab-wl3fi 2 года назад
i competed my application and i want to know how i can send my desktop application with his mysql data to another Computer what i should do?
@bhaskarsubbaiah8058
@bhaskarsubbaiah8058 2 года назад
Please do some analysis
Далее
Women’s Celebrations + Men’s 😮‍💨
00:20
Просмотров 3,8 млн
How to Use SQL with Excel using Python
16:52
Просмотров 122 тыс.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Просмотров 198 тыс.
Solving real world data science tasks with Python Pandas!
1:26:07
SQL Databases with Pandas and Python - A Complete Guide
16:59
How to Use PYODBC With SQL Servers in Python
15:56
Просмотров 104 тыс.