The Complete Database Design & Modeling Beginners Tutorial

The Complete Database Design & Modeling Beginners Tutorial

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2 Hours | 253 MB

Learn Data Modeling and Database Design from A to Z, while creating an online store’s database model with MySQL.

This course will introduce you to databases and relational database design. Every theoretical notion in this course is followed by several examples to help you better understand database modeling and design techniques. You will learn, by example, while designing a real world online store’s database in simple, incremental steps.

Nowadays, databases are everywhere! Every web application like: Facebook, Google, Booking or even a simple blog uses them. Knowing databases is a MUST for every web developer. If you have no technical skills and plan to join the IT industry, or if you are already a developer who wants to understand more about databases and the backend, or you are simply interested in the subject, then this course is for you.

Sound database design reduces data redundancy to a minimum, improves data retrieval speed and ensures the database will adapt easily to future changes.

In this course you will learn relational database design with step-by-step, practical examples. This video tutorial cover the following topics:

  • What is a database?
  • How databases work? The power 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 you computer and how to use it to design a database
  • What database normalization is and how to apply the three normal forms (1NF, 2NF, 3NF)
  • What data redundancy means?
  • How to design and create database relationships: one-to-one, many-to-one and many-to-many relationships.
  • Complete the design of an online store. Create entities and attributes for: products, items, customers, categories, brands, reviews, etc.
  • Finally, you’ll learn how to use it’s forward engineering feature to create the actual database on MySQL Server.

Every technical lecture has a screenshot of the database schema.

Table of Contents

Introduction
1 Course Introduction

Database Basics
2 What is a database
3 How do a databases work and why are they important
4 Different Types of Databases
5 What is a Relational Database

Database Modeling and Design
6 What is Database Design
7 What are the three types of Database Design
8 Database Modeling and Design tools
9 Setup MySQL Workbench and prepare the work environment

Database Design Phase 1 – Normalization
10 Define Conceptual and Logical Design for an Online Store
11 What is Database Normalization
12 First Normal Form
13 Second Normal Form
14 Third Normal Form

Database Design Phase 2 – Relationships
15 Database Relationships. Identifying vs Non-Identifying. Cardinality.
16 One to One Relationship
17 One to Many Relationship
18 Many to Many Relationship

Finalizing the e-commerce DB
19 Finalize Database Model
20 Generate the Physical Database Schema

Course Conclusions
21 Conclusion