Programming & Web Development
Database Design - Beginner
Self-paced lessons, under two hours in all, explaining what a database is, the main types you will meet and the basic steps of normalisation.
1 hour 38 minFoundation4 modules
About this course
Self-paced lessons, under two hours in all, explaining what a database is, the main types you will meet and the basic steps of normalisation.
Curriculum
4 modules
- Introduction
- Overview
- What is a Database?
- Different Types of Databases
- The Process of Database Design
- 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
- Course Recap
Who it's for
Beginners planning their first database or working with structured data for the first time.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Programming & Web Development →Advanced
Advanced Java 9
Programming & Web Development
View course →Foundation
Android Studio Development Essentials
Programming & Web Development
View course →Intermediate
Blockchain: An Overview for Business Professionals
Programming & Web Development
View course →Intermediate
Computer Vision with Python OpenCV
Programming & Web Development
View course →Intermediate
Flask Development with Python
Programming & Web Development
View course →Foundation
HTML5 - Content Authoring Fundamentals
Programming & Web Development
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.