Switch from Mysql to Sql Server | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок

Switch from Mysql to Sql Server

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

19th Jun 2020, 1:40 PM
2 ответов
+ 2
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
19th Jun 2020, 1:48 PM
Ore - avatar
+ 1
CapCode I don't code C# but I know about C# applications that use a RDBMS. So I guess it is possible.
19th Jun 2020, 2:35 PM
Ore - avatar