Why Learn SQL
Reasons for SQL Vs Excel:
If you can use both SQL and Excel to retrieve data that’s stored with columns and rows, then why every use SQL? Wouldn’t it always be simpler and faster to just copy/paste and deal with data in a point and click format with Excel, rather than writing a SQL query to return data? Not necessarily:
Data limits
An Excel workbook can have a max of 1,048,576 rows per sheet, so if you have 2 million rows of data, you would need an alternative — SQL databases offer a convenient and scalable option that have fewer hard limits
Speed
If you need to filter several hundred thousand of rows in an Excel workbook, and there’s other tabs within that workbook, you will likely find the Excel workbook running incredibly slow. It can and will likely even freeze on you, and it not the most efficient way to deal with data, especially once formulas and cell references are involved. SQL provides a quick way because of the behind-the-scenes nature of how SQL databases are setup, providing for quick lookups on data.
Joining data easily
Automation
