SQL standard?

Question

Hi, Thank you immensely for the help you guys offer. However, do you guys think it’ll be better to rename this MySQL Fundamentals? Or even if you do decide to stick with SQL, at the start of this, can you inform the learners of the distinction between SQL and MySQL and if that’s too much, just redirect them to a page they can learn about it on their own so that they can make a well informed decision to pursue this awesome learning course or look for something more suited to their needs. Just please put the information out there so that they/we don’t have to find out through comments. Thank you!

Answer 1

You're welcome, CtheS8ge. ☺

I can see why it would be less confusing to "put all the options out there" before saying what the course will focus on. I think the issue is that people are coming up with new stuff all the time, so providing a full list of clients that follow the SQL standard would not provide a great return for the efforts required to keep that list accurate and up-to-date. Fortunately, clients that follow the SQL standard don't deviate very much from the standard (unlike the wide deviation by web browsers from any client-side standard). Maybe it would be better to have a special flag through the course that says something to the effect of "This syntax is specific to MySQL." Suggestions can be e-mailed to [e-mail].

For your particular inquiry about "SHOW DATABASES", you are correct. It works for the MySQL client (I can't say "only" because I don't know how every client works), but other clients should have an equivalent or similar command (e.g. PostgreSQL has "\l" in the psql tool).

Answer 2

Hi CtheS8ge,

I think it does cover it pretty early on...

https://www.sololearn.com/learn/SQL/1849/

Answer 3

Hi Janning⭐

Thank you! However, naming the course more specifically will save some people the time. That link you sent, indicates that the information is in the second Lesson or the end of the first lesson I think.
Also, that’s not enough information for a beginner. Put all the options out there and then say “we will focus on MySQL in this course”. One question. Oh and last question. :) Can the “Show Databases” code, be used in SQL Standard? Or does that only work for MySQL? Thanks