Project
Rhythm Store
Medium
24 completions
~ 10 hours
4.5Learn the basics of SQL. Test yourself in a series of challenges, from simple to complicated. The project uses the SQLite syntax.
Provided by
JetBrains Academy
About
Managing an e-commerce site can be complex, involving tracking orders, products, employees, and other vital data. While ledger-keeping was an option half a century ago, modern databases have now taken over. Are you interested in testing your skills with complex queries using an e-commerce database?
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:
Delete users registered with the same email.
Find the users who have never placed an order.
Find the best-selling albums in the database.
Find the playing time of all playlists.
Find the best-selling artists.
Find the fans of the best-selling artist.
Reviews
6 months ago
Great introduction on how to use CTEs and window functions to slice the data that is needed.
2 years ago
I have learned basic to intermediate and even some advanced SQL topics by implementing it in a real world project. I covered subqueries, grouping, ordering, LIMIT, JOIN, ROUND and other important SQL concepts.
4.5
Learners who completed this project within the Databases with SQL and Python course rated it as follows: