IIRF Online > Business > Business Analytics & Intelligence > Data Modeling > The Complete Database Design & Modeling Beginners Tutorial
The Complete Database Design & Modeling Beginners Tutorial by Udemy
Learn Database Design the easy way. Go from simple to complex with a real life example: online store's DB using MySQL.
Course Highlights
- Learn what a database is
- Learn how databases work and why are they important
- Learn data modeling and the 3 levels of relational database design
- Learn what are the steps to create a sound database design
- Learn what database normalization is and how to apply 1NF, 2NF and 3FN in database design
- Learn how to build database relationships: one-to-one, many-to-one and many-to-many
- Understand better every theoretical step by following several concrete examples
- You will be able to design a relational database from scratch
- You will be able to answer the most common interview questions about databases
- You will have a concrete e-commerce database design schema to add to your portofolio
Skills you will learn!
Curriculum
2 Topics
Course Introduction
Courses Bonuses (Database Design Cheatsheet & Database Terminology)
4 Topics
What is a database?
How do a databases work and why are they important?
Different Types of Databases
What is a Relational Database?
4 Topics
What is Database Design?
What are the three types of Database Design?
Database Modeling and Design tools
Setup MySQL Workbench and prepare the work environment
6 Topics
Define Conceptual and Logical Design for an Online Store
What is Database Normalization?
First Normal Form
Second Normal Form
Third Normal Form
Third Normal Form Clarifications on Zip Codes - Street relation
4 Topics
Database Relationships. Identifying vs Non-Identifying. Cardinality.
One to One Relationship
One to Many Relationship
Many to Many Relationship
2 Topics
Finalize Database Model
Generate the Physical Database Schema
2 Topics
35 Popular Database Design Interview Questions
35 Popular Database Design Interview Questions - Answers
1 Topic
Conclusion
The Complete Database Design & Modeling Beginners Tutorial
Related Data Modeling Courses
Thank You!
Your review has been submitted successfully.