Vertabelo Blog

Learn how to design databases with Vertabelo
 
 
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:
 
Tihomir Babic 10th Jul 2019

What kind of data model makes online concert ticketing work?

 
Emil Drkušić 26th Jun 2019

In the previous two articles of this series, we discussed how to use Python and SQLAlchemy to perform the ETL process. Today we’ll do the same, but this time using Python and SQL Alchemy without SQL commands in textual format. This will enable us to use SQLAlchemy regardless of the database engine we’re connected to. So, let’s start.

 
Emil Drkušić 12th Jun 2019

SQLAlchemy helps you work with databases in Python. In this post, we tell you everything you need to know to get started with this module.

 
Emil Drkušić 22nd May 2019

Python is very popular these days. Since Python is a general-purpose programming language, it can also be used to perform the Extract, Transform, Load (ETL) process. Different ETL modules are available, but today we’ll stick with the combination of Python and MySQL. We’ll use Python to invoke stored procedures and prepare and execute SQL statements.

 
Usman Malik 8th May 2019

Do you want to learn how to design a database system and map a business process to a data model? Then this post is for you.

 
Emil Drkušić 17th Apr 2019

SaaS (Software as a Service) is one of the three main components of Cloud computing. Usually, SaaS applications are web-based and can handle many different users at one time. Subscription-based solutions are very popular SaaS offerings. Some well-known SaaS products include Microsoft Office 365, Amazon Web Services (AWS), Slack, Jira, Stripe, and (of course) Vertabelo! Today we’ll take a look at a data model that would allow us to manage SaaS subscriptions.

 
Emil Drkušić 3rd Apr 2019

Are you forgetting something? A data model to help you remember important dates – before they happen.

 
Tihomir Babic 20th Mar 2019

What kind of data model supports an online musical equipment store?

 
Emil Drkušić 6th Mar 2019

Producing a great wine is a really complex process, one that takes many years to master. Offering and selling wines to customers is another complicated process. There are many stores specializing in only one product. If you want that product, you’ll go to that store. Wine stores are an example of what I’m talking about. What would be the data background of a wine store? Let’s find out.

 
Vertabelo Team 20th Feb 2019

There are many online portals which allow investors to lend money directly to individual borrowers – with no banks acting as intermediaries. What data model might underlie such a site?