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 2: Database Basics
Lecture 3
What is a Database?
Lecture 4
Different Types of Databases
Lecture 5
The Process of Database Design
Lecture 7
What is Normalization?
Lecture 8
Basic Steps to Normalization
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
