Primary key on two columns SQL Server

Primary key on multiple columns example | Composite primary key |
Composite key example | Primary key on two columns | Composite key in DBMS | Table composite key

Notes and Slides

SQL Server Tutorial for beginners course page.

SQL Server Tutorial for beginners playlist

SQL Server Interview Questions and Answers

SQL Server Performance Tuning and Query Optimization

[GundakaMandaka]

8+ years you were uploading videos . Dedication and Explanation is pretty awesome. You are my Guru. Thank you very much @kudvenkat.

[kevinc]

you are the best on explaining sql DB! I like your voice loud and clear!!

[mhraamirali]

Sir please complete azure tutorial series. 🙂🙂

[vikasverma]

Dear sir, your videos clear all doubts..

[pramodmaurya]

As always something new to learn from you...thanks a lot sir..

[venkatgandam]

Clearer cut explanation ..thank you Venkat

[mohansaivelagapudi]

Mr kudvenkat please upload all Data science courses like R, Python, Hadoop.... Waiting for that from you

[TheusKhan]

Your video is so helpful and clear all doubts! Excellent, thanks.

[sephyent]

Thank you for the explanation. I totally forgot this, after a long time not developing, My reference material are missing and google was not helping like after 1 hour i found this video. I guess its harder when you forgot and trying to specifically get the info you want then learning back all over again

[arunece]

I really appreciate your effort for sharing knowledge and like it. But one suggestion when ever you start any series please complete that and start another series.

[TommiLipponen]

This is a great piece on information, thank you Sir. Could you show at some point how to do a code first EF Core CRUD with similar composite key example like this one and UserId is ASP NET Identity GUID? I've tried it many times but always something goes wrong.

[jatinsharma]

Hello sir, i haven't found any videos related power automate tool. So i insist you to please upload any video to make it more understandable. Thanks.

[jalaluddin]

Please upload a video on populate value from one drop down list on another using foreign key constraints in mvc

[ramanjaneyulu]

Venkat sir Can you please start Course on React JS

[clashclan]

how to composite foreign key and how composite primary key physically order and saved. how the lookup work for this table... i mean analysis of execution plan

[singanasrinivas]

Hi Venkat, Your videos are very helpful to me. Thanks for your time and the way of your explanation.
I have a question here.
In composite primary key, how the indexes work?
Since there are two primary keys, two clustered indexes will be allowed ?

[clashclan]

How is composite primary key physically stored in the database? Pls make a video like u already did for primary, heap table, rid lookup

[balakrishnapemmasani]

Please complete azure remaining concepts sir

[KaliKali-crnf]

Still confused on composite pk 😕 you say no duplicate rows but on the Autors_book you had 1, 1 on both columns across the rows

[nareshbuddy]

@KudVenkat Hi Can you please explain on how to handle a scribbled Date format like '0002-03-21' to expected result '2021-03-2021' Can you please explain THank you in advance