Why Learn SQL

If proficient with Excel, then why learn SQL? Several reasons:

Excel workbooks have a maximum of 1,048,576 rows within a workbook — so the more data you have, the more likely you’ll run into this limit. SQL is able to be run on billions of rows of data within a database
Speed — if filtering an Excel workbook with 1 million rows of data, vs performing a SQL query on the same database, then that SQL query will likely run many times faster. SQL is built for speed and flexibility with larger datasets
Firms store billions of rows of data in databases where SQL is the standard — you will need to learn SQL to access a company’s database in many cases, Excel will not even be a valid option.
Automating tasks — Incorporating SQL and Python can automate your processes and store data in a SQL database that can be accessed and updated from many sources in a nimble manner