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

  Deleting Duplicate rows using CTE

  Stuff VS Replace function in SQL Server

  While loop in SQL server

Advance Topics

 Indexes in Sql server

Interview Questions on SQL Server

 Interview Questions On Sql Server -Part 2

 Interview Questions on Sql Server -Part 3

1 comment:

  1. How to read data from csv file in Mysql?