Switch from Mysql to Sql Server

Question

Hi SL community,
I started to learn SQL and have little to no experience in the field of databases.
After starting the SQL Fundamentals here on SL, I read that that course uses Mysql and php.

My goal is to apply for a job which contains working with microsofts sql server..

So my question is, how big is the change from mysql + php to sql server if I just continue with the course. Also an advice from a pro on efficient learning for sql server would be highly appreciated!
Thanks in advance

Answer 1

They are quite similar since they both use SQL. But some functions do not exist and some are implemented differently. Also stuff like date format etc are different. I think the most notable difference is that MySQL is free and SQL Server is not. You can get a free Express version though but it is very limited.

I don't know why you want to migrate to SQL Server but if the choice is yours to make I would suggest PosgreSQL instead

Answer 2

CapCode I don't code C# but I know about C# applications that use a RDBMS. So I guess it is possible.