• LOGIN
  • No products in the cart.

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


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.

Learning Outcomes

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

Pre-requisites

Basic Microsoft Windows training or equivalent experience


Who is this course intended for?

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

Course Curriculum

Introduction
Introduction 00:00:00
Database Basics
Overview 00:00:00
What is a Database? 00:00:00
Different Types of Databases 00:00:00
The Process of Database Design 00:00:00
Normalizing
Overview 00:00:00
What is Normalization? 00:00:00
Basic Steps to Normalization 00:00:00
A. Brainstorm 00:00:00
B. Organize 00:00:00
C. Eliminate Repetition 00:00:00
D. Assign Relationships 00:00:00
D1. One to One Relationship 00:00:00
D2. One to Many Relationship 00:00:00
D3. Many to Many Relationship 00:00:00
Relating Tables with IDs 00:00:00
Examples of Bad Design 00:00:00
Examples of Good Design 00:00:00
Design Rules 00:00:00
Conclusion
Conclusion 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • $99.00 $10.00
  • UNLIMITED ACCESS
  • Course Certificate
STUDENTS ENROLLED
    © Learnsector