Scratch the image to get a discount on your course. You'll be able to apply the coupon at checkout.

5.0 /5
(24)

76
Bienvenidos al curso de diseño de bases de datos
Cómo sacarle el máximo partido al curso
Objetivos de aprendizaje del curso de bases de datos
Toma notas de tu curso en tiempo real en Frogames Formación
¿Para qué sirve el diseño de las bases de datos?
Las tres etapas del diseño de la base de datos
El diseño conceptual
El diseño lógico
El diseño físico
Introducción al diseño conceptual
Qué es una entidad
Qué es un atributo
El diagrama de representación de entidades
Qué son los atributos univaluados
Tipos de claves y cómo elegirlas
Qué es una interrelación
Atributos en una interrelación
El grado de una interrelación
Interrelaciones ternarias sin atributos
Conectividad de una interrelación
Conectividad 1:1
Conectividad 1:N
Conectividad M:N
Entidades obligatorias vs opcionales
Ejercicio de las casas de colonias
Ejercicio de las casas de colonias
Solución al ejercicio
Consideraciones para crear tu diagrama ER
Relaciones Ternarias
Relaciones n-arias
Relaciones recursivas
Roles en relaciones recursivas
Relaciones recursivas n-arias
Entidades débiles
Generalización y especialización
El ejemplo de los empleados
Clasificación de la especialización / generalización
Entidades asociativas
Cómo convertir una entidad débil en una entidad asociativa
Ejercicio de las entidades bancarias
Ejercicio de las entidades bancarias
Solución al ejercicio de las entidades bancarias
Aclaraciones al modelo ER de las entidades bancarias
Del diseño conceptual al diseño lógico
Introducción a la transformación de entidades e interrelaciones
Transformación de Entidades
Transformación de Interrelaciones Binarias (Conectividad 1:1)
Transformación de Interrelaciones Binarias (Conectividad 1:N)
Transformación de Interrelaciones Binarias (Conectividad M:N)
Interrelaciones Binarias con dependencias de existencia
Transformación de Interrelaciones Ternarias (Conectividad M:N:P)
Transformación de Interrelaciones Ternarias (Conectividad M:N:1)
Transformación de Interrelaciones Ternarias (Conectividad N:1:1)
Transformación de Interrelaciones Ternarias (Conectividad 1:1:1)
Transformación de Interrelaciones n-arias
Transformación de interrelaciones recursivas Binarias 1:1
Transformación de interrelaciones recursivas M:N
Transformación de interrelaciones recursivas n-arias
Transformación de entidades débiles
Transformación de la generalización/especialización
Transformación de entidades asociativas
Resumen de la transformación del modelo ER al modelo relacional
Ejercicio de las entidades bancarias
Ejercicio de las entidades bancarias (parte 2)
Solución al ejercicio de las entidades bancarias
Ejercicio 1: La base de datos de las reservas de vuelos
Ejercicio 2: La base de datos de Amazon
Ejercicio 3: La base de datos de una red social
Ejercicio 4: Los clubs de fútbol
Solución Ejercicio 4
Ejercicio 5: El transporte de mercancías
Solución Ejercicio 5
Ejercicio 6: La inmobiliaria
Solución Ejercicio 6
¿Qué has aprendido en este curso?
Hemos terminado una aventura juntos, ¡pero vamos a por la siguiente!

instructor

5.0 /5
(24)

  • Avatar
    Jorge
    (5)
    My projects now have a logical structure

    I no longer design my databases "by eye"—now I understand the logic behind each table and each relationship. It's really satisfying to see how everything fits together perfectly and how the design becomes much more efficient. This course saved me from a lot of mistakes I would've definitely made down the road.

  • Avatar
    Nicolás
    (5)
    Great, now I understand how to normalize databases.

  • Avatar
    Javi
    (5)
    Useful and understandable technical information

    I used to create databases that ended up causing me problems, but now I know how to plan everything from scratch. Learning to design each table and relationship correctly has taken a huge weight off my shoulders. My projects now start out well-structured and ready for whatever comes next.

  • Avatar
    Santiago
    (5)
    I loved this introduction to the world of databases

  • Avatar
    Giovanni
    (5)
    Flawless data architecture

    Designing a database from scratch can be a mess if you don't have the right methodology, and this course gives you exactly that. I learned how to foresee structural errors before writing a single line of code, which has saved me hours of fixes in my personal projects; it's a must-have investment for anyone looking for professionalism

  • Avatar
    Rocío
    (5)
    I really enjoyed it

    And I've also learned a lot

  • Avatar
    Rosa
    (5)
    I give it 5 stars

  • Avatar
    Jackeline
    (5)
    Ideal for those who want to do things right from the start

  • Avatar
    Nieves
    (5)
    Database Design from A to Z: model, normalize, and structure your data like a pro

    This course teaches you how to design databases from theoretical foundations to practical implementation. You'll learn to identify entities, attributes, and relationships, apply business rules, build entity-relationship (E-R) models, normalize structures, define data types, primary and foreign keys, and prepare your database for efficient queries.

  • Avatar
    Angel
    (5)
    Database Design from A to Z: structure, normalize and optimize like a pro

    This Frogames course offers complete training in database design, from the most basic concepts to advanced modeling and optimization techniques. You'll learn to identify entities, define relationships, apply integrity rules and build efficient schemas that respond to real business or development needs.

  • Avatar
    Gustavo
    (5)
    Database Design from A to Z: structure, logic, and efficiency within everyone's reach

    The Database Design from A to Z course is a complete and thoughtful guide for those who want to master the art of structuring information in a logical, efficient, and scalable way. From the first modules, you can see a clear pedagogical approach that combines solid theory with practical applications, ideal for both beginners and those looking to strengthen their knowledge.

  • Avatar
    Juan Manuel
    (5)
    A really complete course

    I found this to be a really comprehensive course, explained really well with great methodology. I think it'll be super useful for me.

  • Avatar
    María
    (5)
    Designing databases is easier than I thought

    I never thought I'd enjoy learning about database design so much. I loved how they cover everything from the basics to more complex concepts. I feel like I can structure any system now!

  • Avatar
    Carlos
    (5)
    Database Design Explained Step by Step

    I loved how you combine theory with hands-on exercises, helping me understand how to avoid redundancies and improve my database performance. Now I have a better grasp on how to create scalable and well-organized systems.

  • Avatar
    Samuel
    (5)
    Excellent information, thanks

    The lessons taught changed the way I do things, before my databases were a mess, but now everything is organized and efficient.

  • Avatar
    Gabriela
    (5)
    I feel more confident designing well-organized databases

  • Avatar
    Maria del Mar
    (5)
    A really interesting topic

    This course covers a super important subject that nobody ever talks about but Juan Gabriel has broken down incredibly well. Easy to follow and straightforward to learn!

  • Avatar
    Yvonne
    (5)
    Databases

    if you know how to manage databases, everything becomes more efficient

  • Avatar
    Omaira
    (5)
    Excellent COURSE

    Really great, honestly step by step you get to see all the fundamental aspects for understanding the concepts and logic behind database design. Highly recommended 100%

  • Avatar
    Agustin
    (5)
    Database Course

    E/R Diagrams

  • Avatar
    Beggy
    (5)
    💯

    Awesome

  • Avatar
    Caty
    (5)
    complete and detailed

    I took this course and it was a very enriching experience. The course provides a complete and detailed overview of database design, from basic concepts to advanced techniques, congratulations

  • Avatar
    Joiser
    (5)
    I recommend it

    I love how everything is explained in detail throughout the entire database creation process, from requirements gathering to implementing relational models

  • Avatar
    danison
    (5)
    Review of the databases course.

    Highly recommended, it's not just an excellent introduction to databases, but it also gives you a solid set of skills you'll need as a developer working with databases. The academy also offers great forum support, so you can get extra help and feedback from other students and instructors if you have any questions or issues with the material.

View More Reviews

PLANS TO MATCH YOUR GOALS AND NEEDS

Buy the individual course, get all the learning path or access to the entire platform

Choose the payment method that works best for your needs and budget with a one-time course payment, monthly or yearly access to the learning Path, or even to the entire platform.

One-Time Payment

Buy the course once and access it for life

49.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Popular

Bronze Frog

Access all Frogames courses, communities and extras

39 /month

  • Single payment of 39€ per month
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress

Database Path

Access all courses in the Database Path

19.99 /month

  • Single payment of 19.99€ per month
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress

One-time payment

Buy the course once and access it for life

49.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Valorado

Gold Frog

Access all Frogames courses, communities and extras

349 /year

  • Single payment of €349 per year
  • 3 months of discount
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Resource Library
  • Monthly Q&A livestreams
  • Premium support

Database Path

Access all courses in the Database Path

199 /year

  • Single annual payment of €199
  • 4 months of discount
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Premium support

* All prices include taxes.

For your security, all orders will be processed on a secure server.

Database Path

The ultimate bundle with all our Database courses so you can learn everything you need to know about SQL and databases. Includes upcoming courses and updates and improvements to current ones.

Git y GitHub de la A a la Z: Todo sobre el control de versiones

Learn the fundamental concepts and essential workflow for version control using Git and GitHub from scratch!

106 classes

Introduction to Databases

Learn the fundamentals of how digital representations work and how they connect with the real world and abstract concepts. Master database terminology from A to Z.

76 classes

Fundamentos del Modelo Relacional de Datos y Álgebra Relacional

Dive into the world of relational algebra and advance with steady steps in the world of databases

70 classes

SQL from A to Z

From creating databases to having total control of your queries, this course will take you from beginner to expert in handling data efficiently

86 classes

Diseño de bases de datos de la A a la Z

Learn about database design, from initial concepts to SQL implementation

76 classes

Databases: Learn SQL from scratch

Learn SQL, the language of databases, from scratch with practical exercises to master loading, querying, modifying and managing your data while learning all the key SQL commands.

82 classes

Business Data Science con Python y SQL Server

Data Analysis for Business Decision Making based on Descriptive, Diagnostic, Predictive and Prescriptive Analytics

51 classes

Power BI, SQL y Desarrollo Web integrados para Seguimiento de Tareas

The BI analyst must have the ability to identify data potentially important for the business and that, when processed, can become a solid foundation for decision-making.

38 classes

Ciencia de datos con MySQL, RStudio y Power BI: Casos Reales

Put yourself in the shoes of a data scientist looking at different real-world scenarios

54 classes