Project

Battleship Database

Easy

86 completions

~ 6 hours

4.2

Begin with fundamental SQL operations such as SELECT, FROM, GROUP BY, and WHERE. Explore summation functions, logical operators, and comparison operators before advancing to more sophisticated concepts like subqueries, and join statements. This learning journey aims to provide you with the necessary skills for effectively retrieving essential information in SQL.

Provided by

JetBrains Academy

About

As a novice fleet admiral, it is crucial to comprehend historical battles, their outcomes, and details concerning the battleships, particularly during the pivotal period of the Second World War. Access to the Battleship Database gives you vital information about past battles, ship performance, and battle results, making it easier to develop effective strategies for future naval encounters.

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 information about the "Pearl Harbor" battle.

Find the ship classes with the highest number of main guns.

Find the countries that produced the largest number of battleships.

Find the number of sunk ships in battles for each country.

Find ships with the earliest launch date for each country.

Find the ship classes that have engaged in at least three battles and to provide an analysis of the outcomes of these battles.

Reviews

User 624476865

1 month ago

4.7

I learned a lot on SQL logic, combination of operators applying many conditions to retrieve the wanted data

Tomas Kanuch

7 months ago

5.0

I have learned basic MySQL. Mostly using JOIN, WHERE, HAVING, GROUP BY, ORDER BY. Stage 5 and 6 were hard to solve, i ended up using CTE.

Olivier Leroy

9 months ago

4.7

Very good introduction to SQL basics including multiple tables requests. Some stages are not so easy however, and having a look at others solutions may help you identifying optimizations.

4.2

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

Usefulness

4.4

Fun

4.1

Clarity

4.0