From the course: Advanced SQL for Data Scientists

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

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 Buy for my team

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