Implementing EAV Models in SQL Server (Entity-Attribute-Value)
This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:
http://www.learnitfirst.com/Course161
In this final video of chapter 3, trainer Scott Whigham discusses the SQL_VARIANT data type. What is it and what does it allow you to do? You will see how to actually put it to use in SQL, and learn about EAV (Entity-Attribute-Value) modeling. How does the EAV design differ from traditional relational database design? What are some benefits of using the EAV design? Some problems?
Highlights from this video:
- SQL_VARIANT_PROPERTY
- Changing the base type of a variable
- What is EAV?
- EAV design vs. traditional relational database design
and much more...
Видео Implementing EAV Models in SQL Server (Entity-Attribute-Value) канала LearnItFirst.com
http://www.learnitfirst.com/Course161
In this final video of chapter 3, trainer Scott Whigham discusses the SQL_VARIANT data type. What is it and what does it allow you to do? You will see how to actually put it to use in SQL, and learn about EAV (Entity-Attribute-Value) modeling. How does the EAV design differ from traditional relational database design? What are some benefits of using the EAV design? Some problems?
Highlights from this video:
- SQL_VARIANT_PROPERTY
- Changing the base type of a variable
- What is EAV?
- EAV design vs. traditional relational database design
and much more...
Видео Implementing EAV Models in SQL Server (Entity-Attribute-Value) канала LearnItFirst.com
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Overview of SQL Server Data Types: Time Zone Aware Dates
Broken Ownership Chains in SQL Server 2008/R2
Understanding the SSIS Package ProtectionLevel Settings, Part 2
How to Download Multiple Files with the FTP Task (Part 2)
An Overview of SSIS for Newbies and Beginners, Part 2
Working with Files and Folders: The FTP Task (Part 2)
The WHERE Clause: Using BETWEEN and NOT BETWEEN
The WHERE Clause: FAQs About Working with LIKE
What is Transact-SQL and How Does It Fit? (2008/R2)
The History of SQL Server, Part 2
An Overview of SSIS for Newbies and Beginners, Part 2
How to Pre-Populate Parameters to Avoid SQL Injection Attacks
SQL Server 2008/R2 Reporting Services Actions: URLs and Hyperlinks
SQL Server Backup Compression and Security
How to Do Banded Rows with Report Parameters in SQL Server 2008/R2 Reporting Services
Databases in SQL Server 2008: The Data File and the Transaction Log
How to Declare and Initialize Variables in T-SQL (Part 2)
A Breakdown of the ETL Process in SQL Server 2008/R2
Preparing Your Environment to Install SQL Server 2012 - Exercise
The Basics of Execution Plans and SHOWPLAN in SQL Server