EssentialSQL: Data Modeling & Relational Data Architecture

EssentialSQL: Data Modeling & Relational Data Architecture, available at $79.99, has an average rating of 4.49, with 30 lectures, 3 quizzes, based on 263 reviews, and has 1800 subscribers.

You will learn about 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. This course is ideal for individuals who are Students baffled by their professor's database normalization explanations or DBAs seeking common sense definitions of database normal forms. or Anyone studying MySQL, Oracle, or SQL Server wanting to become a better database designer. or People preparing for SQL related job interviews. or Anyone looking to take a class whose singular purpose is to teach you database design. or Anyone who doesn't have time to weed through dense textbooks trying to sort out academic explanations. It is particularly useful for Students baffled by their professor's database normalization explanations or DBAs seeking common sense definitions of database normal forms. or Anyone studying MySQL, Oracle, or SQL Server wanting to become a better database designer. or People preparing for SQL related job interviews. or Anyone looking to take a class whose singular purpose is to teach you database design. or Anyone who doesn't have time to weed through dense textbooks trying to sort out academic explanations.

Enroll now: EssentialSQL: Data Modeling & Relational Data Architecture

Summary

Title: EssentialSQL: Data Modeling & Relational Data Architecture

Price: $79.99

Average Rating: 4.49

Number of Lectures: 30

Number of Quizzes: 3

Number of Published Lectures: 30

Number of Published Quizzes: 3

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome!

Lecture 2: Pizza DB, Helping Lou

Chapter 2: Data Modeling Requirements

Lecture 1: Introduction to Data Modeling Requirements

Chapter 3: Optional Data Modeling Tools

Lecture 1: Software Tools I Used for Data Modeling

Lecture 2: What Flavor of SQL Should I Choose?

Chapter 4: Conceptual Data Model

Lecture 1: What is a Conceptual Data Model

Lecture 2: Conceptual Data Model Walk Through

Chapter 5: Relational Table Design

Lecture 1: Introduction to Schema Design

Lecture 2: Entity Relationship Diagrams

Chapter 6: Database Normalization

Lecture 1: What is Database Normalization?

Lecture 2: Reasons for Database Normalization

Lecture 3: The Three Normal Forms

Lecture 4: The First Normal Form Explained

Lecture 5: The First Normal Form Design Review

Lecture 6: The Second Normal Form Explained

Lecture 7: The Second Normal Form Design Review

Lecture 8: The Third Normal Form

Lecture 9: The Third Normal Form Design Review

Chapter 7: Relational Database Design and Architecture In Practice

Lecture 1: Introduction to Database Design

Lecture 2: ER Diagramming – Initial Draft Part 1

Lecture 3: ER Diagramming – Initial Draft Part 2

Lecture 4: ER Diagramming – Initial Draft Part 3

Lecture 5: Database Normalization Review – Part 1

Lecture 6: Database Normalization Review – Part 2

Lecture 7: Beginning Database Design Patterns

Chapter 8: Database Creation

Lecture 1: Data Definition Language Concepts

Lecture 2: Creating Tables and Columns

Lecture 3: Defining Table Constraints

Lecture 4: DDL Script Review

Chapter 9: Data Modeling Wrap-up

Lecture 1: Bonus Lecture

Instructors

Kris Wenzel
Let me teach you SQL using simple to understand English.
Essential Sql
Learn everything you need to use SQL in your next project

Rating Distribution

1 stars: 3 votes
2 stars: 2 votes
3 stars: 24 votes
4 stars: 86 votes
5 stars: 148 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu