Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

The Complete Database Design Beginners Tutorial

Rares Ilea, Web Applications Developer | IT Consulta

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
21 Videos (2h 5m)
    • 01 Introduction

      2:03
    • 02 what is a database

      6:59
    • 03 How databases work and why are they important

      10:34
    • 04 Different types of databases

      2:48
    • 05 What is a Relational Database

      3:57
    • 06 What is Database Design

      5:21
    • 07 What are the three types of Database Design

      2:17
    • 08 Database Design Tools

      1:46
    • 09 Setup MySQL Workbench and prepare the work environment

      8:01
    • 10 Define Conceptual and Logical Design for an Online Store

      8:57
    • 11 What is Database Normalization

      2:59
    • 12 First Normal Form

      9:26
    • 13 Second Normal Form

      3:09
    • 14 Third Normal Form

      4:58
    • 15 Database Relationships

      3:49
    • 16 One to one relationship

      6:49
    • 17 One to Many Relationship

      9:19
    • 18 Many to many Relationship

      6:53
    • 19 Finalize Database Design

      9:31
    • 20 Generate the Physical Database

      14:06
    • 21 Conclusions

      1:35

About This Class

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.

Enroll now and I'll see you on the other side!

7

Students

--

Projects

Rares Ilea

Web Applications Developer | IT Consulta

Hello! My name is Rares Ilea. I am a Senior Software Engineer with a passion for teaching.

I have 12+ years of practical experience in Web Application Development. Working both for big corporations or as a freelancer, during the years I've designed and implemented Enterprise Web Application using several server technologies: Java, NodeJS, Ruby on Rails and database management systems: Oracle, MySQL and PostgreSQL. On the frontend, I've gained experience working with: HTML5, CSS3, Javas...

See full profile