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
It's been already 100 days since we launched Redgate Data Modeler. There is already 1000 satisfied Redgate Data Modeler users. Thank you for your trust and interaction! Read more
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
The kata Imagine: it’s 1968 – the Beatles, Carnaby St and Austin Powers – except there’s all the technology of 2013 as well. Including vending machines. But, being 1968, vending machines have to deal with old money. It’s quite simple; I’ll describe it here. Money is made up of pounds (£), shillings (s) and... Read more
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
In this video tutorial for beginners, you will learn about table columns and the most commonly used data types. Read more
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
First part of our Database Design 101 series that brings you an easy-to-understand introduction to databases. Read more
A good data modeling exercise for beginners is to create a data model of an online store. Every time I give this exercise to my students, I'm surprised at how difficult it is for them.
Let's see how it can be done. We know we have to create a table for every concept in... Read more
The newest Redgate Data Modeler feature is Reverse Engineering: a way to import an existing database into Redgate Data Modeler. The Reverse Engineering tool is a simple command-line Java application that you can download from our website. It connects to your database, reads the table and view details and stores the info in an... Read more
