Create primary and foreign keys SQL Azure Joins

http://www.sqlazuretutorials.com/ In this training video on Microsoft SQL Azure, we start off with important terms related to SQL Server Joins. These are ERD, Primary key (PK), Foreign key (FK), database relationships, Inner Join, Outer Join and Referential Integrity. We are going to create a Primary key in Customer table first and then join it with Foreign Key in the Orders table. A SQL Azure join brings data together from one or more tables. We go over how to create a SQL Join using SSMS and show you how to create Primary key with ALTER TABLE ADD CONSTRAINTS SQL statement. Using Venn Diagrams from Math, we elaborate on inner and outer joins. Finally we write the SQL syntax for the following INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN