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
From the course: Advanced SQL for Data Scientists
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?
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.