How it works

1. We Write Requirements

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.

2. You Model Them

Create the database model based upon the requirement once a week before you get the solutions in the next morning.

3. We Send The Solution Premium

Verify your database schema model and get better at database modelling.

Sample modelling exercise

Exericse: Customer testimonials - Part 1

2021-12-25

After reading Jonathan Stark's blog post Building The Perfect Testimonial I decided to add such a feature to our kwilo app.

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 name of the person who gave the testimonial.
  • The content of the testimonial itself.
  • The date of the 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.

FAQ

For whom are these exercises?

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.

Why only one exercise per week?

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.

Do you guarantee an exercise for a week for the whole lifetime?

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.

Are there more of such services?

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.