SQL Server

SQL Server with examples

SQL Server scenarios for practice

Introduction DDL (Data Definition Language) Create Alter Drop Truncate DML (Data Manipulation Language) Select  Insert Update Delete DCL (Data Control Language) Grant Revoke TCL (Transactional Control Language) Rollback Save Transaction SQL Server Data Types Difference Between Delete, Truncate and Drop Operators Arithmetic operators Assignment operator Bitwise operators Comparison operators Compound operators Logical operators Set operators String concatenation operator Unary operators Commonly used Date and String Functions String Functions Date Functions Constraints Not null Unique Primary key Foreign key Check Defoult Views Indexes Joins Inner Join Outer Join Cross Join Self Join  Subqueries