SQL Constraints | Primary Key | NOT NULL | Unique Key | Default | Check | Foreign Key | In Hindi
HTML-код
- Опубликовано: 20 окт 2020
- SQL Constraints | Primary Key | NOT NULL | Unique Key | Default | Check | Foreign Key | In Hindi | Tutorial#04
in this playlist, I am going to start Structured Query Language (SQL). SQL is one of the best database software which is broadly used. It is mainly the syllabus part of 11/12/BCA/BTech student and I have designed this in such a way that it is specially designed for 11/12/BCA/BTech student. In this video, I have explained SQL Constraints. SQL are basically set of rules that applies to a table. In this video I have explained the various constraints like primary key, unique key, NOT NULL, check constraints, default constraint and foreign key constraint.
Telegram Channel: t.me/codeituplearners
Facebook Group: / 21673. .
Instagram: t.me/codeitupyt
Facebook Group: groups/21673...
Facebook Page: / codeitup-104310264625489
Website: codeitup.in
Join this channel to get access to perks:
/ @codeitup
Link to Previous Video: • SQL Commands | DDL DML...
Link to next video: • Create Table | Create ...
Tags Used:
sql constraints
primary key
not null
unique key
default
check
class xii mysql tutorial hindi
primary key constraint
not null constraint
unique key constraint
check constraint
default constraint
foreign key
foreign key constraint
constraints in sql in hindi
constraints in sql server
constraints in sql meaning
constraints in sql javatpoint
constraints in sql geeksforgeeks
constraints in sql dbms
constraints in sql pdf
constraints in sql ppt
constraints in sql server with example
adding constraints in sql
all constraints in sql
check constraint in sql
integrity constraints in dbms
domain constraints in sql
constraints in sql hindi
#codeitup
#sql
#cbse
@CBSE
@CBSE INDIA
@Unacademy CBSE Science 11 & 12
@CBSE Udaan XI
@Ncert Solutions CBSE ncerthelp.com
Your teaching is placed under PRIMARY KEY ,mast sir keep it up👌👌👌
Instant concept application 😅
Best computer teacher on you tube👌
Thanks😊
Sir your teaching is great.... You make concepts very easy to understand .....Your teaching is like PRIMARY KEY for me.... 💯🙏🙏😃
Thanks a ton Ashish, keep learning!
This Channel is very Underrated channel to learn Programming 🔥🔥🔥
Glad you think so!
sir ap bahut accha padhate hain....really great ,,your teaching style and video quality is great .....since long iam waiting for data visualisation of pandas....sir plzz upload those videos....eagerly waiting ....i know that views jada nahi ja pate pandas mei pr apke teaching ko dekh kr lgta hai bht hi jldi ap bht famous ho jaoge....
thankyou sir
Your teaching is Best Sir 🙏🙏❤️🙏🙏
Great stuff, brilliant. loved it. you explained it so smoothly like a hot knife just gets into butter. Love from Scotland. Sir Anand keep an eye on my comments at least I can do to admire you.
😊
thanks sir you are a gem school mein kuch smjh nahi arha hai aur kaafi aage nikal gayi teacher aapki videos ache se dekhunga thanks slot
thanks sir aapne bhut easy way main explain Kiya Maine Bhut sari videos dekhi kissi main smj nhi aya apki ek video Mai. Pura concept clear ho gya
So nice of you Anku, keep learning😊
Your way of teaching,explanation are awesome i have read about constraints many times but always i had a doubt about it .now today its cleared by your explanation so thank you very much.
Most welcome Nasim & thanks a lot for your precious comment😊
Basically according to set theory in mathematics we can say, Primary key is the super set of Unique key and Not Null key, or Not Null and Unique key is the subset of Primary key, or we can say Primary key is the union of Not Null key and Unique key.
you are a blessing to me i havent started anything for the boards exams but now is the time you are developing interest in me for computers and i am sure i will score good
🙂👍
thank you so so so much sir ❤.20 mins ago i did not know a single thing about constraints
You are most welcome!
Love u sir ,cant explain in words how much this video helped me understanding. ...thankx a lot💖💖
Glad to help you🙂
The way of explanation is just Awesome!!
Thanks Ranjan 😊
Great sir means i can't tell you how much you helped me i dont even like this subject because of your teaching skills i started taking my interest in this
Glad to help you Devesh, keep learning!
@@codeitup Check constraint me salary thi to erase kar use change kar par agar student marks hota to kya karte use to erase kar khud se change nhi kar sakte to us condition me kaise karege check constraint
Yeah i too 😄
Same bhai❤️
Bhaiyaaa u r great🌟
🙂
very clearly and easily explained ..thanks sir 😄
Most welcome Luxmi!
Informative video sir ji🙏🙏
Thanku so much sir my every concept is cleared. Because of your expanation. You are very nice teaching. Efforts. Once again thanku so much sir 😊
Most welcome Nisha & thank a lot for your precious comment🙂
Thank you sir explain very well bhot ache se smaj aaya
Thank you so much ☺️
Most welcome Shivam!
Best ip teacher
Your explanation style is just awesome. It helps me a lot .
Thank you sir for such a great video 🙏.
My pleasure Hrishab!
@@codeitup sir kya unique key ko candidate key bolte h
@@circleofshadowgaming3840 hlo
@@santoshofficial7854 hlo
@@circleofshadowgaming3840 I seen your channel Bro 💗
i have understood 100% sir, Thank you so much sir
Most welcome Nikunjanath!
Thank you sir so much , i love this video ❤
Most welcome Aradhana!
Thanks sir for this amazing video
Most welcome!
God level Teaching 😇
So nice!
Hats off sir 🙌 your explanation is owesome 😘
Thanks😊
Thank you for explaining things so well.
Most welcome Suankit!
Sir kya mast padhate ho aap, aap ki wajah se mujhe computer science accha lagne laga h☺️☺️
😊👍
Sir your teaching way is so nice🥰🥰
Thanks a lot 😊
Thanks for the informative video
Thank you so much sir video helped me a lot 🙏
Most welcome !
Very Useful video Thanks
Please make JavaScript video.
You are a good explainer !
Thanks a lot Ashok!
Thanku so much bhaiya🙏🙏
Poora sql padha dijiye aise hi 🙏🙏
Sir you are the best teacher for ip subject for those who are loo kingjoining ip coachings
Thanks a ton Vinita!
@@codeitup welcome sir
Very very very Good Explaination....
Thank you so much PKG!
Just Superb👍👍👌👌
Good😊👍
very well explained. May God bless you
Thanks😊
Btw...
This video was very helpful sir
Glad it helped!
Excellent sir really very easy technique u are using
So nice of you🙂
Amazingly explained
Thanks Priya!
Very nice explaination sir tq
Thanks & most welcome!
awesome teaching style
Thanks dear😊
thankyou very much.
Most welcome😊
Thank you so much sir 😊
Most welcome!
sir alternate key and candidate key class 12 syllabus me hai?
Thank you sir
Most welcome😊
very good class sir
nice Thanks
Always welcome Badal!
super sir thank you for teaching
Thanks & most welcome Sujeet!
Thanks sir 👍
Most welcome😊
Super sir ji
Thanks dear😊
Thank you very much sir ji
Always welcome Abhiman 😊
amazing
Thanks😊
Bhaiya mai class 12 me hu aur muzhe information technology mili h yt pe koi it nhi padhata but apke ye lec dekh ker muzhe ache se samjh aa gaya h apse 1 request h Mai Java to apke video se kar lunga but muzhe 1 ch samjh nhi aa rh pls thoda time nikal ke 1 y 2 video me vo bana dijiye. Chapter name h operating web pls. Request h
Thank you very much sir 💞💞💞💞
Most welcome Lilawati!
Your way to explain is amazin, thankyou sir 👍
Most welcome dear!
@@codeitup your teaching style is a primary key in itself
Wow, and your way of comment is Unique key...
@@codeitup 😂😂😂
@@codeitupamazing reply👏😂👍😂
Thanku so much sir🤩🤩🤩🤩🤩😍😍😍🥰🥰🥰👍👍👍👍👍👍👍👍👍🙏🙏🙏🙏🙏
Most welcome Devesh!
thanks sir
Most welcome!
Kindly do video on pattern matchings
nice one explained
Thanks dear😊
Thanks sir 🌹🌹
Most welcome Jyoti!
THANKS
Welcome!
Sir exam related questions bhi karwa do
Sir kya foreign key ma duplicate value hoo skatee hai
Sir pls try to get a side..before rubbing the board..it will be somewhat easy to take notes....
Hope u recover ..AS soon as possible
Sure. From next time I will take care of it.
Sir is this enough for gate exam
Nice
Thanks!
Term 2 cs 🙋
Sir plz aap practical v krwaie plz plz sir
Sir alternate key and candidate key comes under sql constraints or not?
No, that are not constraints.
sir your videos and oswaal question bank both are enough to score 35/35 in ip ??
More than sufficient
@@codeitup thanks sir
Plz tell me one more think that how many days should i prepare to get 35/35
Kya Matlab 23rd ko exam hai or Mei ye dekh rha hu 22nd ko😂😂
👍
Same here
Sir I have doubt " in check constraint salary
hi, 1st of all salary10000 is applied. Dont mistaken , it affects your chances o selection. have a good day.
Sir pls tell me one thing kya kevl aapke videos he dekh lu to board mae 90+ marks lae aaunga
Yes, but aapko khud se bhi questions answers practice karne honge.
sir please tell what is candidate key?
At 15:42 little bit of mistake 😅🙂 >1000 and you have written 1000 in salary love your videos bas maine find keya mistake to bta deya 🤪
Nice sir ......thanks sir
.....abhi kass ha
Thanks Udai, Bas thik hai. !
Sir what is candidate key?
Please show how not null is used
I love the song after he say 'chaleye start krte hai '
Thanks 😀
Sir iska matlab ye hua ki primary key or unique key to same hi hai to fir iske nam kyu alg h unka Jo work h oh bi same ha
sir char aur varchar me difference plz.........
when i apply check constraint in a column and enters a value in the table that does not obey the check constraint then mysql should show error but rather than showing error it executes successfully and the data gets entered in the table
Can you tell why is it happening ????????
??
Sir please make a video on all chapters of class 12 ip sir you're
Cbse sir
Sir kya hum primary key aur unique key ko same nai kh skte?? Kyoki duplicate value to dono me hi accept nai ho skti
Pr unique ke andr duplicate ni chhiye pr blank ho skti
Lekin primary key ke andr duplicate bhi ni ho skti aur khali bhi
Sir aap board k uper light set kar lijiye thoda light ki kami lag rahi h
Alternate key candidate key?????
Sir apke videos mai sirf 12th ke hi topics hote hai kya? Kya aap sab topic cover krte ho.. because i am engineering student thats why i am asking.
Look prerna, no programming or topic is only for 12th. Programming is always in a flow and some of the topics may be missing in 12th and you will get that in Engineering. Rest all are same. So, be sure that programming is never based on any class. The same Java programming is taught in 12/BCA/BTech/MTech as well with a difference of some of the topics.
@@codeitupOk..Thank you so much sir👍
Sir dataframe complete hua kya playlist me 13 part tak hae
Tomorrow Will upload dataframe video. Two more videos are there for first chapter.
SIR G GOOD EVENING
SIR G AAP JO BLACKBOARD PAR NOTES LIKHTE HAI VO SUFFICIENT HAI TERM 2 EXAM K LIYE ?
Yes, it's sufficient
@@codeitup THANKS SIR JI
Sir aapane candidate ki aur alternated ki ke bare mein nahin bataya
Sir aap graph bnana sikhao
Please
Sir sbse jayda questions kis chapter se aate h board exam me ??🥺
Can unique key constraints left blank??
Yes it can be...
@@codeitup ok sir thanku
Bhaiya alternate, candidate key ko miss kr diye aap
Thank you sir 😊 but aapka writing samajh main aa raha tha lekin dekhne mein Sahi nahin lag raha tha 🤗🥰 sir ke channel ko like Karen subscribe Karen comment Karen
Sir tuple kya hota hai It me tuple is a collection of deleted information sir tuple ke bare mein kuchh video daliye
😌
Sir.....the database integrity rule refers to....1) unique constraint 2) Primary key
Ans kya hoga??
Entity Integrity - Primary Key
Referential Integrity - Foreign Key
@@codeitup sir...Is the integrity rule will be primary key in the case of SQL also or it will be Unique constraints ?
@@codeitup sir is the answer will be same in the case of SQL also ?
@@sumandas5676 yes. dbms concepts are from SQL so how can it get changed
@@sumandas5676 integrity rule will be primary key
11:08
??