Yes, the basics of SQL are the same no matter the environment.
The differences when using a derivative of SQL (for example, T-SQL,) or when working in different environments (like MySQL, MariaDB, PostgreSQL and Oracle) are small.