4 ms·
On a related note, Mode's SQL tutorial is the best comprehensive introduction to the language that I've come across. If you go through all of it you can get fro
by gringoDan 9y ago
On a related note, Mode's SQL tutorial is the best comprehensive introduction to the language that I've come across. If you go through all of it you can get from zero knowledge to 95% of the SQL skills you'll need as a data analyst.
https://community.modeanalytics.com/sql/tutorial/introduction-to-sql/ https://community.modeanalytics.com/sql/tutorial/introductio...
- uptownfunk 9y agoWhat’s the remaining 5%
- gringoDan 9y agoWorkarounds due to workplace-specific problems with your data...you'll learn that on the job :)
- mulmen 9y agoIn my experience that's a lot closer to 50%. SQL is easy, Data is hard.
- meritt 9y agoThis can't be overstated enough. Finding people who understand SQL is difficult enough, but finding people who intuitively "get" data is nearly impossible. And lately anyone who completed a few tensorflow tutorials thinks they're a Data Scientist and every single data question can be answered accordingly. Reminds me of the hadoop craze a decade ago.
- ValleyOfTheMtns 9y agoHadoop craze was a decade ago? Damn...
- abhishekjha 9y agoI am trying to learn intermediate to advanced SQL as my employer wants me to but apart from the the most basic keywords I don't see a lot of difference between Basic to Intermediate SQL. Or maybe by intermediate it means designing a good data model which shouldn't be concerned with SQL. My question is, if someone asks me to learn the advanced SQL constructs, where do I go? What do I look for?
- gordon_freeman 9y agohttps://community.modeanalytics.com/sql/tutorial/sql-data-types/ https://community.modeanalytics.com/sql/tutorial/sql-data-ty...
- swirepe 9y agoI found that the book SQL Antipatterns helped me figure out some advanced SQL constructs. It presents a problem, shows the naive solution, takes apart that solution, and shows a better way.
- wombatpm 9y agoDatabase Design for Mere Mortals by Ray Hernandez. Best book I've found to give a running start.
- z3t4 9y agoExplain the difference between INNER join and LEFT join, when you can do that you know intermediate to advanced SQL.
- gordon_freeman 9y agoImpressive tutorial! their advanced level tutorial is pretty awesome and helps someone who wants to brush up SQL skills before having analyst interviews. They even have Python tutorial too which I want to try as well.