Vertabelo Blog

Learn how to design and use database models
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:
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ć 19th Apr 2017

No matter which side of the equation you’re on, sometimes it’s tough to find a qualified person for a specific job. In this post, we look at a data model to help recruiters and HR departments stay organized during the hiring process.

Marian Dziubiak 29th Mar 2017

If you were a fan of Linux and SQL Server, you basically had to have two operating systems at all times. But now, Microsoft has made a Linux version of their relational database management system. How does it work, and how well does it perform?

Emil Drkušić 22nd Mar 2017

Renting things and services today became very popular. Renting today is mostly related with travels and popular services like AirBnb rubbed the renting lamp and let the genie out. They opened new horizons and in the future we can expect that such services will became even more popular.

Shantanu Kher 1st Mar 2017

Booking a doctor’s appointment using an online app is an innovation that simplifies the entire process. Let’s dive into the data model behind an appointment booking app.

Emil Drkušić 22nd Feb 2017

Organizing an event is a lot of work! In this article, we examine the data model behind an event organization app.

Emil Drkušić 15th Feb 2017

Other than location, what’s it take to run a successful real estate business? We examine a data model to help real estate agencies stay organized.

Francisco Claria 10th Feb 2017

What is MySQL partitioning? What kind of partition types are there? How do you know if this is something your database engine supports? In this article, we tell you what you need to know about partitioning in MySQL.

Shantanu Kher 1st Feb 2017

Being healthy and fit is a lifestyle, not a fad. People who realize the value of health make it a priority, keeping records of all their fitness-related facts. In this article, we’ll examine the design of the database behind a health and fitness application.

Jeffrey J. Keller 25th Jan 2017

The first two articles in this series highlighted SQL Server’s ability to organize data into user-defined windows and its aggregate functions. Part 3 will focus on other methods of aggregating and organizing data using built-in SQL Server features – specifically, its grouping functions.