SQL: One of the most valuable skills
SQL is a mind bender for me. I do a lot of work on Data, use python and pandas to do a lot of data magic, but the problem with me is my mind is too procedural in thinking.- Step 1
- Step 2
- Loop through results in Step 2
- Curate and finish output.I try very hard to transform the above steps into an SQL statement spanning multiple tables, but always fail and I usually fallback to python for manually extracting and processing the data.Does anyone else face this problem?Any suggested guides / books to make me think more SQL'ley ?