Database Design - Beginner

Price
$49.99
Duration
1 Hours, 38 Minutes
Delivery Method
LearnNow On Demand

This course familiarizes the student with techniques 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.

 

Purchase This On Demand Title or a LearnNow On Demand subscription

Database Design - Beginner
  Buy Now $49.99 Purchase this course for 12 months.
  Buy Now $99.95 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.

This class is also part of our LearnNow Pass. Click here for more details.

Course Objectives

    Database Basics, Normalizing

Agenda

1 - Introduction
  • Introduction
2 - Database Basics
  • Overview
  • What is a Database?
  • Different Types of Databases
  • The Process of Database Design
3 - Normalizing
  • Overview
  • What is Normalization?
  • Basic Steps to Normalization
  • A. Brainstorm
  • B. Organize
  • C. Eliminate Repetition
  • D. Assign Relationships
  • D-1. One to One Relationship
  • D-2. One to Many Relationship
  • D-3. Many to Many Relationship
  • Relating Tables with IDs
  • Examples of Bad Design
  • Examples of Good Design
  • Design Rules
4 - Conclusion
  • Course Recap