EssentialSQL: Data Modeling & Relational Data Architecture
Database Design | Data Model | Data Architecture | Relational Database Design | Database Normalization | Data Modeling
Lo que serás capaz de hacer
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.
- 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.
Temario
UNIDAD 1 - Introduction · 2 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Welcome!
- Pizza DB, Helping Lou
UNIDAD 2 - Data Modeling Requirements · 1 leccionesUNIDAD 2 - Data Modeling Requirements
UNIDAD 2 - Data Modeling Requirements
- Introduction to Data Modeling Requirements
UNIDAD 3 - Optional Data Modeling Tools · 2 leccionesUNIDAD 3 - Optional Data Modeling Tools
UNIDAD 3 - Optional Data Modeling Tools
- Software Tools I Used for Data Modeling
- What Flavor of SQL Should I Choose?
UNIDAD 4 - Conceptual Data Model · 4 leccionesUNIDAD 4 - Conceptual Data Model
UNIDAD 4 - Conceptual Data Model
- What is a Conceptual Data Model
- Conceptual Data Model Walk Through
- Review conceptual data modeling concepts
- Conceptual Data Model - Change to Requirements!
UNIDAD 5 - Relational Table Design · 4 leccionesUNIDAD 5 - Relational Table Design
UNIDAD 5 - Relational Table Design
- Introduction to Schema Design
- Entity Relationship Diagrams
- Relational Table Design Concepts
- Table Relationship Assignment
UNIDAD 6 - Database Normalization · 12 leccionesUNIDAD 6 - Database Normalization
UNIDAD 6 - Database Normalization
- What is Database Normalization?
- Reasons for Database Normalization
- The Three Normal Forms
- The First Normal Form Explained
- The First Normal Form Design Review
- Data Modification Anomalies and First Normal Form Assignment
- The Second Normal Form Explained
- The Second Normal Form Design Review
- Second Normal Form Assignment
- The Third Normal Form
- The Third Normal Form Design Review
- Database Normalization Quiz
UNIDAD 7 - Relational Database Design and Architecture In Practice · 7 leccionesUNIDAD 7 - Relational Database Design and Architecture In Practice
UNIDAD 7 - Relational Database Design and Architecture In Practice
- Introduction to Database Design
- ER Diagramming - Initial Draft Part 1
- ER Diagramming - Initial Draft Part 2
- ER Diagramming - Initial Draft Part 3
- Database Normalization Review - Part 1
- Database Normalization Review - Part 2
- Beginning Database Design Patterns
UNIDAD 8 - Database Creation · 4 leccionesUNIDAD 8 - Database Creation
UNIDAD 8 - Database Creation
- Data Definition Language Concepts
- Creating Tables and Columns
- Defining Table Constraints
- DDL Script Review
UNIDAD 9 - Data Modeling Wrap-up · 1 leccionesUNIDAD 9 - Data Modeling Wrap-up
UNIDAD 9 - Data Modeling Wrap-up
- Bonus Lecture
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
9 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
7 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Kris Wenzel.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 9 unidades · 37 lecciones · 45 h
- 12 meses de acceso
- 7 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Kris Wenzel; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
