Vertabelo Blog

Learn how to design databases with Vertabelo
 
 
RSS
 
 
 
 
 
New SQL Course! Learn the basics of T-SQL for SQL Server, retrieve data from an SQL Server database and build simple reports. View course Discover our other courses:
 
Emil Drkušić 12th Dec 2018

You’ve probably made some of these mistakes when you were starting your database design career. Maybe you’re still making them, or you’ll make some in the future. We can’t go back in time and help you undo your errors, but we can save you from some future (or present) headaches.

 
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ć 9th Oct 2018

Databases need to run optimally, but that’s not such an easy task. The INFORMATION SCHEMA database can be your secret weapon in the war of database optimization.

 
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.

 
Vertabelo Team 29th Aug 2018

Do you dream of running a marathon? Let’s look at the data model for an app that could take you from lazy couch potato to marathoner.

 
Vertabelo Team 2nd Aug 2018

Board games like dominoes are still very popular. Let’s take a look at dominoes from a data modeling point of view.

 
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.