Here you can find Basic Concepts of T-SQL, and a lot of query examples.
It can also be a learning path for those who just starting to learn MS SQL
-
Data Definition Language(DDL), (Data manipulation language)DML
-
Select, Where, Like, Between, Group by, Having and other tools
Projects are written on SQL Server Managment Studio 17.9.1.