The video was well structured. Yet in the explaination of 1NF, The 1st record of Addresses is placed to alll the Rows, which could have been avoided for better understanding.
The primary key in the relational model can be of any valid data type, numeric, string etc. MySQL server also supports that. So you can define a primary key as a string. Also it is possible to have composite primary key. For example in the students table, student roll number and student group number together can uniquely define each student row. So that 2 fields may compose a primary key.
Hi, The main use of key is to identify records, so better to have only one primary key and rest other columns if required can become unique key or candidate keys. Best practices use only one key column as primary key, will be easy to manage rather than going multiple columns. Unique key can be : String / Integer can be Null Candidate Key : Int Not Null Primary Key : Int Not Null
20 MSBI Interview Questions : ua-cam.com/video/Nw_sHEKnOUE/v-deo.html
10+ Power BI Interview Questions : ua-cam.com/video/Cozc9WNBRt4/v-deo.html
20+ SQL Server Interview Questions : ua-cam.com/video/SEdAF8mSKS4/v-deo.html
SQL Server Joins : ua-cam.com/video/KTvYHEntvn8/v-deo.html
SQL Step by Step - ua-cam.com/video/uGlfP9o7kmY/v-deo.html
Angular Step by Step Tutorial for Beginners : ua-cam.com/video/-9VcW7MBDs8/v-deo.html
25 Angular Interview Questions : ua-cam.com/video/-jeoyDJDsSM/v-deo.html
35 Important JavaScript Interview Questions : ua-cam.com/video/Zb4dPi7CANU/v-deo.html
25+ OOPS Interview Questions : ua-cam.com/video/u99wAoBjDvQ/v-deo.html
30 Important C# Interview Questions : ua-cam.com/video/BKynEBPqiIM/v-deo.html
25 Important ASP.NET Interview Questions : ua-cam.com/video/pXmMdmJUC0g/v-deo.html
5 MSBI Interview Questions : ua-cam.com/video/5E815aXAwYQ/v-deo.html
There will be more videos on MySQL ...stay updated and watch this full video... As these are most asked questions in an Interviews
Osm explanation sir this the video i am searching for
@@amarpc3532 thanks so much.....
Wonderful video feels like I am interview ready
Speed 1.25x helps alot. Great content cuz these questions were asked to me.
The video was well structured. Yet in the explaination of 1NF, The 1st record of Addresses is placed to alll the Rows, which could have been avoided for better understanding.
Thank you sir was waiting for this video . As always top quality content .
Cool ...Thank you. 🙏
Excellent explanation :D of each and every questions
Thank you 😊🙏
Very nicely explained Sir, thank you,
Thanks. I learned lot of things
good work man
Thank you for your appreciation :)
Sir plz make similar interview video for React js
Sure 👍
Hello, correct me if I'm wrong but isn't it the primary key can also be an any type like GUID, VARCHAR etc?
The primary key in the relational model can be of any valid data type, numeric, string etc. MySQL server also supports that. So you can define a primary key as a string. Also it is possible to have composite primary key. For example in the students table, student roll number and student group number together can uniquely define each student row. So that 2 fields may compose a primary key.
Hi,
The main use of key is to identify records, so better to have only one primary key and rest other columns if required can become unique key or candidate keys.
Best practices use only one key column as primary key, will be easy to manage rather than going multiple columns.
Unique key can be : String / Integer can be Null
Candidate Key : Int Not Null
Primary Key : Int Not Null
thank you sir
Pls take the mysql video realtime project post now.
Very gud
Can u pls upload videos for manual testing
great video
I'm getting below error while build SQL Database Project in visual studio
has unresolved reference to object tempdb.sys.columns
For normalisation 👎
Hi sir, I joined in this channel as member, i am unable to view .net core mvc tutorial, please help me
What's composite primary key please reply Sir
can you please document are pdf formate
1.5X is much better
💚💚
This video couldn't even solve the 1NF and the guy moved over to a different example. This makes no sense
watch again bruhh