SQL Tutorial

Referential Integrity in SQL Server with Realtime best 1 example

SQL Tutorial / By

Introduction In this article we will discuss Cascading Referential Integrity Constraints in SQL Server. SQL Server provide you to define cascading referential integrity constraints at table creation time or alter table. Let’s go ahead and discuss the same with proper real-time example. What are Referential Integrity in SQL Server? In the Microsoft SQL server if …

Referential Integrity in SQL Server with Realtime best 1 example Read More »

Transaction Control Language(TCL) in SQL with best No 1 example

SQL Tutorial / By

Transaction Control Language(TCL) commands are used for maintaining consistency of the database and for the management of transactions made by the DML commands. Whenever DML operation is main in an SQL table, the transaction never be saved unless or until save command is issued or a discard is issued. Transaction Control Language Commands TCL provide …

Transaction Control Language(TCL) in SQL with best No 1 example Read More »

Data Manipulated Language (DML) in SQL

SQL Tutorial / By

Data Manipulated Language (DML), which is responsible to manipulated language, the records of table. A Data Manipulation Language (DML)  is a sublanguage of SQL responsible to insert, update, delete or manipulate database object’s records. DML provides the following statement for manipulating the database objects. Insert update delete Syntax for insert Above syntax is syntax of …

Data Manipulated Language (DML) in SQL Read More »

Normalization in SQL

SQL Tutorial, SQL Server Interview Questions & Answers / By

Normalization is the processes of reducing the redundancy of data in the table and also improving the data integrity. Normalization emphasizes how to organize a database’s columns and tables to ensure that their dependencies are properly enforced by database integrity constraints. Normalization Types First Normal Form (1NF)  It simplifies each attribute in a relation. In …

Normalization in SQL Read More »