From the course: Advanced SQL for Data Scientists

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Challenge: Design a table to support unstructured data

Challenge: Design a table to support unstructured data

From the course: Advanced SQL for Data Scientists

Start my 1-month free trial

Challenge: Design a table to support unstructured data

(light techno music) - [Instructor] Okay, here's a challenge around data modeling and design choices. Let's imagine you're working with an ecommerce company who wants to create a new catalog of products. Now different kinds of products are going to have different attributes and it's critical that users be able to query and filter on any attribute. And of course, performance is a key consideration. So how would you design a table to support this type of product model?

Contents