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

5.0 /5
(22)

70
Bienvenidos al curso de Álgebra Relacional
Cuales son los objetivos de aprendizaje del curso
Cómo sacarle el máximo partido al curso
Toma notas de tu curso en tiempo real en Frogames Formación
Los tres aspectos del modelo relacional
Objetivos principales del modelo relacional
Introducción
Visión informal de una relación
Visión formal de una relación: Dominios
Visión formal de una relación: Esquema y Extensión
Visión formal de una relación: Atributos y Dominios
Visión formal de una relación: Tuplas y Extensión
Visión formal de una relación: el valor nulo
Visión formal de una relación: grado y cardinalidad
Diferencias entre relaciones y ficheros
Superclaves
Clave candidata, clave primaria y clave alternativa de las relaciones
Repasemos los tipos de claves
Ejercicio de claves
Solución al ejercicio de claves
Las claves foráneas de una relación
Ejemplos de Claves foráneas de las relaciones
Definición formal de clave foránea
Consecuencias de las claves foráneas
Creación de las relaciones de una base de datos
¿Cuales son las operaciones que podemos hacer en el modelo relacional?
Actualizaciones en Base de Datos
Formas de especificar una consulta
¿Qué es la Integridad en los datos?
Regla de integridad de unicidad de la clave primaria
Regla de integridad de entidad de la clave primaria
Regla de integridad referencial
Políticas de actualización: Restricción
Políticas de actualización: En Cascada
Políticas de actualización: Anulación
Regla de Integridad del Dominio
El álgebra relacional
Base de datos del tema Álgebra Relacional
Cierre relacional
Clasificación de las operaciones
La operación de redenominar
El ejemplo de base de datos
Operaciones Conjuntistas: Unión
Operaciones Conjuntistas: Intersección
Operaciones Conjuntistas: Diferencia
Operaciones Conjuntísticas: Producto Cartesiano
Operaciones Relacionales: Selección
Operaciones Relacionales: Proyección
Operaciones Relacionales: Combinación
Operadores de la combinación
Combinación Natural
Secuencias de Operaciones del Álgebra Relacional
Ejercicios de Secuencias de Operaciones
Solución del ejercicio anterior
Combinaciones Externas
Ejemplos de Outer Joins
Ejercicio 1
Ejercicio 2
Ejercicio 3
Solución Ejercicio 3
Ejercicio 4
Solución Ejercicio 4
Ejercicio 5
Solución Ejercicio 5
Ejercicio 6
Solución Ejercicio 6
Ejercicio 7
Solución Ejercicio 7
Para terminar
Hemos terminado una aventura juntos, ¡pero vamos a por la siguiente!

instructor

5.0 /5
(22)

  • Avatar
    Nieves
    (5)
    Learn Mathematics from Scratch – Integral Calculus: master the area under the curve, integration techniques and real-world applications

    This course teaches you the fundamentals of integral calculus from scratch, ideal for students who want to understand the concept of antiderivative, the area under the curve and classic integration techniques. You'll learn to solve definite and indefinite integrals, apply the Fundamental Theorem of Calculus, and use methods like substitution, integration by parts and partial fractions.

  • Avatar
    Jorge
    (5)
    The fundamentals really clicked for me!

    It gave me huge peace of mind to understand the real foundation behind all of this.

  • Avatar
    Javi
    (5)
    The foundation I was missing

    It's like learning the rules of the game to stop making rookie mistakes.

  • Avatar
    Santiago
    (5)
    Great course

  • Avatar
    Giovanni
    (5)
    Theory Makes the Difference

    We often overlook the theoretical side, but understanding relational algebra and data model fundamentals let me design much more efficient systems. The course explains with amazing clarity why things work the way they do, giving you a really solid academic foundation that shows the moment you write any complex query

  • Avatar
    Nicolás
    (5)
    10/10

  • Avatar
    Rocío
    (5)
    I give it 5 stars. Very complete and practical

  • Avatar
    Jackeline
    (5)
    This course helped me see that databases aren't just tables and SQL

  • Avatar
    María
    (5)
    I finally understood the relational model

    This was one of the topics that was hardest for me and with this course, everything just clicked. Relational algebra is explained with incredible clarity and now I understand how databases really work. Every minute was worth it!

  • Avatar
    Angel
    (5)
    Relational Model and Relational Algebra: the mathematical logic behind databases

    This course offers a solid introduction to the fundamentals of the relational data model, the theoretical foundation that underpins most current database management systems. Through clear explanations and guided exercises, you'll learn how to structure information in tables, define relationships between entities, and apply integrity rules to ensure consistency.

  • Avatar
    Rosa
    (5)
    very interesting

  • Avatar
    Gustavo
    (5)
    Think data through logic: a brilliant intro to the relational model

    The Relational Data Model Fundamentals and Relational Algebra course is a learning experience that achieves what many attempt: teaching the theoretical pillars of databases clearly, in a structured way, and with a practical focus. Ideal for computer science students, data analysts, or anyone who wants to understand how information is modeled in modern systems.

  • Avatar
    Maria del Mar
    (5)
    Great course!

    Very theoretical but necessary, thank goodness Juan Gabriel makes it engaging!!

  • Avatar
    Samuel
    (5)
    Now I feel more confident with databases.

    At first I felt lost, but the course structure is so clear that I ended up understanding everything without any trouble.

  • Avatar
    Gabriela
    (5)
    Everything clicked

    Now I can organize information in a much more professional way

  • Avatar
    Alberto
    (5)
    fundamental for understanding Databases

    It can get a bit heavy since it's almost all mathematical theory but it shifts your perspective and the learning is really rewarding, I loved it

  • Avatar
    Carlos
    (5)
    Relational Algebra to understand databases in depth

    This course gave me a solid foundation to understand how databases work at a theoretical level, explaining clearly how to manipulate data with mathematical and logical operations. What I liked most was how each concept is reinforced with practical exercises, which allowed me to apply the theory right away. Now I feel much more prepared to work with relational databases with a structured approach.

  • Avatar
    Yvonne
    (5)
    Good foundation

    It's a great foundation for understanding relational models

  • Avatar
    Omaira
    (5)
    Great content

    Excellent content, precise and with everything you need to know about relational algebra to better understand relational database models

  • Avatar
    danison
    (5)
    5-star recommendation.

    The Fundamentals of the Relational Data Model and Relational Algebra course is an excellent introduction for those who want to learn about the basic principles of relational data models and relational algebra. The course starts by explaining the key concepts of the relational model and how it has been widely adopted in the industry, followed by an introduction to relational algebra and how it can be used to perform searches and manipulate data in a relational model.

  • Avatar
    Joiser
    (5)
    Very helpful for my learning

    It helped me understand clearly how relational databases work, from their structure to how to perform complex queries using relational algebra

  • Avatar
    Caty
    (5)
    100% Recommended

    I would recommend this course to anyone interested in learning relational algebra. It's very comprehensive and the instructors are excellent.

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