Redgate Blog

Posts by

Redgate Data Modeler

13 March 2014

On Keys

Today we continue our series of posts on data normalization. In the previous post on data normalization I explained what functional dependency is. Today we will talk about candidate keys in a table. Read more

Redgate Data Modeler

7 March 2014

Redgate Data Modeler

7 March 2014

On Functional Dependencies

Do you remember the ? I promised you we'd explain how to design tables which have no update anomalies. Today we begin a series of posts on data normalization. We will talk about functional dependencies, a concept that needs to be explained before we dive deeply into database schema normalization. The subject is rather abstract... Read more

Redgate Data Modeler

28 February 2014

Redgate Data Modeler

28 February 2014

Update Anomalies

In this article I will show you an example of the table that looks correct at first glance but when you try to modify data in it, several anomalies can occur. We'll discuss insert anomalies, update anomalies and delete anomalies. Read more

Redgate Data Modeler

21 February 2014

Redgate Data Modeler

21 February 2014

How to Create a Database Model From Scratch

So you want to create your first database model but you don't know how to start? Read on! I assume you already know a little about tables, columns, and relationships. If you don’t, watch our video tutorials before you continue. Read more

Redgate Data Modeler

10 February 2014

Redgate Data Modeler

10 February 2014

1000 users and growing strong!

It's been already 100 days since we launched Vertabelo. There is already 1000 satisfied Vertabelo users. Thank you for your trust and interaction! Read more

Redgate Data Modeler

6 February 2014

Redgate Data Modeler

6 February 2014

Database Design 101: References

In this third part of our Database Design 101 series you will learn about references – how to create a relationship between the tables, how it affects their structure, and how it looks in the data. Read more

Redgate Data Modeler

28 January 2014

Redgate Data Modeler

28 January 2014

WordPress Database Finally Unveiled!!!

Sorry for that tabloid title, but I couldn't resist. I'm going to show you how to view the database design of other people’s systems. It will work for legacy systems as well. Of course, you may call show tables and describe table in the database console but that’s a very rudimentary way to examine the structure. You'll miss... Read more

Redgate Data Modeler

28 January 2014

Redgate Data Modeler

28 January 2014

Database Design 101: Tables, Columns, and Data Types

In this video tutorial for beginners, you will learn about table columns and the most commonly used data types. Read more

Redgate Data Modeler

24 January 2014

Redgate Data Modeler

24 January 2014

Designing a Database: Should a Primary Key Be Natural or Surrogate?

Suppose we design a database. We've created some tables, each one has a few columns. Now we need to choose columns to be primary keys (PK) and make references between tables. And here some inexperienced designers face the dilemma – should a primary key be natural or surrogate? There's one and only one answer to... Read more

Redgate Data Modeler

23 January 2014

Redgate Data Modeler

23 January 2014

Database Design 101: What is a Database

First part of our Database Design 101 series that brings you an easy-to-understand introduction to databases. Read more

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Blog

Posts by

Redgate Data Modeler

On Keys

On Functional Dependencies

Update Anomalies

How to Create a Database Model From Scratch

1000 users and growing strong!

Database Design 101: References

WordPress Database Finally Unveiled!!!

Database Design 101: Tables, Columns, and Data Types

Designing a Database: Should a Primary Key Be Natural or Surrogate?

Database Design 101: What is a Database

2025 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Posts by Redgate Data Modeler

Posts by

Redgate Data Modeler