Database Design Introduction
4.3 (3,027 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,544 students enrolled

Database Design Introduction

Prevent typical developer mistakes by learning how to properly create and normalize a relational database
4.3 (3,027 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,544 students enrolled
Last updated 10/2016
English
English, Arabic, 8 more
  • French
  • German
  • Hindi
  • Japanese
  • Portuguese
  • Russian
  • Simplified Chinese
  • Spanish
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • What is a database
  • Understand different types of databases
  • Understand normalization
  • Assign relationships
  • Eliminate repetition
  • Relate tables with IDs
  • Design rules
Course content
Expand all 20 lectures 01:39:03
+ Database Basics
4 lectures 23:15
Different Types of Databases
11:40
The Process of Database Design
07:58
+ Normalizing
14 lectures 01:08:12
Basic Steps to Normalization
04:38
A. Brainstorm
01:08
B. Organize
03:13
C. Eliminate Repetition
11:34
D. Assign Relationships
00:22
D1. One to One Relationship
06:01
D2. One to Many Relationship
04:19
D3. Many to Many Relationship
05:29
Relating Tables with IDs
01:46
Examples of Bad Design
15:20
Examples of Good Design
05:53
Design Rules
05:09
Requirements
  • Basic Microsoft Windows training or equivalent experience
Description

This course familiarizes the student with techniques necessary to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project.  Information in this course is a must for anyone responsible for building and maintaining a database.

Who this course is for:
  • Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design