Data Modeling

  1. Home
  2. Data-modeling
  3. Data Modeling

Tags: Data Modeling

Learn Database design using examples in a very short period of time.

Last updated 2022-01-10 | 3.7

- E-R Modelling and Physical database design

What you'll learn

E-R Modelling and Physical database design

* Requirements

* Should know what a database mean
* its purpose and applications.

Description

All the explanations in this course are carried out by considering real-world examples.

What you will learn in this course:

  • Basic concepts and definitions.

  • Build an E R model

  • Transform a model into physical database design

  • Learn the normalization technique for designing tables.

Benefits of enrolling into this course:

  • You will be able to design an efficient database for any application.

  • You will learn the concepts easily as I have explained every topic using an example.

  • You can start this course even if you are a beginner.

  • You can ask questions to me at any time.

  • You can keep the course for a lifetime.


Who this course is for:

  • Programmer or Non Programmer who wants create a data storing web or mobile apps.

Course content

4 sections • 16 lectures

Introduction 2 lectures

Course map Preview 00:58

Why E R modelling Preview 01:57

Entity Relationship modelling 5 lectures

Introduction Preview 01:01

Entity and Relationship Preview 03:07

Cardinality of a relationship Preview 08:24

E R diagram notations Preview 05:11

Steps for creating a model Preview 06:05

Practising what we have learnt with examples 5 lectures

Introduction Preview 00:23

Creating an example model Preview 22:15

Transforming model into a physical database design Preview 13:21

Creating an Example model 2 lec -1 Preview 12:20

Creating an example model 2-lec 2 Preview 19:13

Normalization 4 lectures

Introduction to Normalization Preview 01:46

Anomalies Preview 07:24

Basic definations Preview 09:23

Types of normal forms Preview 17:50