4 ms·
I 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
by abhishekjha 9y ago
I 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.