Vertabelo Blog

Learn how to design and use database models
 
 
RSS
 
 
 
 
 
Vertabelo Academy It's time to speak the new lingua franca of the Web! Online Course ● Tons of Exercises ● Designed for Beginners DETAILS Check our other courses:
 
Emil Drkušić 15th Nov 2018

In the previous two parts, we’ve presented the live database model for a subscription-based business and a data warehouse (DWH) we could use for reporting. While it’s obvious that they should work together, there was no connection between these two models. Today, we’ll take that next step and write the code to transfer data from the live database into our DWH.

 
Emil Drkušić 24th Oct 2018

Can you design an OLAP database model from an OLTP model? In this article, we’ll show you how!

 
Emil Drkušić 14th Sep 2018

Welcome to a new series that shows you the practical side of the data warehouse (DWH)! In the first article, we’ll tackle a data model for a subscription business.

 
Emil Drkušić 24th Jul 2018

Spreadsheets – Excel, Google Sheets, or a sheet by any other name – are really cool and powerful tools. But then, so are databases. When should you stick with a spreadsheet? When should you move up to a database?

 
Emil Drkušić 28th Jun 2018

Spreadsheets – Excel, Google Sheets, or a sheet by any other name – are really cool and powerful tools. But then, so are databases. When should you stick with a spreadsheet? When should you move up to a database?

 
Emil Drkušić 13th Jun 2018

There isn’t much chance you’ve missed the whole idea of the sharing economy – whether you like it or not. Popularized by companies like Airbnb, Uber, Lyft, and many others, it lets people earn some cash by renting out their unused stuff. Let’s see the data model behind such an application.

 
Emil Drkušić 21st May 2018

If there’s a way to order groceries online, why not use it? This article examines the data model behind a grocery store’s delivery system.

 
Emil Drkušić 29th Mar 2018

Organizing children's parties is not an easy job: everything has to be perfectly planned and delivered. Otherwise, chaos happens. It’s up to the adults – more specifically, the party planners – to take care of everything and do it properly.
Is there a better way to do this than to organize everything in a database? We don’t think so!