Sql Normalization Hindi | Normalization in DBMS Hindi

Sql Normalization | Normalization in DBMS
This video helps you to understand what is normalization in sql. Why it is required and how to normalize the database. Also give clear concepts abut the type of normalization.
MS SQL Hindi Playlist : • SQL Tutorials-Hindi
MS SQL English Playlist : • SQL Tutorial-English
Power BI DAX Hindi Playlist : • DAX Hindi
Power BI DAX English Playlist : • DAX English
Power BI Hindi Playlist : • Power BI Tutorials-Hindi
Power BI English Playlist : • Power BI Tutorials-Eng...
#sqlserver #sql #sqlinterviewquestions #mssqlserver #sqlforbeginners #education #rdbms #sqlcourse #sqlcommands

[@blackdranzer2686]

most underrated channel. aapki wajay se itna sikhne ko milta h. thank you sir!

[@lotusamaze1142]

Thanks for liking

[@zapeeosheikh]

💯

[@rj5638]

kaha se ho aap

[@CBSE_Board_Education_0007]

Right

[@adityarangra9019]

I have watched more than 10 videos lakin ...... aapki videos se hi samjh aayi normalisation thankyou

[@lotusamaze1142]

Welcome

[@khushigupta94]

Very nice video 👍🙏
Bhut acche se smj aaya. Thnk u for making this wonderful video.

[@lotusamaze1142]

thanks

[@kaushandutta4593]

I don't get the 4th normal form. Multi valued dependency cannot create an anomaly , since all are non key attribute and all are dependent on primary key.

[@rahulkumarsalgotra8984]

The best video on normalization!🌋

[@lotusamaze1142]

thanks

[@neerajmaurya8875]

I have deeply understand normalization types thanks u sir u are great sir🙏

[@lotusamaze1142]

All the best

[@rohan_b_ra]

Thank you sir!!!.This is the best explanation

[@lotusamaze1142]

Thanks and welcome

[@deepagangber]

Really, thank you sir

[@lotusamaze1142]

thx

[@THE_AK47]

one of the best video on internet on this topic

[@lotusamaze1142]

Thanks

[@zeeshanali4502]

@@lotusamaze1142 where to get the notes of its plzz tell me sir i am requisting to you

[@dhruvghadge9416]

Thanks sir last moment pass hu jaunga

[@ishandevil1698]

amazing video and very easy explanation thank you sir

[@lotusamaze1142]

So nice of you

[@kuchbhi4228]

Very well explained 👍 thanks

[@lotusamaze1142]

Glad it was helpful!

[@Cricinformer01]

Thanks for the explain normalisation

[@lotusamaze1142]

Happy to help

[@vicky24a_2_zdjsongcollecti9]

Must be thanks 👍😊 sir ji

[@lotusamaze1142]

Welcome

[@gourikashyap2550]

Great explanation 🙌🏼🙌🏼👍🏽

[@lotusamaze1142]

Glad it was helpful!

[@yourbrave189]

Great Explanation

[@lotusamaze1142]

Glad you liked it

[@sureshpal5569]

great explanation

[@lotusamaze1142]

Glad it was helpful!

[@rajatbhamare2785]

Very well explained sir

[@lotusamaze1142]

Thanks and welcome For Training Call or WA 91-8076787743

[@liaqatalikhan5582]

Very Well Explained then my University Teacher,

[@lotusamaze1142]

Thanks

[@salmanabbassayyed3414]

Thank you sir

[@lotusamaze1142]

All the best

[@SanjayKumar-yh8fd]

thanks of lot sir

[@lotusamaze1142]

thanks

[@atuldhakne1407]

From where i will get this pdf??

[@01amishakumaricse43]

Thankyuu so much sir

[@lotusamaze1142]

Thanks

[@vijayyadav0277]

Thank u sir 🙏

[@lotusamaze1142]

All the best

[@muhammadsameer1512]

thank uh so much sir love from (PK)

[@lotusamaze1142]

Thanks

[@Neotron3]

Nice explanation

[@lotusamaze1142]

Thanks and welcome

[@LearnwithRandomYoutuber]

helped me lot

[@lotusamaze1142]

thanks

[@ZohaibRajpootFromSheikhupura]

Love from Pakistan 🇵🇰
Sir you are doing great job 😊

[@lotusamaze1142]

Thanks

[@lensmenvlog8437]

It’s amazing

[@lotusamaze1142]

Thanks for liking

[@ankitsaxena565]

Nice sir ji

[@lotusamaze1142]

Thanks

[@HarshKumar-jw7eu]

Great video ❤🎉

[@lotusamaze1142]

Thanks

[@HarshKumar-jw7eu]

@lotusamaze1142 make more videos

[@lotusamaze1142]

sure

[@__________________________6910]

Thanks

[@lotusamaze1142]

Welcome

[@lifechangingthoughts3888]

Perfect

[@lotusamaze1142]

Thanks

[@YuvrajSingh-rr5lh]

thanks

[@lotusamaze1142]

You're welcome!

[@sonamsahay3619]

My question is if we add primary key in my 1st table there after we add foreign key my table. Here it automatically performe 2NF . I mean to say that is there any query over Normizilation.

[@lotusamaze1142]

Your question is not clear. You can email your query on [e-mail]

[@ankitratnani3582]

How to handle if a person works for 2 department or can have multiple address?

[@lotusamaze1142]

Create three table Emp, Dept. Master and Address Master Table

[@CBSE_Board_Education_0007]

Means we need to uderstand first difference between primery key and unique key

[@lotusamaze1142]

yes

[@akshu__]

Tq

[@lotusamaze1142]

Thanks

[@darkshadowgaming5657]

LOVE FROM SGU ♥️

[@lotusamaze1142]

Thanks

[@moglii913]

LOVE FROM SGU 🎉❤

[@lotusamaze1142]

Thanks

[@deepikapawar6605]

nice sir

[@lotusamaze1142]

Thanks and welcome For Training Call or WA 91-8076787743

[@raviburman452]

Sir but BCNF table can write Duplicate attribute???

[@lotusamaze1142]

Yes you can

[@pruthviraj_njr]

Wowww

[@lotusamaze1142]

Thanks

[@abbassayed6288]

sir iss video mein aapne mysql use kiya hai ya oracle sql?

[@lotusamaze1142]

MS SQL Server

[@Shivayadav-dn4qe]

nice

[@lotusamaze1142]

Thanks

[@vikasnayak8497]

Sir 1st NF bolta hai need unique record but 2 nf m toh record unique ni h kaise explain kr rhe ho aap

[@reetujangu1818]

Record unique hi h kiyu ki isme ek ek record alg h proper same nhi h

[@24manojp]

Nice Video Sir. Can you please add 5th NF also.?

[@lotusamaze1142]

Yes, sure

[@NILguha007]

Sir maine Insert Into(emp_id, quali, age) values (111, Ma, 38) dala toh mera table phirse wo data capture kar liya
Error show nehi kiya
Please help sir 🙏

[@lotusamaze1142]

make emp_Id as primary key

[@NILguha007]

@@lotusamaze1142 thank you so so much sir for your kind reply 🙏
But sir now I created table like
Create table emply_data (
Emp_id int identity (1, 1) primary key,
Qualification varchar (max),
Age int
)
Abb sir emp_id k column m no example- 111 nehi enter kar paa raha hu
Wo ab primary key ban chuka h, sirf qualification or age m hi data put ho raha h
Please help sir🙏

[@lotusamaze1142]

what is your exact requirement?

[@NILguha007]

@@lotusamaze1142 sir was watching your video of 2NF normalization in that you said
Insert into (emp_id, qualification, age)
Values (111, 'MA', 38) ;
*#that part of video
**violation of primary key constraint 'pk_emp' cannot enter duplicate key............
So for doing/testing it in pratical i started creating a table
create table emply_data (
Emp_id int identity (1, 1) primary key,
Qualification varchar (max),
Age int
)
In that sir when I am entering the value only qualification & age can be entered it is not accepting any no. or alphabet in emp_id..
That is my problem sir
Hoped you understand sir
Please help 🙏

[@lotusamaze1142]

In emp_id data type is INT so it will take only unique numbers. You can create composite Key i.e emp_Id+Qualification to make the uniqueness for the combination of emp_id and qualification

[@vidyahawaldar4408]

Where is Emp_is E1004 in 1st normal form.. after 1st normalization

[@lotusamaze1142]

I will check and let you know

[@akashsoni5782]

Can you please share the PPT ?

[@lotusamaze1142]

Sorry, PDF are part of our Training

[@ishandevil1698]

where could we practise about normalforms do you know any platform

[@lotusamaze1142]

sorry, no idea

[@user-sp3nt9ii2u]

Kisi k pass Agar waqt hai toh jawaab de dena
*With increasing level of normalization kya no. Of tables increase hoti hai ya decrease?
*hardware level pe dekhe toh creation of table kya 1 concept hai sirf?

[@user-oy5dx7uo3u]

INCREASE HOTI H
NO

[@user-rm6nl1kc1r]

U❤

[@lotusamaze1142]

Thanks

[@darkshadowgaming5657]

PRANAV PATIL KING OF SGU 👑

[@pradeepmishra3233]

Sir aap ka whatsapp number mil sakta hai

[@lotusamaze1142]

91-8076787743

[@pradeepmishra3233]

@@lotusamaze1142 is number pr message Kiya hu reply nhi De rhe aap

[@pradeepmishra3233]

Kya sir ..whatsapp number nhi milega

[@SUPERGAMING-te1gl]

nice sir

[@lotusamaze1142]

Thanks and welcome