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.
Technical
A Complete Guide to Database Diagram Symbols
15 Nov 2022
A complete guide to the symbols shown in entity-relationship diagrams (ERDs).
Although data modeling became a necessity around the 1970s, there was no standard way to model databases or business processes. Many solutions were proposed and discussed, but none were widely adopted.
Peter Chen is credited with creating the ER (entity-relationship) model, which introduced a way of mapping data model elements (which would become database elements) and their relationships. This model can serve as the diagram as well as the documentation for a database project.
Technical
Best Practices for Database Schema Name Conventions
8 Nov 2022
Assigning names to objects in your database is not a trivial task. This list of best practices for naming conventions in data modeling will help you do it the right way.
The task of designing a database schema is similar to that of creating the plans of a building. Both are carried out by making drawings in an abstract, theoretical framework. But they must be done with the understanding that these drawings will later become robust structures that support large constructions – in one case, constructions made of solid materials; in the other, constructions made of data.
Technical
Top 7 Database Diagram Tools for Linux
1 Nov 2022
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.
Technical
Designing an Amazon Redshift Data Model Using Vertabelo
25 Oct 2022
See how Vertabelo can help you design a database diagram for Redshift.
This article will show you how to use Vertabelo as a database modeling tool for Redshift. It allows you to design and implement a database model in a simple way. (Vertabelo also supports other database management systems, but in this article we’ll focus on the Amazon Redshift DBMS).
What Is Amazon Redshift? Amazon Redshift is a Cloud-based, data warehouse oriented implementation of PostgreSQL database engine designed and offered by Amazon.
Technical
A Detailed Guide to Database Schema Design
18 Oct 2022
When you don't have a guide, certain tasks seem more difficult than they really are. In this article, I offer you a complete database design guide so you won’t get lost when trying to build a robust and effective database.
A database schema is basically an abstract concept. Even so, it’s better to think of it as a practical tool that helps you create structures to turn large amounts of data into something useful.
Technical
What Is a Database Diagram?
11 Oct 2022
A database diagram is essentially an abstract graphical representation of the structure of a database. It can be used both as a tool to assist in the design of a database and as a document that shows the structure of an existing database.
You can think of a database diagram as a poster that you stick on a wall for programmers to look at when they need to know the name of a table or column.
Technical
Top 8 Most Useful Database Tools for SQL Server
4 Oct 2022
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.
