EssentialSQL: Data Modeling & Relational Data Architecture
- Descrição
- Currículo
- FAQ
- Revisões
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.
-
10
Introduction to Schema DesignLearn the overall process we use to move from conceptual model to ER diagram.
-
11
Entity Relationship Diagrams
Learn about Entity Relationship Diagrams and when to use them.
-
12
Relational Table Design ConceptsReview concepts learned in the Relational Table Design section.
-
13
Table Relationship Assignment
-
14
What is Database Normalization?
Database normalization can be really abstract. Before we get into some of the definitions, let's look at a practical view.
-
15
Reasons for Database Normalization
You may wonder what's all the fuss about database normalization. Let me show you some good reasons you'll want to understand it.
-
16
The Three Normal Forms
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.
-
17
The First Normal Form Explained
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.
-
18
The First Normal Form Design Review
To better understand the first normal form, lets go over some examples.
-
19
Data Modification Anomalies and First Normal Form Assignment
-
20
The Second Normal Form Explained
When a table is in the second normal form the table serves a single purpose.
-
21
The Second Normal Form Design Review
Let's transform our first normal form tables into the second normal form.
-
22
Second Normal Form Assignment
-
23
The Third Normal Form
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.
-
24
The Third Normal Form Design Review
In this lesson we'll transform our tables from 2nd to 3rd normal form.
-
25
Database Normalization Quiz
This quiz covers topic related to database tables, 1st, 2nd, and 3rd normal forms.
-
26
Introduction to Database Design
Learn how requirements, conceptual models, ER Diagrams and normalization fall in place to assist DB design.
-
27
ER Diagramming - Initial Draft Part 1
Use the conceptual model to create the first draft of our ERD diagram.
-
28
ER Diagramming - Initial Draft Part 2
Continue to refine the ER diagram by applying database normalization rules.
-
29
ER Diagramming - Initial Draft Part 3
Use the conceptual model to create the first draft of our ERD diagram.
-
30
Database Normalization Review - Part 1
Continue to refine the ER diagram by applying database normalization rules.
-
31
Database Normalization Review - Part 2
Continue to refine the ER diagram by applying database normalization rules.
-
32
Beginning Database Design Patterns
-
33
Data Definition Language Concepts
Learn about the subset of SQL commands used to create tables.
-
34
Creating Tables and Columns
Use the CREATE TABLE command to define tables and columns.
-
35
Defining Table Constraints
Learn how to define primary, unique, and foreign key constraints.
-
36
DDL Script Review
Review the script used to create the database and tables based on the ER Diagram design.
