Next steps | Coding Bootcamps

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Learn how to design databases by examples

Course contents

What you'll learn in this course
PDF File for All Lecture Sessions
PDF File for All Reading Materials
Next steps

Course Lectures- Session 1

Before the Advent of Database Systems (5:17)

Course Lectures- Session 2

Fundamental Concepts (4:02)

Course Lectures- Session 3

Characteristics and Benefits of a Database (9:46)

Course Lectures- Session 4

Types of Data Models (4:37)

Course Lectures- Session 5

Data Modeling (9:39)

Course Lectures- Session 6

a- Classification Based on Data Model (2:48)
b- Classification Based on User Numbers (1:50)
c- Classification Based on Database Distribution (1:42)
d- Distributed database system (2:03)

Course Lectures- Session 7

The Relational Data Model (4:05)

Course Lectures- Session 8

a- Entity, Entity Set and Entity Type (3:28)
b- Kinds of Entities (3:53)
c- Attributes & Types of Attributes (1:21)
d- Keys & Types of Keys (2:01)
e- Nulls (3:18)
f- Relationships & Types of Relationships (2:43)

Course Lectures- Session 9

a- Domain Integrity (3:13)
b- Enterprise Constraints & Business Rules (2:32)
c- Relationship Types (1:19)

Course Lectures- Session 10

a- Relational Design and Redundancy (2:35)
b- Insertion Anomaly (0:59)
c- Update Anomaly (1:03)
d- Deletion Anomaly & How to Avoid Anomalies (4:26)

Course Project 1

University Registration Data Model Example (2:48)

Course Project 2

Two Sample ERD Exercises (17:12)

Teach online with

Next steps

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock