SQL Tutorial

This page contains the list of all the articles of the SQL Tutorial. It will help in understanding the basic concepts as well as the advance concepts easily.

Basic Concepts

Database Creation

1. Database Creation using Create Database command
2. Database Creation using SQL Sever Management Studio (SSMS)
3. How to take Database backup in SQL SERVER
4. 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
•  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
•  Ranking Functions in SQL Server
•  Merge Command In Sql Server
•  Replication in SQL Server
•  Log Shipping in SQL Server
•  Case Statement/ Expression in SQL Server
•  Isolation levels in SQL Server
•  Fragmentation in SQL Server