I am moving from database from Microsoft Access to MS SQL and I have not worked with MSSQL before, can you recommend a good place to get some initial and then follow on training in SQL and MS SQL?

Are you looking for SQL server administration or Transact SQL? Here are some reference articles for SQL that may be of interest.

definitely install Microsoft SQL Server Management Studio

We will be doig both transactional and admin, but I want to be able to adjust code before I learn how to control the sql server. I feel like I am behind the power curve in learning sql coding as well! Are there any good online sql learning courses?