The online guide is designed for beginners with little or no SQL Server experience: https://www.guru99.com/ms-sql-server-tutorial.html
Additionally you can also read about the Top 50 SQL Server Interview Questions & Answers: https://www.guru99.com/sql-server-questions.html