facebook-pixel
$29.99
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Intellezy Trainers, Instructor - Introduction to Database Design

Intellezy Trainers

Improving individual or company performance begins with the right training resources. Keep your team’s Microsoft and Adobe skills fresh with our engaging, short-segment videos. Intellezy’s training is delivered by certified instructors and industry experts. Their friendly, engaging style breaks down complex ideas into bite-sized learning nuggets. And, because they never leave the screen, the learner’s attention is held longer. Start watching and find out how valuable 3 minutes can be.

Instructor: Intellezy Trainers

Learn how to properly create and normalize a relational database

  • What is a database.
  • Understand different types of databases.
  • Understand normalization.

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. Instructor: Tim Miles

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

Prerequisites and Target Audience

What will students need to know or do before starting this course?

Basic Microsoft Windows training or equivalent experience

Who should take this course? Who should not?

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

Curriculum

Module 1: Introduction

Lecture 1 Introduction

Module 2: Database Basics

Lecture 2 Overview
Lecture 3 What is a Database?
Lecture 4 Different Types of Databases
Lecture 5 The Process of Database Design 

Module 3: Normalizing

Lecture 6 Overview
Lecture 7 What is Normalization?
Lecture 8 Basic Steps to Normalization
Lecture 9 Brainstorming
Lecture 10 Organizing
Lecture 11 Eliminating Repetition
Lecture 12 Assigning Relationships
Lecture 13 One-to-One Relationships
Lecture 14 One-to-Many Relationships
Lecture 15 Many-to-Many Relationships
Lecture 16 Relating Tables with IDs 
Lecture 17 Examples of Bad Design 
Lecture 18 Examples of Good Design 
Lecture 19 Design Rules 

Module 4: Conclusion

Lecture 20 Course Recap
350