Project

Coloring

Easy

82 completions

~ 6 hours

4.1

Start by learning basic SQL actions like SELECT, FROM, GROUP BY, and WHERE. Move on to understanding sum functions, logical and comparison operators, and then explore more advanced ideas like subqueries and join statements. This learning path is designed to equip you with the skills needed to efficiently fetch important information in SQL.

Provided by

JetBrains Academy

About

Discover the Painting Database, a tool that keeps it simple to understand how to paint squares with spray cans. Pick colors, track how much paint you use, and see how the colors mix on the squares. Whether you're just starting or already good at painting, this database makes it easy to learn and have fun with colors.

Training project

This project allows you to practice and strengthen your coding skills, helping you get ready for more advanced tasks ahead.

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:

Find the total amount of paint used for each color.

Find the remaining spray can volumes after all paintings.

Find squares painted in white and the number of sprays used to paint them.

Find red spray cans used more than once, choose those that are painted squares with a blue component.

Find all white squares painted only from spray cans, now empty.

Reviews

Tomasz Sowa

4 months ago

1.3

The DB schema was designed by someone who never used a DB in a real environment.

Tomas Kanuch

7 months ago

5.0

I have learned basic SQL queries using often JOIN, GROUP BY, ORDER BY. Stage 5 and 6 were kind of hard.

Boris Buľák

8 months ago

3.7

toto sa mi az tak nepacilo lebo sa tu pouzivaju veci ktore neboli zatial preberane ak ste si vzbraly ze idete podla projektov a nie podla courses

4.1

Learners who completed this project within the Databases with SQL and Python course rated it as follows:

Usefulness

4.3

Fun

4.1

Clarity

3.8