Articles Index

Basic Concepts
   Database Normalization
     First Normal Form (1NF) 
     Second Normal Form (2NF)
     Third Normal Form (3NF)


   DML, DDL, DCL, TCL in SQL Server
  
   ACID Rules in Sql Server


   Table Creation
  
   Sql server Constraints - Primary Key, Foreign Key, Unique Key, Not Null, Check Constraints


  Difference between Primary key and Unique key


  Identity Property


  Finding Duplicate Values in a table


  Renaming a Column in Sql Server


  How to remane a Table in Sql Server


  Adding , Deleting and Updating a Column in a table

  How to change the database collation


  Query, Sub Query, Nested Query and Correlated Subquery


  How to make database offline or online


  Group by.....Having Clause


  Difference Between Having and Where Clause in Sql Server


  Sql Server - Union and Union All


  Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins


Advance Topics

 Indexes in Sql server

 Difference between Clustered Index and Non clustered Index


 SQL Server-Table Variable


 SQL Server - Local temporary table


 SQL Server - Global temporary tables

 Sql Server - How to write a Stored procedure in Sql server

 SQL Server Functions- An Introduction

 Sql Server- Difference between Stored Procedure and Function

 Sql Server View

 Cursor in sql server


 SQL Triggers - An Introduction


 SQL Server- Output clause


 CTE command In Sql Server


 Derived Table In Sql Server

 Pivot and Unpivot table in SQL SERVER

Interview Questions on SQL Server

 Interview Questions on sql server -Part-1

 Interview Questions On Sql Server -Part 2


 Interview Questions on Sql Server -Part 3