SQL Tutorial 10: Integrity Constraints

[@kishoresrinivas2104]

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

[@sdetpavan]

Welcome

[@lokeshp1929]

Missed this kind of teachers in schools and colleges

[@sdetpavan]

Thanks

[@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

[@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

[@Itsourfamilys]

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

[@sdetpavan]

Always welcome

[@Move_Further]

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

[@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

[@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.

[@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

[@sindhujasadhu]

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

[@sdetpavan]

You are most welcome

[@surajsalunke_sss]

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

[@sdetpavan]

You’re welcome

[@umangsaluja8034]

your content is blessing in disguise.

[@kanchanshirnath6556]

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

[@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.

[@TalzBlaze]

you are a brilliant teacher

[@sdetpavan]

Thanks

[@kiranmaiganapuram9079]

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

[@sdetpavan]

Welcome

[@meenumeenakshib5228]

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

[@shankarmusale2253]

Sir nice explanation .

[@sdetpavan]

Keep watching

[@rakshathakare4197]

Concepts are clear 😊

[@sdetpavan]

Thanks

[@arabindamohanty2190]

Excellent

[@sdetpavan]

Thanks

[@suryaprakash-on9ry]

clearly explained sir

[@sdetpavan]

thanks

[@nagarjunadon4130]

Excellent 👏👏👏

[@sdetpavan]

thanks

[@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.

[@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

[@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.

[@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

[@mabbusk653]

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

[@sapanasharma4427]

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

[@BethammalKaruppasamy]

my mom likes your channels

[@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

[@mayurivmulje1407]

I need document link of this and previous video

[@deepakgupta-gh3nv]

Sir can you provide notes over SQL

[@PRALAYGHOSH-lp1db]

Sir can you share this PPT description or comment box

[@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

[@rohitsingh1136463]

Sir check constraint is not working in my 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