The Practical Database Design & Modeling Beginners Tutorial
4.3 (171 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,048 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Practical Database Design & Modeling Beginners Tutorial to your Wishlist.

Add to Wishlist

The Practical Database Design & Modeling Beginners Tutorial

Learn Data Modeling and Database Design by example, while creating an ecommerce website's database model.
4.3 (171 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
9,048 students enrolled
Created by Rares Ilea
Last updated 7/2017
English
English [Auto-generated]
Price: Free
Includes:
  • 2 hours on-demand video
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn what is a database
  • 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
View Curriculum
Requirements
  • No coding, design or technical knowledge required.
  • A computer running any operating system. The tools used in this tutorial are FREE and run on: Windows, Linux and MacOS.
  • Willingness to learn about Databases, Data Modeling & Design
Description

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 data modeling and design techniques. You will learn while designing a real world online store's database

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!

Who is the target audience?
  • Students just getting start with databases
  • Non technical people seeking to land a new job in IT
  • Frontend Developers wanting to learn more about Databases
Compare to Other Database Design Courses
Curriculum For This Course
21 Lectures
02:05:14
+
Introduction
1 Lecture 02:03
Course Introduction
02:03
+
Database Basics
4 Lectures 24:15

Explore the history of collecting data since the first writings, 6000 BC, until today. The answer to "What is a database?" 

What is a database?
06:56

How do a databases work and why are they important?
10:34

Different Types of Databases
02:48

DBMS vs RDBMS


What is a Relational Database?
03:57
+
Database Modeling and Design
4 Lectures 17:25

Find out the what it is? What are the objectives and why database design is so important (the benefits)? Last but not least, find out the database design process (the steps).

What is Database Design?
05:21

What are the three types of Database Design?
02:17

Database Modeling and Design tools
01:46

Setup MySQL Workbench and prepare the work environment
08:01
+
Database Design Phase 1 - Normalization
5 Lectures 29:29
Define Conceptual and Logical Design for an Online Store
08:57

What is Database Normalization?
02:59

First Normal Form
09:26

Second Normal Form
03:09

Third Normal Form
04:58
+
Database Design Phase 2 - Relationships
4 Lectures 26:50
Database Relationships. Identifying vs Non-Identifying. Cardinality.
03:49

One to One Relationship
06:49

One to Many Relationship
09:19

Many to Many Relationship
06:53
+
Finalizing the e-commerce DB
2 Lectures 23:37

Design the orders. Discuss about self referencing relationships: category - parent category and enhance the design with product reviews

Finalize Database Model
09:31

Generate the Physical Database Schema
14:06
+
Course Conclusions
1 Lecture 01:35
Conclusion
01:35
About the Instructor
Rares Ilea
4.3 Average rating
168 Reviews
9,048 Students
1 Course
Web Applications Developer | IT Consultant

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, Javascript, jQuery, EmberJS, Knockout.JS and a few other Javascript frameworks. 

Lately, I found a new passion for teaching. It will be my pleasure to share my knowledge with Udemy students.