DescriptionLearn 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.
You will learn the answers to the following topics:
What is a database?
How do databases work? The power of database indexes.
What are some different types of database management systems (DBMS)
What is a relational database? What are tables, columns, primary keys, foreign keys, relationships, and much more
What is database design and why is database design important?
What are the 3 levels of database design? Conceptual, Logical and Physical database design.
Data modeling and database design tools. You will also learn how to setup MySQL Workbench on your computer and how to design a database with its aid.
What database normalization is and how to apply the three normal forms (1NF, 2NF, 3NF)
What does data redundancy mean?
How to design and create database relationships: one-to-one, many-to-one and many-to-many.
Complete the design of an online store’s database. Create entities and attributes for: products, items, customers, categories, brands, reviews, etc.
Finally, you'll learn how to use forward engineering (a feature of MySQL Workbench) to create the actual database on MySQL Server.
Every technical lecture has attached a screenshot of the resulting database schema