Essential Sql: Data Model And Relational Database Design

Data Modeling for SQL Relational Database Design with Normalization Explained for MySql, PostgreSQL, and SQL Server

What you'll learn

Create conceptual database model based upon user requirements to depict relationships between business entities.

Diagram a relational database design with entity–relationship diagrams (ERDs) using crow’s foot notation to enforce referential integrity.

Evaluate tables for compliance to third normal form and perform normalization procedures on noncompliant tables.

Restructure spreadsheet like data into good database form.

Design and implement relational databases using tables, keys, relationships, and SQL commands in MySQL, PostgreSQL, and SQL Server to meet user requirements.

Be able to express and communication database design concepts with others.

Know the reasons why a relational database is organized into many separate tables.

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 – nothing else!

Description

This course is perfect if you're looking for entry-level course to learn relational database table design.  Its singular purpose is to teach you relational database logical design using simple to understand English.Join me as we work through Lou's, the owner of several pizza shops, to 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 design database tables and relationship between one another.Appreciate and design around data modification anomalies.Identify a properly formed database table.Answer common interview questions related to normalization (huge).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 thanBeing 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.

Overview

Section 1: Introduction

Lecture 1 Welcome!

Lecture 2 Pizza DB, Helping Lou

Section 2: Requirements

Lecture 3 Introduction

Section 3: Optional Tools

Lecture 4 Software Tools I Used

Section 4: Conceptual Model

Lecture 5 What is a Conceptual Model

Lecture 6 Conceptual Model Walk Through

Section 5: Relational Table Design

Lecture 7 Introduction

Lecture 8 Entity Relationship Diagrams

Section 6: Database Normalization

Lecture 9 What is Database Normalization?

Lecture 10 Reasons for Database Normalization

Lecture 11 The Three Normal Forms

Lecture 12 The First Normal Form Explained

Lecture 13 The First Normal Form Design Review

Lecture 14 The Second Normal Form Explained

Lecture 15 The Second Normal Form Design Review

Lecture 16 The Third Normal Form

Lecture 17 The Third Normal Form Design Review

Section 7: Relational Database Design In Practice

Lecture 18 Introduction

Lecture 19 ER Diagramming - Initial Draft Part 1

Lecture 20 ER Diagramming - Initial Draft Part 2

Lecture 21 ER Diagramming - Initial Draft Part 3

Lecture 22 Database Normalization Review - Part 1

Lecture 23 Database Normalization Review - Part 2

Lecture 24 Beginning Database Design Patterns

Section 8: Database Creation

Lecture 25 Data Definition Language Concepts

Lecture 26 Creating Tables and Columns

Lecture 27 Defining Table Constraints

Lecture 28 DDL Script Review

Section 9: Wrap-up

Lecture 29 Bonus Lecture

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.