samir_patel0 views
I can do pivot tables, lookups and conditional formatting without thinking. Every analyst job I look at asks for SQL, and I do not know where to start. I have a few hours a week.
Should I begin with queries, or with how databases are organised first?
Be kind and specific. Read the community guidelines.
Accepted answer
You already think in tables, which is most of the work. A route that suits an Excel background:
The learning path SQL for data work on this site takes the lessons step by step, and each lesson shows the output so you can compare it with your own. Do the exercises in a small SQLite file so nothing can break.
I made the same move. What helped me was recreating one of my own Excel reports in SQL. Same numbers on both sides means you understood it.
That is a good test. I will rebuild my budget workbook as a few tables and queries. Thank you both.