Project

Databases for Sales

Medium

227 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

Yaraslau Krautsou

3 months ago

4.0

In this project I learned to build a dealership database from an ERD and then put it to work — defining correct primary and foreign keys (including the identifying relationship where product_id is both PK and FK in inventory), automating inventory updates with a trigger, and simplifying frequent que ...

Tomas Kanuch

7 months ago

4.7

I have learned to create procedure, create function, create view and to create trigger.

Olivier Leroy

7 months ago

4.7

Good project to practice most of the learned topics. You will even start by creating some parts of the database from a diagram and create some triggers.I would say it is a bit easier than the Airline Transportation project.

4.3

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

Usefulness

4.7

Fun

4.3

Clarity

4.0