Project

Electronics Store Customer

Easy

158 completions

~ 7 hours

4.3

Starting with basic SQL operations like SELECT, FROM, GROUP BY, and WHERE, we'll explore summation functions, logical operators, and comparison operators and advance into more complex concepts like window functions, subqueries, and join statements. This learning journey will empower you with the skills necessary for proficient information retrieval in SQL.

Provided by

JetBrains Academy

About

As a customer of an electronic store, the main objective is to utilize the store's interface to acquire information. This will assist in discovering the most functional and affordable devices that match the individual's specific requirements and preferences.

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 fast PCs in the database

Find the average price of inkjet color printers

Find the total price of each laptop maker.

Find the makers that produce both PCs and laptops.

Find laptop models priced higher than the most expensive PCs.

Find the second most cost-effective PCs for each specific RAM value.

Reviews

Koppány Köllő

5 months ago

4.3

i have learnd a lot of thing about sql and it was difficult for me

Vaibhav

6 months ago

4.0

i have learn something but windows functions need more clarification.

Akbar Hamaminatu

6 months ago

5.0

I have learned the fundamentals of working with databases. I explore basic SQL operations and the MySQL system.

4.3

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

Usefulness

4.6

Fun

4.2

Clarity

4.2