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.<p>- Step 1
- Step 2
- Loop through results in Step 2
- Curate and finish output.<p>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.<p>Does anyone else face this problem?<p>Any suggested guides / books to make me think more SQL'ley ?