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.
From July 08 to July 10, 2022, a hackathon on the topic of Smart City took place in Wolfsburg, Germany during their DigiWeek.
During the event, we supported a team that developed a concept for a Smart Grid. In the Smart Grid called WOBG, the entire parking areas of Volkswagen will be covered and then equipped with photovoltaic panels. E-charging stations will be placed directly next to the parking spaces. E-charging stations and panels are connected to the same sub-distributors. Thus, on the one hand, the vehicles can be charged directly by solar energy. On the other hand, they can also act as a giant battery themselves. For example, load peaks in the power grid can be absorbed or car batteries that have not yet been charged can be charged proportionally. In particular, the delivery of battery power to the grid was considered. Car owners are remunerated if their vehicle delivers power to the smart grid as a battery.
This task involves developing a database model for the smart grid to manage PV panels and charging stations and to track charging and discharging cycles of car batteries in a centralized way. To do this, take a look at how solar power systems are set up.
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.