From the course: Data Engineering: dbt for SQL
Join today to access over 24,800 courses taught by industry experts.
Challenge: Schema design
From the course: Data Engineering: dbt for SQL
Challenge: Schema design
(bouncy upbeat music) - [Narrator] Let's put some of these skills to the test. In this challenge, you're going to take on the role of a company that sells products online. The company wants to create a database to track its internal sales information and they have hired you for the job. They also have big plans and want you to design a schema that is extensible and stable. To kick things off, they have provided a few pieces of information that they would like to track. First, the company has a catalog of products. Each product has a name, price and current inventory count associated with it. Multiple products can have the same name, the same price and the same inventory count. Second, they would like to track sales. They have an interesting way of handling the sales too. Each sale corresponds to a single item being sold. This means that in the event that a customer buys multiple quantities of the same item, each item will…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.