EssentialSQL: Data Modeling & Relational Data Architecture

Name: EssentialSQL: Data Modeling & Relational Data Architecture
Rating: 4.8 (721 reviews)

Highest Rated

Created byKris Wenzel, Essential Sql

Last updated 2/2024

English

What you'll learn

Understand the fundamental concepts of data architecture and principles of data modeling, including entities, attributes, relationships, and keys.
Understand the various types of data models, including conceptual models, logical models, and physical models.
Be able to choose the appropriate data model for a given situation.
Be able to analyze and design a database using the Entity-Relationship (ER) data model.
Know how to transform a conceptual data model into a logical data model using normalization.
Understand the principles of data modeling and database design to create a well-designed database.
Know how to use data modeling tools, such as ER (Entity Relationship) diagrams and data modeling software, to create and document data models.
Be able to communicate effectively about data modeling concepts and designs with both technical and non-technical audiences.

Course content

9 sections • 30 lectures • 3h 45m total length

Welcome!2:29
Welcome to Relational Database Design. I'm so glad you're here. Let's get started learn some data architecture!
Pizza DB, Helping Lou2:10
Let's quickly talk about the case study and the broad view of moving from requirement to database implementation.

What is Database Normalization?4:12
Database normalization can be really abstract. Before we get into some of the definitions, let's look at a practical view.
Reasons for Database Normalization7:49
You may wonder what's all the fuss about database normalization. Let me show you some good reasons you'll want to understand it.
The Three Normal Forms4:57
The three normal forms are guide lines we can used to help use determine how to design tables. The help use know whether columns should be include in a table or should be separated. The forms build upon one another. In order for a table to be in the second form, if must first meet the criteria for the first.

For those that are impatient check out the our Five Minute Guide to Database Normalization within the downloadable resources.
The First Normal Form Explained6:47
Once a table is in the first normal form, the table is considered a relational database table, and it doesn't contain any repeating values.
The First Normal Form Design Review7:32
To better understand the first normal form, lets go over some examples.
Data Modification Anomalies and First Normal Form Assignment
The Second Normal Form Explained8:54
When a table is in the second normal form the table serves a single purpose.
The Second Normal Form Design Review13:39
Let's transform our first normal form tables into the second normal form.
Second Normal Form Assignment
The Third Normal Form6:56
Tables in the third normal form have columns that aren't calculated, that is they don't rely on other column values from within the table.
The Third Normal Form Design Review7:16
In this lesson we'll transform our tables from 2nd to 3rd normal form.
Database Normalization Quiz

Introduction to Database Design1:52
Learn how requirements, conceptual models, ER Diagrams and normalization fall in place to assist DB design.
ER Diagramming - Initial Draft Part 110:16
Use the conceptual model to create the first draft of our ERD diagram.
ER Diagramming - Initial Draft Part 29:42
Continue to refine the ER diagram by applying database normalization rules.
ER Diagramming - Initial Draft Part 37:46
Use the conceptual model to create the first draft of our ERD diagram.
Database Normalization Review - Part 19:15
Continue to refine the ER diagram by applying database normalization rules.
Database Normalization Review - Part 28:15
Continue to refine the ER diagram by applying database normalization rules.
Beginning Database Design Patterns18:32

Requirements

No programming experience is needed.
No prior knowledge of MySQL, SQLServer, PostgreSQL or Oracle is required!
Appreciate basic database concepts such as knowing about columns, rows, and tables.
Interest in a class hyper-focused on database design and data architecture -- nothing else!

Description

This course is perfect if you're looking for entry-level course to learn data modeling and relational database table design.

Its singular purpose is to teach you relational database logical design using simple to understand English. We'll walk though modeling requirements, building the conceptual data model, and logical database model. Finally we create scripts to create the physical tables. If you looking to understand data architecture, then you'll find this course very practical!

Join me as we work through Lou's, the owner of several pizza shops, to model, design and create a database he can use to track is business.

In this Course you will Learn to:

Create a conceptual data model based on Lou's Pizza Shops' requirements.
Use ER (Entity-Relationship) diagrams to model and design database tables and relationships between one another.
Appreciate and design around data modification anomalies.
Identify a properly formed database table.
Answer common interview questions related to relational database normalization and data architecture.
Spot a poorly designed table.
Communicate with others about table design.
Finally understand those confounding normalization rules!
Identify database normalization issues within our design and know how to fix them.
Use an ERD (Entity Relationship Diagram) to create database scripts.

Nothing is worse than

Being excited to learn something new but not knowing where to start.
Wasting time learning the wrong features.
Being overwhelmed with options and not know which to use.

Imagine Having...

Knowledge - Knowing how to quickly understand database design to take your SQL to the next level.
Confidence - Feeling good that you’re on the right track.
Accomplishment - Having a sense of accomplishment that you've learned something most cannot.
Fun - Having fun learning databases!

By the time you’ve completed this course you’ll be able to design and implement relational databases using tables, keys, relationships, and SQL commands in MySQL, PostgresSQL, and SQL Server to meet user and operational needs.

Who this course is for:

Students baffled by their professor's database normalization explanations
DBAs seeking common sense definitions of database normal forms.
Anyone studying MySQL, Oracle, or SQL Server wanting to become a better database designer.
People preparing for SQL related job interviews.
Anyone looking to take a class whose singular purpose is to teach you database design.
Anyone who doesn't have time to weed through dense textbooks trying to sort out academic explanations.

EssentialSQL: Data Modeling & Relational Data Architecture

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 5min

Data Modeling Requirements1 lecture • 5min

Optional Data Modeling Tools2 lectures • 11min

Conceptual Data Model2 lectures • 22min

Relational Table Design2 lectures • 9min

Database Normalization9 lectures • 1hr 8min

Relational Database Design and Architecture In Practice7 lectures • 1hr 6min

Database Creation4 lectures • 39min

Data Modeling Wrap-up1 lecture • 1min

Requirements

Description

Who this course is for: