Relational Database Design
4.3 (286 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,113 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Relational Database Design to your Wishlist.

Add to Wishlist

Relational Database Design

Learn how to create an effective relational database design to use in your IT career or even a personal project.
Bestselling
4.3 (286 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,113 students enrolled
Created by Ben Brumm
Last updated 9/2014
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to design a relational database
  • Learn what normalisation is, and each of the three normal forms
  • Start designing a database from nothing
  • Learn how to identify tables, and how to create relationships
View Curriculum
Requirements
  • Internet connection
  • Ability to download software (or a preferred data modelling tool)
  • Windows, Mac or Linux (chosen software works on all three)
  • Willingness to learn about designing a quality database, and not just putting data into tables!
Description

Learn how to design a proper relational database with this course!

This course will teach you how to create an effective relational database design using proven concepts and industry knowledge.

Effective database designs will help make systems faster, improve data quality, and ensure future changes are easier.

If you want to improve your software development career, get into database admin or database design, or are just curious on this topic, this course is for you.

You don't need to know SQL or have any programming experience to be able to take this Relational Database Design course.

This course includes:

  • Almost three hours of video lessons
  • Included PDF files of the database diagrams at keys steps will help you learn all about database design.
  • The topics covered include normalisation and the normal forms, identifying tables and columns, primary and foreign keys, and setting up relationships.

The videos include explanations of the key topics in the process, as well as demonstrations on how to set up a database using an Entity Relationship Diagram.

I also show you how to download and install the software that is being used for this.

What topics are covered in this database design course?

The topics covered are:

  • We'll walk through a sample database
  • Reason or why the database is needed
  • Some advantages of relational databases
  • Identify entities for the tables and attributes
  • Create tables and columns
  • Reorganise them to make the layout and design more efficient.


If you want to know how to design a database and improve the overall quality of your databases and software, then this is the course for you.

You'll learn all you need to be able to design an effective database!

Who is the target audience?
  • Software developers or web developers
  • Students wishing to know more about database design
  • Those looking to get into a database role
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
02:28:06
+
Introduction
4 Lectures 10:34

Welcome to the course! I'll show you what's included and what you will learn.

Preview 03:54

An outline of a few things you should know before starting the course.

Preview 00:48

You'll need a few tools for this course. They're all free though!

Preview 02:23

Instructions on how to download and install MySQL Workbench, which is used to prepare a data model diagram.

Preview 03:29
+
Database Basics
2 Lectures 05:18

Information on what a database is and what it's used for.

What Is A Database?
02:49

A description of different types of databases, including the relational database.

Different Types of Databases?
02:29
+
Relational Databases
6 Lectures 16:31

An advantage of a relational database means you can store data for each component.

Store Data for Each Component
02:29

Another advantage of relational database is that it removes duplicate information.

Removes Duplicate Information
02:49

Another advantage means that you can ensure records are complete.

Ensure Records are Complete
01:52

Another advantage is that you can prevent inconsistent and conflicting data.

Prevent Inconsistent and Conflicting Data
04:41

Another advantage of a relational database means you can easily combine different data sets.

Combine Different Data Sets Easily
02:29

You can increase the security in a few ways with a relational database.

Increased Security
02:11
+
Data Modelling Process
5 Lectures 19:47

An explanation of what data modelling is, and what the database design process is.

What Is Data Modelling And The Design Process?
03:30

The first step is to determine the goal of the database.

Determine The Goal Of The Database
03:17

We sometimes need to consider the current system in our database design.

Consider the Current System
03:33

How to gather the requirements for creating your database.

Gathering Requirements of the Database
04:08

Exceptions to rules may exist, and we need to consider them.

Finding Exceptions to the Rules
05:19
+
Database Design
9 Lectures 01:16:11

Instructions on how to identify entities for your database.

Identifying Entities
08:28

We look at how to define the attributes for our entities.

Defining the Attributes
10:04

Learn what normalisation is and what is involved.

Normalisation
02:39

An explanation of first normal form and applying to our sample database.

First Normal Form - Part 1
09:29

Continue to apply first normal form to our database.

First Normal Form - Part 2
09:32

An explanation of different types of relationships.

Relationships
03:25

An explanation of second normal form, and how to apply it to our sample database.

Second Normal Form - Part 1
09:54

Continue to apply second normal form to our database.

Second Normal Form - Part 2
12:53

An explanation of third normal form, and how to apply it to our sample database.

Third Normal Form
09:47
+
Design Considerations
4 Lectures 16:27

Learn about data types and precision, and why they are important to a database.

Data Types and Precision
06:36

Explanation of what integrity constraints are.

Integrity Constraints
02:52

Naming conventions are important for a good database design.

Naming Conventions
03:24

Explanation of what lookup tables are and what auditing can be done on a database.

Lookup Tables and Auditing
03:35
+
Conclusion
1 Lecture 03:18

How to implement this database, and what your next steps are.

Implementation and Next Steps
03:18
About the Instructor
Ben Brumm
4.3 Average rating
343 Reviews
7,123 Students
2 Courses
IT Software Consultant

I'm a software consultant that has a passion for databases, and teaching others. I have over seven years experience in the IT industry in many roles, including database support, database development, database design, reporting, business analysis, project management, and even Excel.

I obtained the Oracle SQL Expert certification and currently looking into the next certification on my list!

I'd like to teach others about databases and database topics, such as SQL, database design, and performance.