SQL - Primary And Foreign Keys
So if your here on this post you're after understanding the mysteries of Primary/Foreign key relationships. Well let me tell you they are an art form not an exacting science something at first you may not appreciate until you deal with your own database schema's.
Basically, all databases need them. I have had arguments with people in the past saying "you don't need them" I normally let them have just enough rope to hang themselves but make sure I have got the scissors on standby to save the day when they discover the need for them when duplicate orders or duplicate customers start cropping up in thier "brand new" database system.
I cannot stress to you all the importance of primary keys.....foreign keys are important but in my line of work (BI) I can get away without using them as much. But Primary Keys are paramount in a design as they make them unique and indexed. The final point about indexes will be covered in more detail on a separate video as the goal here will be to understand the symbiotic relationship these primary/foreign key elements have for each other.
This is one of many videos which can be seen at PCTeach.me. Come join the gang!
Sur cette page du site, vous pouvez voir la vidéo en ligne SQL - Primary And Foreign Keys durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur PCTeachME 16 octobre 2009, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 135,890 fois et il a aimé 209 téléspectateurs. Bon visionnage!
