SQL Server 2016 is released this month at first of the June, and in this tutorial I will demonstrate how to install SQL Server 2016 on your machine. Installation of SQL Server 2016 is more-less same as SQL Server 2014 version but this this time SQL Server Management Studio (SSMS) is not part of standard installation so we need to install it before or after SQL Server installation.

SQL Server commands (DDL, DML, DCL i TCL) are the topic of this blog post in which I will try to explain which commands belongs in which group, so I hope that with real examples that will be clear and how to use them.