Author: Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.

What Is the Team Account in Vertabelo? What Are Its Benefits?

Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.
Like many other software and database development activities, data modeling is a collaborative endeavor —perhaps even more so than the others. In addition to ensuring that they avoid anti-patterns and follow the best data modeling practices, data modelers also need to facilitate the swift and agile development of the data model. For that, there needs to be a way to collaborate on the data model design process. Although Vertabelo’s basic and premium plans are enough for individuals, teams may require a bit more.

How to Generate Documentation in Vertabelo

Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.
Entity-relationship diagram (ER diagram) documentation is an important part of any database project. Find out how to use Vertabelo to generate database documentation from SQL. Writing good documentation is as hard as writing good code. Some say that teams who don’t invest in good documentation early on pay a high price later. Databases and data warehouses are central to business applications. Just like an application mandates good reference documentation for APIs, SDKs, repositories, etc.

How to Align Elements in Vertabelo

Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.
An ER diagram that’s not easy to read isn’t much help. Learn how to align ERD elements – and better organize your diagram – in Vertabelo’s online data modeler. Designing great ER models is not just about creating the right tables, defining the correct data types, and adding references. To make the model readable and easy to understand, you should arrange it neatly. This is where the alignment and distribution of the different ER diagram elements (tables, reference lines, notes, subject areas, etc.

Vertabelo’s Shortcut Tables and How to Use Them Effectively

Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.
Complex database models are challenging to read and manage. In Vertabelo, you can use many different techniques, including color-coding tables and encapsulating groups of tables in subject areas. Doing this will increase the model’s readability, making it easier to navigate and search within it. A complex data model can be organized using subject areas. Subject areas in Vertabelo are named rectangles that group tables based on a functional or business context.

Vertabelo Feature: How To Organize Your ERD Diagram in Vertabelo

Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.
Better model organization will help you get work done faster. It will become easier to find objects in the model and to onboard new people to the team. In this article, we will give you tips and show you Vertabelo features that will help you effectively organize a large ERD. Sample ERD To discuss entity relationship diagram (ERD) organization, we will be using a recruitment system database model. By the end of this article, you will be able to make this model much better organized and more readable.

How to Generate a Migration Script in Vertabelo

Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.
Database migration scripts make it possible to move from one version to another. Learn how to generate SQL migration scripts quickly and easily with the Vertabelo data modeler. Databases evolve; as applications mature over time, new features get added and existing features get modified. Consequently, just like the application source code, the database also needs to move from one version to the next. This movement is called database migration. It is one of the most common tasks given to database engineers.

What Are the Steps in Database Design?

Kovid Rathee

Kovid is a Data & Infrastructure Engineer working as a Senior Consultant at Servian in Melbourne, Australia. He is originally from Rohtak, India. In a career spanning 10 years, he has worked for startups and corporates, product companies and service companies alike. He started his career as an Assistant Professor at an engineering college and later moved to a full stack developer role for a while, before finally moving into the data space where he has been working for the past 8 years. He likes to write about data engineering, infrastructure-as-code, DevOps and SRE. He is a semi-trained Indian classical singer, writes poetry in Hindi and Urdu, and hopes to get published someday.
Database design is one of the most important factors contributing to the performance of an application. Consequently, how well the database is designed is of utmost importance. Database design is all about efficiently organizing data based on product workflows, future roadmap, and expected usage patterns. The output of a database design exercise is a data model. A data model represents all the objects, entities, attributes, relationships, and constraints in the system.