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

Newsletter Spy

2021-09-03

Newsletter Spy is a database of more than 100.000 newsletters.

Each newsletter has a title, a description, an author's name with his email address and a URL. A newsletter is written in a specific language and belongs to a category and an industry. Main information Main information 2

Newsletter Spy does als collect meta information per newsletter:

  • the type of Email Service Provider (ESP) like Ghost, ConvertKit or MailerLite which is used
  • The fame ranking between "High", "Medium" and "Low"
  • The buzz ranking between "High", "Medium" and "Low" Categories

Each newsletter has number of issues. An issue can be either of type newsletter, podcast or thread. A newsletter issue has a date and an optional title. For issues of type podcast there can be also a duration with the length of the podcast.

Issues

Other meta data like Number of comments, Number of reactions and Paid ratio are not part of this exercise.

With a premium subscription you can check your solutions against our schema blueprints. You can choose between a one-time payment or a monthly or yearly subscription.

 

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.

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.