Database Design Introduction

Prevent typical developer mistakes by learning how to properly create and normalize a relational database
4.1 (87 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.
932 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 20
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English

Course 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.

What are the requirements?

  • Basic Microsoft Windows training or equivalent experience

What am I going to get from this course?

  • What is a database
  • Understand different types of databases
  • Understand normalization
  • Assign relationships
  • Eliminate repetition
  • Relate tables with IDs
  • Design rules

What is the target audience?

  • Students just getting start with designing databases and those who have been designing databases but looking for tips on more effective design

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
03:19
Section 2: Database Basics
Overview
Preview
00:50
What is a Database?
Preview
02:47
Different Types of Databases
11:40
The Process of Database Design
07:58
Section 3: Normalizing
Overview
Preview
01:04
What is Normalization?
Preview
02:16
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
Section 4: Conclusion
Conclusion
04:17

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Ready to start learning?
Take This Course