ProjectBeta

Video Game Database

Hard
272 completions
~ 12 hours
4.1

You will learn how to use basic SQLite commands (DDL, DML, DQL) to build, sort, relate data, and manage and extract information from an SQL database.

Provided by

JetBrains Academy JetBrains Academy

About

One day, you, a renowned SQLite expert, are minding your own business in your office when suddenly, there is a knock on your door. It is a private detective who wants to hire you for an urgent case—the disappearance of a well-known game developer. The developer left some diary excerpts and a random shapeless tangle of cells and columns with video game information. Only you, with your unique abilities, can decipher the riddle in the data in time to save the guy. Time is running out, and a person's life may be at risk.

Training project icon

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:
Let's start getting our hands dirty. Create the necessary structure to receive the available data into the database: the tables, columns, names, and respective data types.
Clean up the redundant information to save space in memory and change data types to more convenient SQL data types to support queries in the database.
To uncover the mystery, retrieve some helpful information from the database using the SELECT and SELECT FROM statements. Using more advanced SQL resources, let's do more interesting queries using JOINS, GROUP BY, logic and comparison expressions, and sort results.
We have more excerpts from the diary to analyze and more complicated SQL statements.

Reviews

Mauro Gonçalves avatar
Mauro Gonçalves
7 months ago
The project showed me the practical importance of database design and how to maintain data integrity. I also gained valuable experience with joining tables and using aggregation functions to extract meaningful insights from the data. These skills will be useful for any future projects requiring data ...
Vaibhav Sareen avatar
Vaibhav Sareen
1 year ago
Good Project to refresh your SQL skills which will be later used in projects related to Flask.
Konstantinos Gioldasis avatar
Konstantinos Gioldasis
1 year ago
Nice practice with aggregate functions, limit and joining tables. Recommended

4.1

Learners who completed this project within the Databases with SQL and Python course rated it as follows:
Usefulness
4.6
Fun
4.1
Clarity
3.7