Project

Coloring

Easy

63 completions

~ 6 hours

4.2

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

Vaibhav

6 months ago

4.0

good sql practise but last 3 stages are very unclear and badworded.Please improove this and also provide some more practise for sql writing as in last 3 stages.

Ludoviko Azuaje

7 months ago

3.7

The problem set (stage by stage) is challenging and finding the right solutions demands using advanced aggregate functions and other resources from the SQL.

Mauro Gonçalves

7 months ago

5.0

Okay, here's a simplified summary of the learning from the "Coloring Database" project: In this project, I practiced using SQL to analyze relationships between squares, spray cans, and painting actions. Key skills included: Finding items without matches in other tables (like unpainted squares) usi ...

4.2

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

Usefulness

4.4

Fun

4.2

Clarity

3.9