{"id":11888,"date":"2024-04-23T19:23:43","date_gmt":"2024-04-23T22:23:43","guid":{"rendered":"https:\/\/site.redlearning.cl\/?post_type=product&#038;p=11888"},"modified":"2025-11-03T17:35:43","modified_gmt":"2025-11-03T20:35:43","slug":"curso-mysql","status":"publish","type":"product","link":"https:\/\/site.redlearning.cl\/?product=curso-mysql","title":{"rendered":"Curso MYSQL"},"content":{"rendered":"<p>MySQL es la BBDD relacional opensource m\u00e1s utilizada m\u00e1s utilizada del mundo, con 6 millones de instalaciones. MySQL es utilizada por sitios web de referencia mundial como Wikipedia, Google, Facebook, Twitter, Flickr y YouTube, as\u00ed como por las aplicaciones web opensource de mayor relevancia WordPress, Drupal, Joomla, Prestashop, Magento, Moodle, SugarCRM, Zimbra.<\/p>\n<p>De este modo, se esta creando en el mundo una nueva forma de comunicarse a trav\u00e9s de la internet con nuevas formas de conectarse, de trabajar y de estudiar.<\/p>\n<p>La internet ha remodelado esquemas de comunicaci\u00f3n entre las personas y organizaciones. Ya conocemos la inmensa potencialidad de la red de redes. Entonces como profesional del \u00e1rea, no se puede desconocer la forma de desarrollar aplicaciones en el lenguaje m\u00e1s popular de la web, esto es esencial para diferenciarse del simple dise\u00f1o de p\u00e1ginas est\u00e1ticas. Este curso pretende avanzar y profundizar con los alumnos de programaci\u00f3n de p\u00e1ginas web en lenguaje PHP con bases de datos MySQL para el desarrollo de sitios web interactivos y din\u00e1micos.<\/p>\n<h2><span style=\"color: #0099cd;\">Objetivo General<\/span><\/h2>\n<hr \/>\n<p>Gestionar bases de datos MySQL conociendo y administrando las distintas arquitecturas en que se puede desplegar MySQL, con la finalidad de implantarlas en entornos de producci\u00f3n.<\/p>\n<h2><span style=\"color: #0099cd;\">Metodolog\u00eda<\/span><\/h2>\n<hr \/>\n<p>Modalidad 100% Online, asincr\u00f3nico y a tu ritmo. Contar\u00e1s con tutores desde el principio al fin de tu formaci\u00f3n, nunca estar\u00e1s sol@.<\/p>\n<h2><span style=\"color: #0099cd;\">Temario<\/span><\/h2>\n<hr \/>\n<div class=\"lightweight-accordion bordered has-text-color has-background\"><details><summary class=\"lightweight-accordion-title\" style=\"color:#ffffff;background:#0099cd;\"><span>M\u00f3dulo I - Configuraci\u00f3n PHP e Introducci\u00f3n a MySQL<\/span><\/summary><div class=\"lightweight-accordion-body\" style=\"border-color:#0099cd;\"><h6><span style=\"color: #0099cd;\">Objetivos espec\u00edficos: <\/span>Identificar los componentes dentro del archivo PHP.ini, integrado con el motor de datos MySQL<\/h6>\n<h6><span style=\"color: #0099cd;\">Duraci\u00f3n: <\/span>20 horas<\/h6>\n<h6><span style=\"color: #0099cd;\">Contenidos:<\/span><\/h6>\n<ul>\n<li>Qu\u00e9 es y para qu\u00e9 sirve PHP.ini<\/li>\n<li>Resolviendo problemas de configuraci\u00f3n PHP.<\/li>\n<li>MySQL Server y Client<\/li>\n<li>Bases de datos MySQL<\/li>\n<li>Normalizaci\u00f3n de bases de datos<\/li>\n<\/ul>\n<\/div><\/details><\/div>\n<div class=\"lightweight-accordion bordered has-text-color has-background\"><details><summary class=\"lightweight-accordion-title\" style=\"color:#ffffff;background:#0099cd;\"><span>M\u00f3dulo II - MySQL usando PDO_MySQ<\/span><\/summary><div class=\"lightweight-accordion-body\" style=\"border-color:#0099cd;\"><h6><span style=\"color: #0099cd;\">Objetivos espec\u00edficos: <\/span>Conocer MySQL sus tablas, y tipos de datos, para dise\u00f1ar sitios web y aplicaciones din\u00e1micas.<\/h6>\n<h6><span style=\"color: #0099cd;\">Duraci\u00f3n: <\/span>20 horas<\/h6>\n<h6><span style=\"color: #0099cd;\">Contenidos:<\/span><\/h6>\n<ul>\n<li>Introducci\u00f3n al lenguaje SGBD&#8217;s, SQL y MySQL<\/li>\n<li>Estructura SQL de un Jquery<\/li>\n<li>Sentencia Select, Como hacer un Jquery, querys usando Join, Join Left, Join Right.<\/li>\n<li>Funciones de uso frecuente en MySQL, Count, group by, where in, etc.<\/li>\n<\/ul>\n<\/div><\/details><\/div>\n<div class=\"lightweight-accordion bordered has-text-color has-background\"><details><summary class=\"lightweight-accordion-title\" style=\"color:#ffffff;background:#0099cd;\"><span>M\u00f3dulo III - HTML CSS3 y Jquery<\/span><\/summary><div class=\"lightweight-accordion-body\" style=\"border-color:#0099cd;\"><h6><span style=\"color: #0099cd;\">Objetivos espec\u00edficos: <\/span>Determinar el dinamismo dentro de las aplicaciones y p\u00e1ginas web mediante integraci\u00f3n de MySQL y software de dise\u00f1o.<\/h6>\n<h6><span style=\"color: #0099cd;\">Duraci\u00f3n: <\/span>20 horas<\/h6>\n<h6><span style=\"color: #0099cd;\">Contenidos:<\/span><\/h6>\n<ul>\n<li>MySQL Stored Procedures (Rutinas Almacenadas)<\/li>\n<li>MySQL Trigges y MySQL Vistas<\/li>\n<li>Transacciones y eventos en MySQL<\/li>\n<li>Servidores y Software GUI<\/li>\n<\/ul>\n<\/div><\/details><\/div>\n<div class=\"lightweight-accordion bordered has-text-color has-background\"><details><summary class=\"lightweight-accordion-title\" style=\"color:#ffffff;background:#0099cd;\"><span>M\u00f3dulo Final - Estudio de caso<\/span><\/summary><div class=\"lightweight-accordion-body\" style=\"border-color:#0099cd;\"><h6><span style=\"color: #0099cd;\">PROYECTO DE INTEGRACIO\u00d3N FINAL <\/span><\/h6>\n<h6><span style=\"color: #0099cd;\">TEST GLOBAL<\/span><\/h6>\n<h6><span style=\"color: #0099cd;\">Duraci\u00f3n: <\/span>10 horas<\/h6>\n<h6><span style=\"color: #0099cd;\">Objetivos espec\u00edficos: <\/span>Dise\u00f1ar una aplicacion web de complejidad avanzada a trav\u00e9s de c\u00f3digo PHP y base de datos MySQL.<\/h6>\n<\/div><\/details><\/div>\n","protected":false},"excerpt":{"rendered":"<p><span style=\"color: #0099cd;\">Resumen del Curso<\/span><\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-333\" style=\"font-weight: inherit;\" src=\"https:\/\/linketeach.cl\/wp-content\/uploads\/2021\/07\/education_computer_school_graduate_cap_monitor_icon_149680.png\" alt=\"\" width=\"48\" height=\"48\" \/>70 horas &#8211; 4 m\u00f3dulos<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-332\" src=\"https:\/\/linketeach.cl\/wp-content\/uploads\/2021\/07\/education_book_learn_learning_icon_149694.png\" alt=\"\" width=\"48\" height=\"48\" \/><a href=\"https:\/\/site.redlearning.cl\/wp-content\/uploads\/2022\/05\/c-mysql.pdf\" target=\"_blank\" rel=\"noopener\">Programa del Curso<\/a><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-335\" src=\"https:\/\/linketeach.cl\/wp-content\/uploads\/2021\/07\/notes_clipboard_icon_149712-1.png\" alt=\"\" width=\"48\" height=\"48\" \/>Evaluaci\u00f3n Final<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-334\" style=\"font-weight: inherit;\" src=\"https:\/\/linketeach.cl\/wp-content\/uploads\/2021\/07\/education_diploma_award_icon_149701.png\" alt=\"\" width=\"48\" height=\"48\" \/>Certificaci\u00f3n<\/p>\n","protected":false},"featured_media":11889,"template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_joinchat":[]},"product_brand":[],"product_cat":[425],"product_tag":[],"class_list":{"0":"post-11888","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-cursos","7":"desktop-align-left","8":"tablet-align-left","9":"mobile-align-left","11":"first","12":"instock","13":"sale","14":"downloadable","15":"virtual","16":"sold-individually","17":"purchasable","18":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=\/wp\/v2\/product\/11888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=\/wp\/v2\/media\/11889"}],"wp:attachment":[{"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11888"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_brand&post=11888"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=11888"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/site.redlearning.cl\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=11888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}