Menu
Community /Pin to ProfileBookmark
@NogDogJul 06.2021 — #I think you generally tend to learn both at the same time, as you cannot really do much in any relational database system (whether MySQL, PostgreSQL, Oracle, SQL Server, etc.) without writing SQL. Conversely, writing SQL is pretty pointless if you do not have a database to run it in. In any case, SQL in general will carry across to numerous DBMS's, so if learning in MySQL, it's good to keep an eye out for any custom SQL functions it uses that are not "standard" SQL.
You can use one of the many LAMP (Linux, Apache, MySQL, PHP) stack installers out there to get MySQL up and running on your local PC without a lot of hassle, e.g. "wampserver" for Windows or "XAMPP" for Mac/Linux as two popular options.
However, just learning SQL is not sufficient for becoming truly fluent in using databases, as you should also learn some basic concepts with regard to database "normalization" and optimization.
What to learn advice please..
Hello.
I want to become backend web developer. I learn php.
I have a problem with the databases. Php manuals talk about MYSQL. But MYSQL uses SQL.
What should I actually learn? SQL first, then MYSQL?
Thank you.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogJul 06.2021 — #You can use one of the many LAMP (Linux, Apache, MySQL, PHP) stack installers out there to get MySQL up and running on your local PC without a lot of hassle, e.g. "wampserver" for Windows or "XAMPP" for Mac/Linux as two popular options.
However, just learning SQL is not sufficient for becoming truly fluent in using databases, as you should also learn some basic concepts with regard to database "normalization" and optimization.