• Install SQL Server

• SQL Server Management Studio Overview

• Windows Authentication in SQL Server

• SQL Server Authentication

• Create a New User in SQL Server

• GRANT/REVOKE Permissions to User in SQL Server

• Data Types in SQL Server

• SQL Server Naming Conventions

• CREATE Database in SQL Server

• CREATE Table in SQL Server

• Add Columns to Table in SQL Server

• What is Identity Column?

• Rename Column and Table in SQL Server

• Drop Columns from a table in SQL Server

• What is the Schema in SQL Server?

• Relations between tables in SQL Server

• IF ELSE Statement in SQL Server

• Loops in SQL Server

• Built-in Functions in SQL Server

• Insert data into table

• Update data

• Delete Data from a table

• Select Query in SQL Server

• WHERE Clause

• GROUP BY Clause

• HAVING Clause

• ORDER BY Clause

• Inner Join in SQL Server

• Left Join in SQL Server

• Right Join in SQL Server

• Full Join in SQL Server

• Self Join in SQL Server

• Build dynamic SQL queries in SQL Server

• Primary Key in SQL Server

• Modify/Delete Primary Keys

• Foreign Keys in SQL Server

• Modify/Delete Foreign Keys

• Check Constraints in SQL Server

• Unique Constraints in SQL Server

• Views in SQL Server

• Modify/Delete Views

• Functions in SQL Server

• Stored Procedures in SQL Server

• Stored Procedure Parameters

• Indexes in SQL Server

• Non-clustered Indexes

• Modify/Delete Indexes

• Triggers in SQL Server

• DDL Triggers

• LOGON Triggers

• Enable/Disable Triggers

• Modify/Delete Triggers

• Sequence in SQL Server

• Synonyms in SQL Server