SQL Tutorial 10: Integrity Constraints

[@lokeshp1929]

Missed this kind of teachers in schools and colleges

[@sdetpavan]

Thanks

[@The_Wellness_Vibes]

Great..!!! What a awesome way of explanation sir... You are bestest teacher i have ever seen in my whole life... Thanks you so much..

[@sdetpavan]

It's my pleasure

[@9739459478]

each and every video is clear and crispy, worth of watching ur videos

[@sdetpavan]

Thanks

[@eshwarr4279]

You are the best in explaining any concept sir, you made my training easy and understandable. By using DEFAULT constraint, I observed that You have done this presentation on May 21st,2019 but published on May 24th,2019.

[@kishoresrinivas2104]

Your teaching is like a spoon feeding ❤ thank you very much for your knowledgeable information sharing with use sir ❤❤❤😊😊😊

[@sdetpavan]

Welcome

[@kishorshitole6909]

Thank you, sir, you're the best teacher. The way of explanation is too good to understand easily. Keep going on.

[@sdetpavan]

Welcome

[@Move_Further]

Thank you sir ...the way you present the whole series is amazing !!!

[@sdetpavan]

Welcome

[@SaiKiran-gz9sq]

excellent training sessions i have never seen till now. I hope in future also you will teach new trendy topics to us it will be a huge help for us

[@surajsalunke_sss]

Point to point explanation, every second of watching this video was worth. Thank you so much sir !!

[@sdetpavan]

You’re welcome

[@sindhujasadhu]

Thank you, sir, you're the best teacher. keep going on...

[@sdetpavan]

You are most welcome

[@Itsourfamilys]

Sir thank you so much gaining lot of knowledge from your sql and database videos very helpful 🎉👏👏👍💐

[@sdetpavan]

Always welcome

[@umangsaluja8034]

your content is blessing in disguise.

[@kanchanshirnath6556]

Thank you so much sir, Every video is cleared with all concept.

[@kiranmaiganapuram9079]

excellent sir.. the way of explanation is too good to undestand easily. :) thanks for uploading..

[@sdetpavan]

Welcome

[@TalzBlaze]

you are a brilliant teacher

[@sdetpavan]

Thanks

[@rakshathakare4197]

Concepts are clear 😊

[@sdetpavan]

Thanks

[@manojbharadwaj4644]

Sir please mention real time examples for keys and joins. And also mention that department table is a subset table of employee table and show an example why it will be added so that the logic behind why its connected will be understood

[@meenumeenakshib5228]

Thank you sir, clearly explained. Can you explain about the domain constraints also?

[@shankarmusale2253]

Sir nice explanation .

[@sdetpavan]

Keep watching

[@nagarjunadon4130]

Excellent 👏👏👏

[@sdetpavan]

thanks

[@arabindamohanty2190]

Excellent

[@sdetpavan]

Thanks

[@suryaprakash-on9ry]

clearly explained sir

[@sdetpavan]

thanks

[@vaithisaran41]

Thank you for easy to follow videos. Is there any way you could share the powerpoint presentation that you refer for all the videos? It will be greatly useful for eveyone.Thank you.

[@sowjanyavanarasi7928]

Hi sir, In this tutorial you have taught how to add constraints for a column in the table at the time of table creation but Please tell me how to add constraints to the columns for already existing table.?

[@sdetpavan]

you have to use alter table command.You can check it in google.

[@mabbusk653]

Sir one small doubt once i create table when submit commit statement then we perform this operations is possible or not

[@mujaheedadil143]

5 years are completed still sir are you not provide the any link of practice purpose of HR Database
Or you can you provide the link+ some amount of which is use full for both us Thank you.

[@BethammalKaruppasamy]

my mom likes your channels

[@lathasri124]

Thanks much sir, your Explanation is very much clear about to each point.. I need some career guidance, so how can we contact you for suggestions sir

[@brizeshhh]

Excellent, explanation sir,
i am beginner in it industry currently working as civil engg and looking to switch career next i want to learn python after sql
Do you have any series for that?
Community can also suggest me any playlist pls thnx in advance

[@kishorshitole6909]

yes python series also available

[@arpitgarg4756]

Hi Sir, I have one query i.e I want to know , how can we delete the multiple duplicates records from the table ?

[@arun-en3cq]

we can use union clause.

[@arpitgarg4756]

@@arun-en3cq How ?
Can you write query here ?
Eg- we want to delete multiple duplicate records from one table only ?

[@SDvirgo]

@@arpitgarg4756 Go through tutorial 8 union concept, you can use same in your query

[@kishorshitole6909]

delete from employees where rowid not in(select max(rowid) from employees group by all_columns_name_here) if latest row as unique
delete from employees where rowid not in(select min(rowid) from employees group by all_columns_name_here) if oldest row as unique

[@mohammedbashashaik2542]

SIR I WANT INTERVIEW QUESTIONS

[@sapanasharma4427]

hello sir, your tutorial is very good. where will i get this ppt?

[@prasanthjoshi7]

Sir for creating table student
It causes error
Error shows 👇
A table must have at least one visible column
Then what would we do can u please explain sir

[@rohitsingh1136463]

Sir check constraint is not working in my sql

[@PRALAYGHOSH-lp1db]

Sir can you share this PPT description or comment box

[@mayurivmulje1407]

I need document link of this and previous video

[@deepakgupta-gh3nv]

Sir can you provide notes over SQL

[@akashpawar5955]

sir please can u share this ppt or paste the link of it .

[@tinyfeetbunnu532]

any one having notes

[@rajureddy5539]

Bro, send that PPT in description or comment box

[@mr.perfecttube6541]

Don't call him, bro, You should have some common sense. He is delivering life-changing content!

[@brizeshhh]

Excellent, explanation sir,
i am beginner in it industry currently working as civil engg and looking to switch career next i want to learn python after sql
Do you have any series for that?
Community can also suggest me any playlist pls thnx in advance