SQL Primary Key vs Unique Key Constraint in Hindi | SQL unique key example in DBMS #sqltutorial #sql

SQL Primary Key vs Unique Key Constraint explained in Hindi in this video of CSE Concepts with Parinita Hajra

Primary key will not accept NULL values whereas Unique key can accept one NULL value. A table can have only primary key whereas there can be multiple unique key on a table. A Clustered index automatically created when a primary key is defined whereas Unique key generates the non-clustered index

In this tutorial you will learn mysql SQL Primary Key vs Unique Key Constraint in Hindi | SQL unique key example in DBMS #sqltutorialforbeginners #primarykey #uniquekey #sqlqueries #dbms #dbmslectures #dbmstutorials

If you liked the video, please Like/ Comment/ Share/ Subscribe 🙂
Also, feel free to connect for more regular updates:

LinkedIn: https://www.linkedin.com/in/parinita-hajra-69497588/
Facebook: https://www.facebook.com/CSEconceptswithParinita
Telegram: https://t.me/CSEconceptswithParinita
Instagram: https://www.instagram.com/computer_science_concepts/
Whatsapp: https://chat.whatsapp.com/JykU0pTjgGTCPukNucQnqS
Mail: [email protected]
***********************************************************************************

In this in this session we are going to learn the differences between primary key and unique key
This is one of the most frequently asked sql server interview questions.
Before we discuss the difference between primary key and unique key, let’s see what a primary key is and what a

unique key is.
Primary Key:
Primary key is a key which uniquely identifies each row/record in the table.
This implies if you have a primary key on a table, you can identify each and every row in that table uniquely

using primary key.
Unique Key:
Unique key constraint enforces the uniqueness on the columns in which it is defined.
That is Unique key will make sure only unique values are allowed in the columns in which it is defined.

Similarities:
Both Primary key and unique Key enforces uniqueness on the columns on which they are defined.
• Primary key and unique Key columns allow only unique values.
• Primary key and unique Key columns will avoid duplicates
• Both Primary key and unique Key columns uniquely identifies each row/record in the table

Differences:
PRIMARY KEY UNIQUE KEY
Primary Key Does not allow duplicates Unique key allows only one NULL
A table can have only 1 Primary Key A table can have multiple Unique Keys
By default Primary Key creates a Unique Clustered Index on the table By default Unique Key creates a Unique

Non-Clustered Index on the table.

I hope this session is clear and i hope this knowldge should help you in interviews.

Please share your valuable comments & sugesstions. Also, subscriber to my channel for more sql server

interview questions and answers.

#sql #sqlqueries #havingclause #dbms #dbmstutorials #dbmslectures #sqlforbeginners

Primary key Vs Unique key in SQL in Hindi | What is the index in DBMS | clustered index in sql Hindi
What is the Difference between Primary Key and Unique Key
Database Tutorial. This video is about Database Fundamentals. I hope this series of videos can help

those who want to be Database Professionals. I will cover various database technologies including

Oracle Database, Microsoft SQL Server database and Sybase.

Video: What is the Difference between Primary Key and Unique Key

What is the difference between Primary key and Unique key ?
Differences between primary key and unique key – SQL Server Interview Questions