Get exceptionally good at modelling database schemas by modelling one real-world requirement a week.
Get practical exercises from our experts who have modelled databases and did software architecture for
top companies and projects.
Those exercises range from defining a database schema of World of Warcraft's DKP system up to modelling a part of Twitch's database.
Create the database model based upon the requirement once a week before you get the solutions in the next morning.
Verify your database schema model and get better at database modelling.
The user should be able to manage testimonials of his customers. For this purpose, it should be possible to store the following data for a testimonial:
The customer should be able to specify whether the name of the person, the content, and the company logo may be used on the website or in social media.
In addition, it should be possible to define in which sources (e.g. website URLs) the testimonial is actively used.
With a lifetime premium access you can check your solutions against our database schema blueprints. As soon as we are adding new exercises, you'll receive them.
Our solutions contain an ER diagram and an annotated database schema with possible pitfalls and our
design decisions explained.
You can find sample solutions in our blog.
All database modelling exercises are built for ongoing software developers, like trainees or students.
In Germany, those exercises are a central part of the final exams for the Fachinformatiker
(software development) training.
If you have just started with software development, you'll be probably overwhelmed. The exercises are not about learning SQL but learning how to model database schemas for a variety of requirements. For PostgreSQL-related SQL exercises you should visit https://pgexercises.com/.
After educating software developers for more than 15 years, we strongly believe that a high skill in data and database modelling makes software developers better in their job.
Our target audiences are trainees and students who don't have time to learn database schema modelling each day. All of the exercises allow you to extend them with your own ideas and requirements.
No. We are trying to keep ahead with our exercise pool, but designing exercises takes time. After you have exceeded the pool of exercises, you will have to wait until we add new exercises.
The original idea for this service comes from TechLead's dailycodingproblem.com. He has implemented a daily newsletter for interview questions. As you can see, I've been inspired by his product to realize this service.