Course Overview
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.
Course Objectives
Database Basics, Normalizing
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
1 - 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