Author: Shamal Jayawardhana

Shamal is a senior software consultant and educator with 20+ years of experience. He has an MBA from London Metropolitan University and a graduate diploma in IT from the British Computer Society. He also holds professional certification from the Australian Computer Society. Shamal hails from Sri Lanka and loves listening to English, Spanish, and Sinhalese songs.

How to Create a Database Diagram in SQL Server

Learn how to create a database diagram using a data modeling tool for SQL Server. Microsoft SQL Server is one of the most popular database management systems (DBMS) among database developers. It’s used by many large organizations for a variety of databases. So, it is worth learning how to create a database diagram in SQL Server. A perfect database starts with a great database model. If the database is a skyscraper, the data model is the foundation.

Top 7 Database Diagram Tools for Linux

What is the best database diagram tool for Linux? This post will help you find out – and potentially save you time, frustration, and money! Data modeling is a crucial component of any database development project. Your database project could fail if you move forward without a suitable data model. You can learn more about why you need data modeling here. It's crucial to select the best ER diagram tool for your project.

Top 8 Most Useful Database Tools for SQL Server

Is creating complex SQL Server databases a challenge? Read on and discover our top SQL Server database tools. In this modern era, databases have become essential. So, database development has become a most common and vital part of the software development world. Microsoft SQL Server plays a significant role here; it’s one of the most popular Database Management Systems (DBMS) among database developers. This article will discuss 8 of the most useful database tools for SQL Server developers.

Create an Online Data Model in 4 Steps

Learn how to use four simple steps and a data modeling tool to create a database diagram online. Creating database diagrams (aka data modeling) is an essential part of modern database development projects. A good data model is to a database what a strong foundation is to a skyscraper. Due to the availability of modern data modeling tools, this has become a straightforward process. What Is Data Modeling? Data modeling is the process of identifying and graphically representing the data elements and entities along with their attributes, relationships, operations, etc.

Best Database Modeling Tools for Redshift

Amazon Redshift has become one of the most popular Cloud databases. Which database diagram tools are the best for Redshift? Let's find out! Redshift is Amazon's Cloud-based database system. First announced in 2012, Redshift is a data warehouse product designed for analytical systems. It can handle huge volumes of data – up to 1 petabyte (1024 TB). It is considered a DaaS (Database as a Service) solution and is part of the Amazon Web Services (AWS) Cloud ecosystem.

Top 7 Database Schema Design Tools

Database schema design tools are essential in your toolkit if you are a database professional. Your database development journey begins with these tools. Let's read on to find out the top database schema design tools. This article lists my top database schema design tools with their key features. These tools are important since we start our database development journey with data modeling using a database design tool. Data modeling is a step-by-step process of arranging data entities in an information system, starting from concepts up to building your physical database.

What's the Best Database Modeling Tool for Students?

Hey students! Are you searching for a data modeling tool you can use to explore the world of databases? Read on and find out the best data modeler options for you. Data modeling is analyzing, identifying, and graphically presenting the data involved in a business process. It’s used  to develop a database system. The three phases most models go through are conceptual, logical, and physical data modeling. Although several diagrams can be used to draw a data model, the Entity-Relationship Diagram (ERD) is the most common choice.

What's the Best ER Diagram Tool for Oracle?

Want to start your next Oracle database project? Find out the best Oracle ER diagram tool and save yourself some time and extra work! Oracle is one of the best and most popular database management systems (DBMSs) in the world. Many database architects prefer to use Oracle because of its easy networking and interaction, cross-platform service, simple administration and maintenance, and other benefits. On the other hand, an ER diagram (entity-relationship diagram) is an essential tool for data modeling.

What ERD Tools Can I Use to Create an ER Diagram?

As a database professional, the ER diagram should be an essential part of your toolkit. In this article, we’ll briefly examine data modeling and which ERD tools best meet database design requirements. What is data modeling, and how does an entity-relationship diagram (ER diagram or ERD) support it? 'Data modeling' is the process of arranging all the related data in an information system graphically, starting from scratch and going step by step through different phases to develop the physical database.

The Best ER Diagram Tool for Mac Users

Are you a data modeler who uses Mac OS? Read on and find out the best ERD tool for Mac. Data modeling is an essential part of your database development project. Choosing the best ER diagram tool for your project is critical. If you proceed without a proper data model, your database project may fail. You may want to read more about why you need data modeling. There are hundreds of tools available as online ER diagram tools, desktop ERD tools, or both.