Relational Database Design

by Hugo Kornelis

This course is for anyone who wants to understand relational database design, or data modeling in general. You will learn how to gather requirements, model them, normalize the model, and transform that model into a fully normalized relational database design.

What you'll learn

In this course, you will learn all the skills required to design good relational databases. This starts with information gathering: how to find all required information, and how to ask questions without miscommunications. You will learn how to abstract the information gathered into a data model, how to normalize the data model so that your database will be free of anomalies, and how to transform the final, normalized data model into a relational database design - ready to be implemented.

Table of contents

Course FAQ

What are the main types of database models?

There are many types of database models, but some of the more popular ones are the relational model, network model, object-oriented model, and Hierarchical model

What is relational database design?

Relational database design, or RDD, is the process of formatting information and data into various tables, each with rows and columns. The columns define an attribute of the data and the rows indicate individual records. Relational databases are edited and revised through use of SQL - Structured Query Language.

About the author

Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums; reading and writing books and blogs; and attending and speaking at conferences. Hugo is a SQL Server M... more

Ready to upskill? Get started