5MinuteSQL - string split tutorial in Microsoft SQL Server

In this video we look at string_split(), a TVF in Microsoft SQL Server that allows us to convert comma, separated, lists into tables. We use string_split to convert a comma-separated tag list in a YouTube videos database to a 3rd-normal-form (3NF) model, allowing us to use SQL to find videos by tag, and tags by video. We build a replacement data model and show what this looks like using an ERD in QSEE SuperLite.

A bit longer than usual, this 10-minute video also brushes upon GROUP BY CUBE as an analytical data source.