Technical
How to Create a Database Diagram in SQL Server
17 Jan 2023
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.
Technical
Top 23 Database Schema Design Interview Questions
10 Jan 2023
Got a job interview coming up? If you know you’ll be talking about database design, make sure you can answer these questions on database modeling and schemas.
Job interviews typically cover core knowledge areas, but the interviewer also often throws in some questions on tricky topics. We’ll help you prepare by going over these common database schema design questions that cover both basic and more advanced topics.
Basic Database and Data Modeling Questions The following database schema design interview questions can be considered basic or beginner level.
Technical
ER Diagram Cheat Sheet
3 Jan 2023
An ER diagram is a database blueprint. It facilitates data visualization and database development processes. Read on to find out what ER diagrams are and how to create them in Vertabelo.
In this article, we’ll explain what an ER diagram is and what elements it contains. We’ll discuss ER diagram abstraction levels, such as conceptual, logical, and physical diagrams. You’ll learn how to build ER diagrams using various notations, such as Crow’s Foot notation, Barker’s notation, and more.
Technical
7 Tips to Improve Your Database Diagram Layout
27 Dec 2022
A neat, well-organized database diagram is more than just eye candy. It can also increase team productivity by facilitating the understanding of a data model and reducing meeting and training times.
A database diagram serves multiple functions. On one hand, it is the foundation for creating the structure of an operational database in a database management system. On the other hand, it is a communication, documentation, and guidance tool that must endure and evolve over time.
Technical
Top 6 Online Database Schema Design Tools
20 Dec 2022
Why do you need a database model? And what tools are available to help you in the database design process? We review the best online database schema design tools in this article.
One of the key tasks in the software development cycle is data modeling. Creating a good data model allows us to save costs and speed up development, as explained in the article Why Do You Need Data Modeling?
Technical
7 Useful Database Diagram Examples
13 Dec 2022
Don’t suffer from blank sheet syndrome when you have to create a new data model. Explore the ready-to-use database model examples we offer here and you will surely find the inspiration you need to kickstart your design.
When you have to create a data model to solve a need common to many businesses, it is almost certain that many designers have done it before. You can learn from what they have done so that you don’t have to reinvent the wheel.
Technical
New Vertabelo Feature: Document-Oriented Vertabelo API
12 Dec 2022
One of the signs of a decent SaaS solution is its public API. A good API helps users to incorporate some automation into an application.
Based on our experience in using other SaaS services, we have introduced a more document-oriented version of our public API. In this article, we will demonstrate how to use Vertabelo API to fetch a list of documents (models), SQL scripts, and data models in various formats.
Technical
What Is a DDL Script? How Do You Use It?
6 Dec 2022
What is a DDL script and why is it so crucial for systems that use relational databases?
DDL scripts are widely used in creating, documenting, and migrating systems that use relational databases. They can be designed for simple tasks, such as migrating a database from one server to another, or for more complex tasks.
DDL scripts are read sequentially and are written in SQL with commands specific for defining data structures (CREATE, ALTER, and DROP).
Technical
Top 8 Database Schema Design Tools
29 Nov 2022
Database modeling is the first and most crucial step in creating a database. Read on to find out about our favorite database diagramming tools.
In this article, we’ll talk about database modeling and why you need data modeling in the first place. Then we’ll introduce several database modeling tools that facilitate database schema design, including:
Online database modeling tools: Vertabelo SqlDBM DbDio SqlDBD Standalone applications for database modeling: Navicat ERBuilder SQL Developer Data Modeler MySQL Workbench The database design process is more than just creating an entity-relationship diagram, or ERD.
Technical
How to Generate a Snowflake Database Model DDL
22 Nov 2022
In this article, we will see how to use Vertabelo to create a Snowflake DDL script. We’ll start from a data model created online and walk you through the process of generating the SQL script that will create the physical database.
Vertabelo is a powerful yet easy-to-use data modeling tool that can help you create database models for many database engines, including Snowflake.
What Is Snowflake? Snowflake is a Cloud-based Database-as-a-Service designed by former Oracle engineers.
