{"id":377,"date":"2024-03-21T20:58:47","date_gmt":"2024-03-21T20:58:47","guid":{"rendered":"https:\/\/soseduca.net\/?page_id=377"},"modified":"2024-07-20T13:53:38","modified_gmt":"2024-07-20T13:53:38","slug":"bases-de-datos-relacionales-mysql","status":"publish","type":"page","link":"https:\/\/soseduca.net\/?page_id=377","title":{"rendered":"Bases de datos relacionales MySQL"},"content":{"rendered":"\n\n\nLas bases de datos relacionales son sistemas de almacenamiento y gesti\u00f3n de informaci\u00f3n que organizan los datos en tablas estructuradas con filas y columnas. Utilizan un lenguaje de consulta llamado SQL (Structured Query Language) para acceder y manipular los datos. La clave de su dise\u00f1o radica en la relaci\u00f3n entre las diferentes tablas, lo que permite establecer conexiones y realizar consultas complejas para obtener informaci\u00f3n espec\u00edfica. Este enfoque ofrece flexibilidad, eficiencia y coherencia en la gesti\u00f3n de datos, lo que lo convierte en uno de los modelos m\u00e1s populares para aplicaciones empresariales y de software.\n\n\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/ttXUI8T7hJs?si=XvJhXcRTS5ZkBtfo\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<p>Introducci\u00f3n, \u00bfPor qu\u00e9 aprender bases de datos?<\/p>\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/Apj02at-Cic?si=Zc6YQLd3XTN-9ved\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<p>01. Entiende el modelo Entidad Relaci\u00f3n<\/p>\n\n\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/yeg7HerCxp8?si=gcrX_oBlxr9tZFBk\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<p>1.1. \u00bfQu\u00e9 es una relaci\u00f3n reciproca en bases de datos?<\/p>\n\n\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/qvKCfp4OWxw?si=h7ozkfkRlXWNCO5G\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n02. Cardinalidades en las relaciones que se dan entre las entidades\n\n\nEspacio para anuncios\nEspacio para anuncios\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/n0jdIJnwXzg?si=32CR9vvSSYJ2wPLH\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n03. Propagaci\u00f3n de llaves primarias a llaves for\u00e1neas de acuerdo a la cardinalidad.\n\n\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/3X1QW36zkwg?si=MfMJNVxn6bQZpJjL\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n3.1. Explicaci\u00f3n corta de propagaci\u00f3n de llave primaria a for\u00e1nea.\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/4r0Q93aY_48?si=2zNvihXeNXKBkOQ6\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n04. Pasar de modelo Entidad \/ Relaci\u00f3n a Modelo L\u00f3gico Relacional, o Modelo de Tablas.\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/vrdX1d--9ks?si=6ev3jhfcyG926GKp\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n05. Normalizaci\u00f3n de la base de datos\n\n\n\n\n<p><iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/UIxkQE3VvSs?si=-RCQkWAwuqUE3LOk\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n06. Descarga e instalaci\u00f3n de XAMPP, gestor de bases de datos con PHPMyAdmin.\n\n\nEspacio para anuncios\nEspacio para anuncios\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/fAZVE8km-3o?si=tSVoiTjg7YjTpZX4\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n07. Crear base de datos y tablas en phpMyAdmin con XAMPP\n\n\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/RBoixds_wG0?si=3-k5o85J4b9A06wm\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n08. Restricciones de integridad referencial entre llaves primarias y for\u00e1neas en phpMyAdmin XAMPP\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/0v3_HoanN7Y?si=nX2eo71LY6E0GOpD\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n09. Relacionar tablas de acuerdo a las llaves primarias y for\u00e1neas del  modelo relacional.\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/ht4Ly6gPdB0?si=28BYxew1wZdu1Ra-\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n10. Ingresar registros a tabla de una base de datos usando PHPMyAdmin con Xampp\n\n\n\n\n<iframe loading=\"lazy\" width=\"100%\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/hmsZkrw5hZc?si=HgZWfrNl9bw1eah3\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n11. Exportar base de datos, hacer copia de seguridad de la base de datos desde PHPMyAdmin Xampp\n\n\nespacio para anuncio\nEspacio para anuncio\n\n\nEspacio para anuncio\nEspacio para anuncio\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":35,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-377","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/soseduca.net\/index.php?rest_route=\/wp\/v2\/pages\/377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soseduca.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/soseduca.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/soseduca.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soseduca.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=377"}],"version-history":[{"count":13,"href":"https:\/\/soseduca.net\/index.php?rest_route=\/wp\/v2\/pages\/377\/revisions"}],"predecessor-version":[{"id":487,"href":"https:\/\/soseduca.net\/index.php?rest_route=\/wp\/v2\/pages\/377\/revisions\/487"}],"up":[{"embeddable":true,"href":"https:\/\/soseduca.net\/index.php?rest_route=\/wp\/v2\/pages\/35"}],"wp:attachment":[{"href":"https:\/\/soseduca.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}