As a Marketing Cloud marketeer I really see queries as very powerful in creating strong segments. So, I've dived into SQL and query writing using codeacademy and w3schools, but even though I find these resources valuable, I have a very hard time using my new SQL skills in Automation Studio as I find the entire setup both slow, as results needs to be populated into a data extension, and hard to debug, as error descriptions seem inadequate. This might be related to me being a new kids using queries and new to SQL, but I doubt I'm the only one going through this phase.
So, everyone mastering queries in Automation Studio in Marketing Cloud, what have you done to ease the transition of SQL skills outside of Marketing Cloud to be useful in Marketing Cloud in order to work as efficiently as possible?
Any tips might help, as I really feel this being a personal obstacle I need to overcome, to be a better marketeer :)