Project
Computer Store Database
Easy
218 completions
~ 6 hours
4.2Learn to write basic queries on MySQL and master the SELECT, FROM, GROUP BY, and WHERE clauses, including summation functions, logical operators, and comparison operators. It will help you learn basic information retrieval in SQL.
Provided by
JetBrains Academy
About
As the manager of the computer hardware shop, your primary responsibility is to retrieve data from the existing database efficiently. Accurate data retrieval is crucial for creating reliable financial documents, accounting records, and business reports.
Graduate project
This project covers the core topics of the SQL for Backend Developers course, making it sufficiently challenging to be a proud addition to your portfolio.
At least one graduate project is required to complete the course.
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 expensive printers in the database
Find the manufacturer that produces laptops with balanced memory and speed specifications.
Discover the producers that specialize in creating single products.
Find a producer that outputs the slowest laptops or PCs
Reviews
3 months ago
I have learned basic SQL functions and new ways to get the necessary information.
4 months ago
I have been writing this code outside of Hyperskill platform and then copying it here. It was a nightmare, but I've learned a lot. 1. One needs to find a proper database manager that will cooperate without too much complaining. 2. It's not so easy to remember the syntax of all functions so it will t ...
4 months ago
Share feedback on the projectProject: Computer Store DatabaseThink about what you've learned in the projectStep 1/2 ...
4.2
Learners who completed this project within the SQL for Backend Developers course rated it as follows: