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
Module 2: Database Basics
What is a Database?
Different Types of Databases
The Process of Database Design
What is Normalization?
Basic Steps to Normalization
Relating Tables with IDs
Examples of Bad Design
Examples of Good Design