Myvideo

Guest

Login

Run SQL queries in EXCEL (just like a normal Excel formula )

Uploaded By: Myvideo
34 views
0
0 votes
0

Did you know that you can use an SQL formula in Excel? Learn in this video how to run SQL queries in Excel. You don't have to be a programmer to be able to get the most out of SQL. In this video, you'll learn how to add the SQL formula to your Excel application. In particular, we will use the Python package xlwings and the xlwings Excel add-in. After setting everything up, I will walk you through some practical examples and share my tips and tricks for using SQL in Excel. 🌎 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦: Download the xlsx workbook: Xlwings documentation: ⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦: 00:00 – Intro 00:31 – Installing the dependencies 00:57 – First SQL Example 03:07 – More SQL sample queries 06:47 – Outro ◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️ 𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘: 🌎 Website: 📝 GitHub: ⭐ Discord: ▶️ Subscribe: 🎉 𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗔𝗱𝗱-𝗶𝗻 𝘁𝗼 𝗯𝗼𝗼𝘀𝘁 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆 Get it here: 📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻 Check out my recommendations: ☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓ If you want to support this channel, you can buy me a coffee here:

Share with your friends

Link:

Embed:

Video Size:

Custom size:

x

Add to Playlist:

Favorites
My Playlist
Watch Later