Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.Start your free trial
Why do different Databases use different keyword syntax?
I'm just curious why different Databases like MySQL and MS SQL Server use different syntax for keywords. Wouldn't it be simpler and easier to use a unified language syntax? I bet you it's frustrating to remember all the different Database nuances...Is there any advice more advanced users on Treehouse can give for remembering the differences between the DB's? Thanks!
Steven Parker229,005 Points
I don't even try to remember the different syntaxes. I rely on "cheat sheets" and online documentation as I flip from one database to another. As long as you know the concepts, looking up the syntax now and then is a minor issue.
As to why this is, standards are rarely established before technology exists. Most of the venerable databases have been around longer than the standards.
Markus Ylisiurunen15,034 Points
You'll eventually start remembering those differences and they will become your second nature. Just stick with it!
Little nuances like this usually have to do with IP and who the intended market is. Times have changed quite a bit, everything wasn't always freely open for use and replication as much as it is today. Oracle jumped in the db arena with an offering to the government having off-stream naming conventions sort of makes sense. I actually find the W3 schools and MDN websites to be good tools for any questions on those little differences.
Different databases companies are in competition with each other. And, some languages are going to be preferred over others.