Project

Databases for Sales

Medium

198 completions

~ 8 hours

4.3

Make a database from an entity-relationship diagram, enhance the performance of routine tables with trigger, index, view, and write MySQL queries to obtain valuable information from the database.

Provided by

JetBrains Academy

About

The volume of data generated by our car dealership continues to grow daily. The data can help you draw significant conclusions to run the business more efficiently. But first, we need a convenient way to collect, organize, and store the data. This project focuses on designing and optimizing a database system enabling efficient data management.

Graduate project

This project covers the core topics of the SQL for Backend Developers course, making it sufficiently challenging to be a proud addition to your portfolio.

At least one graduate project is required to complete the course.

What you'll learn

Once you choose a project, we'll provide you with a study plan that includes all the necessary topics from your course to get it built. Here’s what awaits you:

Design the database based on the entity-relationship diagram.

Use triggers to update your tables automatically.

Optimize popular queries with index and views.

Write complex queries with WITH and CASE.

Reorganize your product mix to squeeze the margin.

Reviews

Paul Naber

1 week ago

4.3

Really liked it, but was quite hard at times (at least for me)I think there is an issure with the diagram. the primary key of the inventory should also include the date. I was confused by it. The product_id can be in there multiple times (it will be) so it is not uniqe. Only together with the date. ...

Krystian Kłosowicz

1 month ago

4.7

I've learned a lot about subqueries, how they can my query more readable, how to use aggregate fucntiond and lots more..

Jonatan Luna Franco

3 months ago

4.7

I have learned advanced SQL queries and practiced with next-level problems.

4.3

Learners who completed this project within the SQL for Backend Developers course rated it as follows:

Usefulness

4.7

Fun

4.2

Clarity

3.9