Project

Hacker Attack

Medium

138 completions

~ 7 hours

4.4

Get familiar with SQLite commands, and work with csv files. Import data from files, learn how to merge data from different tables, and study how to use various SQL commands.

Provided by

JetBrains Academy

About

A hacker has attacked the IT system of your school and destroyed the database. As a leader of the Science Club, your school has asked for your help. The situation is grave. There is only one week before the final annual exams. You need to recover the annual scores of the students. The school management provides the data from the archive, and the Science Club members help you with csv files. Your task is to create the school database and calculate the annual score.

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:

Create your first table that contains teachers and students.

Find out who the students are.

You listed the students. Time to create the student table.

Your friends created score files for you. Merge the scores and display them.

You listed the scores, now create the score table.

Find out the grade code of the students and update the student table.

For last-year students, calculate the annual scores and display them.

Reviews

Tomas Kanuch

7 months ago

4.3

I have learned working with SQLite syntax: create table, insert into table, drop table, update table, simple aggregate functions COUNT, AVG. Also simple queries with UNION, JOIN, CASE,..

Mauro Gonçalves

1 year ago

5.0

This project provided a great opportunity to practice various essential SQLite commands and SQL statements.

Joydeep Chatterjee

1 year ago

5.0

A great introduction to SQLite with clear steps and quality learning value.

4.4

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

Usefulness

4.6

Fun

4.4

Clarity

4.3