Тёмный

Sql Normalization Hindi | Normalization in DBMS Hindi 

Lotusamaze
Подписаться 23 тыс.
Просмотров 185 тыс.
50% 1

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

Опубликовано:

 

20 июн 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 117   
@blackdranzer2686
@blackdranzer2686 2 года назад
most underrated channel. aapki wajay se itna sikhne ko milta h. thank you sir!
@lotusamaze1142
@lotusamaze1142 2 года назад
Thanks for liking
@zapeeosheikh
@zapeeosheikh 2 года назад
💯
@rj5638
@rj5638 Год назад
kaha se ho aap
@CBSE_Board_Education_0007
@CBSE_Board_Education_0007 Месяц назад
Right
@adityarangra9019
@adityarangra9019 Год назад
I have watched more than 10 videos lakin ...... aapki videos se hi samjh aayi normalisation thankyou
@lotusamaze1142
@lotusamaze1142 Год назад
Welcome
@rahulkumarsalgotra8984
@rahulkumarsalgotra8984 Год назад
The best video on normalization!🌋
@lotusamaze1142
@lotusamaze1142 Год назад
thanks
@THE_AK47
@THE_AK47 Год назад
one of the best video on internet on this topic
@lotusamaze1142
@lotusamaze1142 Год назад
Thanks
@zeeshanali4502
@zeeshanali4502 Год назад
@@lotusamaze1142 where to get the notes of its plzz tell me sir i am requisting to you
@khushigupta94
@khushigupta94 Год назад
Very nice video 👍🙏 Bhut acche se smj aaya. Thnk u for making this wonderful video.
@lotusamaze1142
@lotusamaze1142 Год назад
thanks
@rohanbarghare1586
@rohanbarghare1586 Год назад
Thank you sir!!!.This is the best explanation
@lotusamaze1142
@lotusamaze1142 Год назад
Thanks and welcome
@neerajmaurya8875
@neerajmaurya8875 4 месяца назад
I have deeply understand normalization types thanks u sir u are great sir🙏
@lotusamaze1142
@lotusamaze1142 4 месяца назад
All the best
@dhruvghadge9416
@dhruvghadge9416 5 месяцев назад
Thanks sir last moment pass hu jaunga
@kaushandutta4593
@kaushandutta4593 9 дней назад
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.
@ishandevil1698
@ishandevil1698 9 месяцев назад
amazing video and very easy explanation thank you sir
@lotusamaze1142
@lotusamaze1142 9 месяцев назад
So nice of you
@liaqatalikhan5582
@liaqatalikhan5582 10 месяцев назад
Very Well Explained then my University Teacher,
@lotusamaze1142
@lotusamaze1142 10 месяцев назад
Thanks
@gourikashyap2550
@gourikashyap2550 2 года назад
Great explanation 🙌🏼🙌🏼👍🏽
@lotusamaze1142
@lotusamaze1142 2 года назад
Glad it was helpful!
@kuchbhi4228
@kuchbhi4228 2 года назад
Very well explained 👍 thanks
@lotusamaze1142
@lotusamaze1142 2 года назад
Glad it was helpful!
@sureshpal5569
@sureshpal5569 Год назад
great explanation
@lotusamaze1142
@lotusamaze1142 11 месяцев назад
Glad it was helpful!
@muhammadsameer1512
@muhammadsameer1512 10 месяцев назад
thank uh so much sir love from (PK)
@lotusamaze1142
@lotusamaze1142 10 месяцев назад
Thanks
@deepagangber
@deepagangber Месяц назад
Really, thank you sir
@lotusamaze1142
@lotusamaze1142 Месяц назад
thx
@ZohaibRajpootFromSheikhupura
@ZohaibRajpootFromSheikhupura 6 месяцев назад
Love from Pakistan 🇵🇰 Sir you are doing great job 😊
@lotusamaze1142
@lotusamaze1142 6 месяцев назад
Thanks
@yourbrave189
@yourbrave189 11 месяцев назад
Great Explanation
@lotusamaze1142
@lotusamaze1142 11 месяцев назад
Glad you liked it
@Cricinformer01
@Cricinformer01 Год назад
Thanks for the explain normalisation
@lotusamaze1142
@lotusamaze1142 Год назад
Happy to help
@atuldhakne1407
@atuldhakne1407 Месяц назад
From where i will get this pdf??
@rajatbhamare2785
@rajatbhamare2785 2 года назад
Very well explained sir
@lotusamaze1142
@lotusamaze1142 2 года назад
Thanks and welcome For Training Call or WA 91-8076787743
@salmanabbassayyed3414
@salmanabbassayyed3414 Год назад
Thank you sir
@lotusamaze1142
@lotusamaze1142 Год назад
All the best
@vicky24a_2_zdjsongcollecti9
@vicky24a_2_zdjsongcollecti9 2 года назад
Must be thanks 👍😊 sir ji
@lotusamaze1142
@lotusamaze1142 2 года назад
Welcome
@CBSE_Board_Education_0007
@CBSE_Board_Education_0007 Месяц назад
Means we need to uderstand first difference between primery key and unique key
@lotusamaze1142
@lotusamaze1142 Месяц назад
yes
@moglii913
@moglii913 9 месяцев назад
LOVE FROM SGU 🎉❤
@lotusamaze1142
@lotusamaze1142 9 месяцев назад
Thanks
@darkshadowgaming5657
@darkshadowgaming5657 9 месяцев назад
LOVE FROM SGU ♥️
@lotusamaze1142
@lotusamaze1142 9 месяцев назад
Thanks
@vijayyadav0277
@vijayyadav0277 Год назад
Thank u sir 🙏
@lotusamaze1142
@lotusamaze1142 Год назад
All the best
@SanjayKumar-yh8fd
@SanjayKumar-yh8fd Год назад
thanks of lot sir
@lotusamaze1142
@lotusamaze1142 Год назад
thanks
@LearnwithRandomYoutuber
@LearnwithRandomYoutuber 2 года назад
helped me lot
@lotusamaze1142
@lotusamaze1142 2 года назад
thanks
@abbassayed6288
@abbassayed6288 Год назад
sir iss video mein aapne mysql use kiya hai ya oracle sql?
@lotusamaze1142
@lotusamaze1142 Год назад
MS SQL Server
@__________________________6910
@__________________________6910 2 года назад
Thanks
@lotusamaze1142
@lotusamaze1142 2 года назад
Welcome
@Neotron3
@Neotron3 Месяц назад
Nice explanation
@lotusamaze1142
@lotusamaze1142 Месяц назад
Thanks and welcome
@ankitsaxena565
@ankitsaxena565 3 года назад
Nice sir ji
@lotusamaze1142
@lotusamaze1142 3 года назад
Thanks
@01amishakumaricse43
@01amishakumaricse43 2 года назад
Thankyuu so much sir
@lotusamaze1142
@lotusamaze1142 2 года назад
Thanks
@YuvrajSingh-rr5lh
@YuvrajSingh-rr5lh Год назад
thanks
@lotusamaze1142
@lotusamaze1142 Год назад
You're welcome!
@lensmenvlog8437
@lensmenvlog8437 2 года назад
It’s amazing
@lotusamaze1142
@lotusamaze1142 2 года назад
Thanks for liking
@lifechangingthoughts3888
@lifechangingthoughts3888 Год назад
Perfect
@lotusamaze1142
@lotusamaze1142 Год назад
Thanks
@sonamsahay3619
@sonamsahay3619 2 года назад
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
@lotusamaze1142 2 года назад
Your question is not clear. You can email your query on lotusamaze@gmail.com
@akshu__
@akshu__ 2 года назад
Tq
@lotusamaze1142
@lotusamaze1142 2 года назад
Thanks
@24manojp
@24manojp Год назад
Nice Video Sir. Can you please add 5th NF also.?
@lotusamaze1142
@lotusamaze1142 Год назад
Yes, sure
@vikasnayak8497
@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
@reetujangu1818 9 месяцев назад
Record unique hi h kiyu ki isme ek ek record alg h proper same nhi h
@pruthviraj_njr
@pruthviraj_njr 9 месяцев назад
Wowww
@lotusamaze1142
@lotusamaze1142 9 месяцев назад
Thanks
@ankitratnani3582
@ankitratnani3582 Год назад
How to handle if a person works for 2 department or can have multiple address?
@lotusamaze1142
@lotusamaze1142 Год назад
Create three table Emp, Dept. Master and Address Master Table
@raviburman452
@raviburman452 5 месяцев назад
Sir but BCNF table can write Duplicate attribute???
@lotusamaze1142
@lotusamaze1142 5 месяцев назад
Yes you can
@SUPERGAMING-te1gl
@SUPERGAMING-te1gl 2 года назад
nice sir
@lotusamaze1142
@lotusamaze1142 Год назад
Thanks and welcome
@Shivayadav-dn4qe
@Shivayadav-dn4qe Год назад
nice
@lotusamaze1142
@lotusamaze1142 Год назад
Thanks
@NILguha007
@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
@lotusamaze1142 Год назад
make emp_Id as primary key
@NILguha007
@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
@lotusamaze1142 Год назад
what is your exact requirement?
@NILguha007
@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
@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
@vidyahawaldar4408 2 года назад
Where is Emp_is E1004 in 1st normal form.. after 1st normalization
@lotusamaze1142
@lotusamaze1142 2 года назад
I will check and let you know
@akashsoni5782
@akashsoni5782 Год назад
Can you please share the PPT ?
@lotusamaze1142
@lotusamaze1142 Год назад
Sorry, PDF are part of our Training
@ishandevil1698
@ishandevil1698 9 месяцев назад
where could we practise about normalforms do you know any platform
@lotusamaze1142
@lotusamaze1142 9 месяцев назад
sorry, no idea
@user-sp3nt9ii2u
@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
@user-oy5dx7uo3u Год назад
INCREASE HOTI H NO
@user-rm6nl1kc1r
@user-rm6nl1kc1r 23 дня назад
U❤
@lotusamaze1142
@lotusamaze1142 15 дней назад
Thanks
@darkshadowgaming5657
@darkshadowgaming5657 9 месяцев назад
PRANAV PATIL KING OF SGU 👑
@pradeepmishra3233
@pradeepmishra3233 Год назад
Sir aap ka whatsapp number mil sakta hai
@lotusamaze1142
@lotusamaze1142 Год назад
91-8076787743
@pradeepmishra3233
@pradeepmishra3233 Год назад
@@lotusamaze1142 is number pr message Kiya hu reply nhi De rhe aap
@pradeepmishra3233
@pradeepmishra3233 Год назад
Kya sir ..whatsapp number nhi milega
@deepikapawar6605
@deepikapawar6605 2 года назад
nice sir
@lotusamaze1142
@lotusamaze1142 2 года назад
Thanks and welcome For Training Call or WA 91-8076787743
Далее
Fudbol hozir vs avval😂
01:01
Просмотров 478 тыс.
Complete guide to Database Normalization in SQL
40:51
Просмотров 140 тыс.
1NF 2NF 3NF DBMS Hindi
13:21
Просмотров 56 тыс.
WHY NORMALIZATION IS NEEDED IN DBMS? (WITH EXAMPLE)
5:42
🔥 Master MSQL Stored Procedures in Hindi
41:39
Просмотров 19 тыс.
Fudbol hozir vs avval😂
01:01
Просмотров 478 тыс.