Project
Computer Store Database
Easy
259 completions
~ 6 hours
4.1Learn 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
1 month ago
Here I practiced select statements with aggregate functions, joins, sub-queries, Common Table Expressions and unions. It was a little annoying that one has to write table names with first character capitalised
8 months ago
I have learned basics MySQL and working with DB. Stage 3 and 4 were difficult for me.I used mostly WITH, HAVING, GROUP BY, JOIN, UNION, WHERE and basic aggregate functions like COUNT, MIN.
4.1
Learners who completed this project within the SQL for Backend Developers course rated it as follows: