Project

Battleship Database

Easy

69 completions

~ 6 hours

4.3

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

Olivier Leroy

7 days 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.

Bojan Gjokjevski

1 month ago

4.7

I have learned MySQL beyond just the basics, and also how to use AI support in the process.

Jonatan Luna Franco

3 months ago

5.0

I have learned about basic SQL statements and delved deep into theory to reinforce my knowledge of subqueries and other SQL functions. This was a great project. Initially, I felt confident, but it became increasingly challenging with each stage.

4.3

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

Usefulness

4.5

Fun

4.2

Clarity

4.1