Difference between Subquery, Nested Subquery and Correlated Subquery

Difference between Subquery, Nested Subquery and Correlated Subquery Query Query can be defined as a way to inquire the data from the database. It is used to extract the data from one table or multiple tables depending upon the user needs. Suppose we have a two tables Student and courses whose structure is given below:- […]

Continue Reading

Sql server Constraints – Primary Key, Foreign Key, Unique Key, Not Null, Check Constraints

Introduction A constraint is a property that is assigned to a column or a group of columns to prevent incorrect or corrupt data from entering into the tables. These constraints ensure the accuracy and reliability of the data into the tables. This article will tell about the Sql server Constraints – Primary Key, Foreign Key, […]

Continue Reading