Using Excel to Enhance SQL Skills

For those who has been in the IT field for many years, this information may seem very obvious. However, when I was going into my first data analyst position, this information would have helped me a ton. Excel is far from a database management software, but there are many ways you can use it to your advantage to make writing SQL code much more efficient. I am going to show you the 2 examples that I use most often. Once I realized how powerful Excel was in writing code, my life became endlessly easier.

Updating Multiple Rows