@sdw.online: REST API to SQL database: data project you can finish this weekend #dataanalytics #restapi #api #sql #excel #python #techtok

Stephen | Data Engineer
Stephen | Data Engineer
Open In TikTok:
Region: GB
Monday 06 May 2024 16:26:09 GMT
213427
11959
149
1009

Music

Download

Comments

goonner494
acx :
anyone done, can I have the GitHub link
2024-05-08 19:44:06
16
layaloxe
laya :
good project thank you, how would I make the SQL data live?
2024-05-07 18:27:15
0
camlme
Blackburn :
We can use Redis here ?
2024-05-10 03:48:56
0
abdul.majeed3711
Abdul Majeed :
It will be great you create a step by step video.
2024-05-06 16:35:13
74
lydiakgaugelo
Lee 🇿🇦🇳🇬 :
I'm now confused, I'm still busy with learning SQL n I guess this will apply after 3months 😄
2024-05-06 17:21:06
1
chrismottram590
chrismottram590 :
Map your json directly onto your sql schema to make it easier. That way you can pass json directly to SQL as a json table and you can UPDATE, SELECT, INSERT directly from the json table.
2024-05-08 07:58:09
14
adhasiv
Trintamin :
This can cause performance and data quality issue, first create a staging db to insert data from API, use indexes , functions , procedures to to ETL and create summarised data tables. Use python/
2024-05-08 20:30:23
0
irtazawani
Irtaza Hussain :
That SQL engineer who wrote that sql behind that api is 😩😢
2024-05-07 03:01:56
5
To see more videos from user @sdw.online, please go to the Tikwm homepage.

Other Videos


About