The SQL keywords (SELECT, FROM, WHERE, etc.) are case-insensitive, yet they are frequently expressed in all capitals. Table and column names are case-sensitive in some settings. MySQL provides a setting that allows you to enable or disable it. On Linux MySQL, case-sensitive table and column names are usually the default, while case-insensitive used to be the default on Windows, but the installer now asks about this during setup. It is a function of the database's collation setting in MSSQL.
If you need to know more about MS SQL, it is recommended to go for the SQL Certification Course today.