MS SQL Server 2012 Guide for Beginners - Database Relationships - Part 4/5
https://sqlserver2014tutorial.com/
In this MS SQL Server 2012 video series, we cover the different types of Database Relationships in Microsoft SQL Server 2012. Database relationships refer to two columns in a database or databases reference each other. They are usually defined where a Primary Key is linked to a Foreign Key.
This five-part series covers the following:
- Part 1 – This part covers some terminology and one-to-many database relationship in SQL Server 2012
- Part 2 – This part covers the many-to-many database relationship in MS SQL Server 2012
- Part 3 – This part shows how to link databases using a Foreign Key (FK)
- Part 4 – This part continues demonstration of many-to-many database relationships and database linking
- Part 5 – This part continues demos of many-to-many database relationships using a database junction table
There are three types of Database Relationships in MS SQL Server 2012:
- ONE-TO-ONE: Not a very common database relationship. This is where one row in a table has only one matching row in another table. Typically used for splitting a table or for isolating part of a table for security purposes.
- ONE-TO-MANY: The most common database relationship, this is where one row in a table has one or more matching rows in a second table. However, one row in the second table will only have one matching row in the first. For example, for a Customer-Order database, one customer may have many orders, but one order will only have one customer.
- MANY-TO-MANY: In this relationship, a row in one table can have many matching rows in a second table and the second table can have many matching rows in the first table. In a Patient-Doctor database, one patient can have one or more doctors and one doctor can have one or more patients. This type of database relationship requires a third table which stores the information from both the first and second tables.
This video part (4 of 5) continues the demonstration of the many-to-many database relationship in SQL Server 2012. The second demonstration shows a Departments-Classes database relationship and how to link the two using a foreign key (FK) relationship.
Please subscribe to our channel and like our videos! We have many training videos on MS SQL 2012
Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/
Видео MS SQL Server 2012 Guide for Beginners - Database Relationships - Part 4/5 канала baghul
In this MS SQL Server 2012 video series, we cover the different types of Database Relationships in Microsoft SQL Server 2012. Database relationships refer to two columns in a database or databases reference each other. They are usually defined where a Primary Key is linked to a Foreign Key.
This five-part series covers the following:
- Part 1 – This part covers some terminology and one-to-many database relationship in SQL Server 2012
- Part 2 – This part covers the many-to-many database relationship in MS SQL Server 2012
- Part 3 – This part shows how to link databases using a Foreign Key (FK)
- Part 4 – This part continues demonstration of many-to-many database relationships and database linking
- Part 5 – This part continues demos of many-to-many database relationships using a database junction table
There are three types of Database Relationships in MS SQL Server 2012:
- ONE-TO-ONE: Not a very common database relationship. This is where one row in a table has only one matching row in another table. Typically used for splitting a table or for isolating part of a table for security purposes.
- ONE-TO-MANY: The most common database relationship, this is where one row in a table has one or more matching rows in a second table. However, one row in the second table will only have one matching row in the first. For example, for a Customer-Order database, one customer may have many orders, but one order will only have one customer.
- MANY-TO-MANY: In this relationship, a row in one table can have many matching rows in a second table and the second table can have many matching rows in the first table. In a Patient-Doctor database, one patient can have one or more doctors and one doctor can have one or more patients. This type of database relationship requires a third table which stores the information from both the first and second tables.
This video part (4 of 5) continues the demonstration of the many-to-many database relationship in SQL Server 2012. The second demonstration shows a Departments-Classes database relationship and how to link the two using a foreign key (FK) relationship.
Please subscribe to our channel and like our videos! We have many training videos on MS SQL 2012
Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/
Видео MS SQL Server 2012 Guide for Beginners - Database Relationships - Part 4/5 канала baghul
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Google Analytics 2021 - How to Add a User - Online Marketing for Small Business](https://i.ytimg.com/vi/WZ7aOxcW2zo/default.jpg)
![Google SEO tips: 5 Google Products and services you Must-Know for SEO](https://i.ytimg.com/vi/zlA4aBmSdQ4/default.jpg)
![Typing Made EZ® for Microsoft Office](https://i.ytimg.com/vi/3KGpEuABHi8/default.jpg)
![MS SQL Server 2012 How-to - Creating Database Objects in MS SQL Server 2012 - Part 3/5](https://i.ytimg.com/vi/RdlOCuQHw48/default.jpg)
![Digital Marketing 101 - Online Marketing for Small Business SEO Overview | Dallas SEO](https://i.ytimg.com/vi/5GR3fakxu0s/default.jpg)
![SQL Tutorials by Kash 6 - SQL Insert Statement in MS SQL 2012](https://i.ytimg.com/vi/oGu8-LltAVY/default.jpg)
![Integrating Google Analytics and Search Console - 2021 SEO Strategy - Business Online Marketing](https://i.ytimg.com/vi/9Wtn7QBcmac/default.jpg)
![Jazz up your Ebay listing and get more Hits!](https://i.ytimg.com/vi/YoFEWLU7M88/default.jpg)
![Top 10 Digital Marketing Websites for Small Business Owners](https://i.ytimg.com/vi/upb5RUy2GL4/default.jpg)
![MS SQL Server 2012 Training - Implementing Security - SQL Server 2012 Part 2/3](https://i.ytimg.com/vi/Gj1U7--XLbI/default.jpg)
![Kash Data Consulting LLC - Online Marketing and SEO in Plano, TX](https://i.ytimg.com/vi/Nd9sseY9xtw/default.jpg)
![Google Adwords Tutorial - Part V - What is Google Adwords?](https://i.ytimg.com/vi/vbrlhci7gQg/default.jpg)
![Keyword Research Part 3 - Competitive Analysis- Online Marketing for Small Business](https://i.ytimg.com/vi/r7WQH1TDX1E/default.jpg)
![How to Renew Your BNI Networking Membership](https://i.ytimg.com/vi/M7xOHDwpuvM/default.jpg)
![SQL Server 2012 Tutorial - Configuration Manager for SQL Server 2012 - Part 1/2](https://i.ytimg.com/vi/H0cBx5_0JgQ/default.jpg)
![Word 2007 Sample Video - How to add table in Microsoft Word](https://i.ytimg.com/vi/iykGkGdIvHg/default.jpg)
![SQL Tutorials by Kash - Training on SQL DELETE statement](https://i.ytimg.com/vi/hIiKT1619vY/default.jpg)
![MS SQL Server 2012 Guide for Beginners - Database Relationships - Part 5/5](https://i.ytimg.com/vi/5siJ6SUoi6U/default.jpg)
![Free Microsoft Office video - Keyboard Shortcuts](https://i.ytimg.com/vi/kRzLlZilKno/default.jpg)
![Kash Comedy Part 1](https://i.ytimg.com/vi/EgqHHlul0rU/default.jpg)