Vertabelo Blog

Learn how to design and use database models
New SQL Course! The only interactive course for SQL window functions on the Internet. View course Discover our other courses:
Emil Drkušić 9th Aug 2017

In the first two parts of this series we have installed SuiteCRM locally, imported its model into the Vertabelo database, and created relationships based on assumptions. In Part 3 we took a closer look at the most important parts of the CRM, how to use them, and how the data is stored in the database. This article will continue where Part 3 ended and will close the series. We’ll take a closer look to other modules of SuiteCRM including campaigns, opportunities, projects, documents and users, and roles administration.

Emil Drkušić 4th Aug 2017

Visiting a hospital or a clinic is never a pleasant situation. But it would be even worse if nothing was automated. Not so long time ago almost all documents were in a paper form. That not only polluted the environment but slowed down a process a lot. In some cases, patients should take care of their medical record as well wait in the hall that somebody calls for their name. Fortunately for us, the development of the technology also had a significant impact in this area. Today we’ll take a look at the data model we could use to run one such system.

Emil Drkušić 27th Jul 2017

City-building and management games have been very popular for decades. If you were to build your own city management game, what kind of data model would you need to run it? Let’s find out.

Dorota Wdzięczna 19th Jul 2017

Knowing a foreign language is an important skill, especially in a global economy. In this article, we look at a data model that can help run a language school.

Dorota Wdzięczna 13th Jul 2017

Vertabelo In-House allows you to enjoy working with Vertabelo from the safety and convenience of your own server. It has all the same features as our cloud-based offering, so if you love Vertabelo you’ll probably love Vertabelo In-House. But you don’t have to buy it blind, as it were: you can try a version of it on your system for free using Docker.

Dorota Wdzięczna 5th Jul 2017

Vertabelo’s new SQL Script tool lets you write and save SQL scripts and run them against a connected database.

Emil Drkušić 28th Jun 2017

Shopping centers are fun to visit and complicated to run. In this article, we look at a data model capable of helping us manage a shopping center.

Emil Drkušić 22nd Jun 2017

Most of us love to travel and explore new places, and using travel agencies is an easy way to plan our holidays. With vacation season in mind, we’ll answer the question “What kind of data model would run a travel agency?”

Shantanu Kher 15th Jun 2017

E-learning (or online learning) offers people a flexible and cost-effective way to pick up new skills. What’s behind these popular portals?

Emil Drkušić 7th Jun 2017

How does the self-storage business work? Why might someone need such a service? And what kind of data model could run it?