Relational Database Design: A Data Modeling Workshop

Focused View

Timothy Hange

1:59:34

47 View

1. Introduction

1. Introduction, Goals, and Roadmap.mp4

08:10

2. Relational Databases Basic structure

1. Relational Database Overview.mp4

02:52

2. Database Tables Rows, Columns, and Primary Keys.mp4

05:36

3. Relational Database Basics.html

3. Data anomalies and data normalization

1. Data Anomalies.mp4

06:13

2. Data Normalization.mp4

10:23

3. Over-normalization.mp4

04:33

4. Recap and Review.mp4

02:41

5. Data Anomalies and Data Normalization.html

4. Data Modeling Entities, Attributes, and Relationships

1. Data Modeling Overview.mp4

09:45

2. Data Modeling Entity Relationships.mp4

08:32

3. Data Modeling Basics.html

5. Project 1 Data Modeling for Client Downtown Floral

1. Data Modeling Practice Downtown Florals initial ERD.mp4

12:25

2. Resolving Many-to-Many Relationships.mp4

07:17

3. Data Modeling for Downtown Floral Adding Order History.mp4

05:43

4. Data Modeling for Downtown Floral Adding Delivery Drivers.mp4

08:19

5. Data Modeling for Downtown Floral Adding Florists to Orders.mp4

05:42

6. Project 2 Data Modeling for Best Tech U

1. Data modeling for Best Tech U Creating the Initial Data Model.mp4

08:17

2. Data Modeling for Best Tech U Adding majors.mp4

06:08

3. Data Modeling for Best Tech U Adding Professors.mp4

04:31

7. Conclusion and Next Steps

1. Conclusion and Next Steps.mp4

02:27

Description

Learn to translate business needs into a data model.

What You'll Learn?

Explain what relational database is
Understand how to avoid problems that can happen when we store data in tables
Design a database model that meets business needs and avoid data storage problems
Prepare your data model for actual database construction.

Who is this for?

Current or developing technology professionals who need an introduction to database design.

Anyone needing to design a database to solve a business problem.

Absolute beginners to database design

What You Need to Know?

No prior database experience is required. This course is designed for the beginner.

More details

Description
In this foundational course, we begin by teaching you the basics of relational databases and how they work.Â You will then learn the process of data modeling--translating a set of business needs into a visual "entity relationship diagram" that can be used to create a database.Â You won't actually create the database in this course--this is primarily about the data modeling process.Â Â
What is most valuable about this course is the way that it will teach you to translate business requirements into data models using hands-on projects!Â We will work with two imaginary clients who will give us a set of business requirements.Â We'll create diagrams to serve their needs and modify the diagrams as their business needs grow and change.Â In short, you will learn data modeling skills by DOINGÂ data modeling.Â
An outline of the topics includes:
1.Â An Introduction to Relational Databases:
Components of Relational Databases
Tables
Primary and Foreign Keys
2.Â Proper Database Design
Data Anomalies and Avoiding Redundant Data
Normalization (First - Third Normal Forms)
Over-Normalization
3. Data Modeling
Entity Relationship Diagrams:Â Entities and Attributes
Entity Relationships and Cardinality
Resolving Many-to-Many Relationships
4.Â Data Modeling Project 1:Â Downtown Floral
Build the Initial Data Model Based on Business Requirements
Update Model Based on Business Changes (Several Rounds)
4.Â Data Modeling Project 2:Â Best Tech U
Build the Initial Data Model Based on Business Requirements
Update Model Based on Business Changes (Several Rounds)
I look forward to guiding you through this course.Â Don't be intimidated by the terminology.Â We'll take this a step at a time and you'll do great!

Who this course is for:
Current or developing technology professionals who need an introduction to database design.
Anyone needing to design a database to solve a business problem.
Absolute beginners to database design

User Reviews

Rating

average 0

Total votes0

Focused display

Hello! I'm an instructional designer who also happens to have 15 years of experience in software engineering. I believe my courses will be helpful to you because I really enjoy taking complex topics and making them simple to understand, particularly for beginners. I teach a range of courses from English as a Second Language to Database Design. My degrees are in Computer Information Systems (Bachelors), Education (Master's) and English Pedagogy (Doctorate). I love learning, so it's easy to put myself in the shoes of a learner. I think you'll find my courses both fun and effective! Peace.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.