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.
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.
Newsletter Spy does als collect meta information per newsletter:
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.
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.
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/.
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.
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.