Articles Index

Basic Concepts

Database Creation
  Database Creation using Create Database command
  Database Creation using SQL Sever Management Studio (SSMS)
  How to take Database backup in SQL SERVER
  How to restore database backup in SQL SERVER

Database designing
 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

  Intersection command in SQL Server

  RIGHT() function in SQL Server

  LEFT() function in SQL Server
  Between function in SQL Server

  Deleting Duplicate rows using CTE

  Stuff VS Replace function in SQL Server

  While loop in SQL server

  Exception handling in SQL Server

  Best practices for Database Programming

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?