EssentialSQL: Data Modeling & Relational Data Architecture

About EssentialSQL: Data Modeling & Relational Data Architecture

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.