SQL Server Tutorial reference - Learn MS SQL Server

MS SQL Server Tutorial

What is SQL Server?

SQL Server is a database management system that was developed by the company Microsoft. This system works in a relational way, and other similar systems (although they belong to the competition) are Oracle, MariaDB, and MySQL, among others.

In its beginnings, SQL Server was only available for Microsoft Windows operating systems, but in recent times this has changed, and today it is available for both GNU/Linux and Docker as well.

You can configure the SQL Server system in several instances on the same physical server. In case you choose to use it several times, it is recommended that you use the server name the first time and then opt for more specific names (you can include dates if you consider it easier that way).

SQL Server Query

Inner Join	Left Join	Right Join	Self Join
Group By	Having	Order By	Where

SQL Server Triggers

Create Trigger Syntax	Create DML Trigger Example
Alter Trigger Syntax	Alter DML Trigger Example
Drop Trigger Example	Enable Trigger Example
Disable Trigger Example	Rename Trigger Example

SQL Server View/Procedure

Create View	Alter View
Modify Data View	Rename View
Drop View	Create Procedure
Create Function	Call Stored Procedure Example

SQL Server examples
Nested case statements in SQL Server
Understanding how NULL works in SQL Server