Database Design Introduction

Name: Database Design Introduction
Rating: 4.5 (3386 reviews)

Prevent typical developer mistakes by learning how to properly create and normalize a relational database

Created byIntellezy Trainers

Last updated 10/2016

English

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

4 sections • 20 lectures • 1h 39m total length

Introduction3:19

Overview1:04
What is Normalization?2:16
Basic Steps to Normalization4:38
A. Brainstorm1:08
B. Organize3:13
C. Eliminate Repetition11:34
D. Assign Relationships0:22
D1. One to One Relationship6:01
D2. One to Many Relationship4:19
D3. Many to Many Relationship5:29
Relating Tables with IDs1:46
Examples of Bad Design15:20
Illustrates why flat-file and wide tables create bad design by showing duplicated fields and complex queries, then explains normalization with related tables for sales reps, contact phones, and emails.
Examples of Good Design5:53
Design Rules5: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

Database Design Introduction

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Database Basics4 lectures • 23min

Normalizing14 lectures • 1hr 8min

Conclusion1 lecture • 4min

Requirements

Description

Who this course is for: