Run SQL queries in EXCEL (just like a normal Excel formula ๐คฏ)
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: