{"id":175787,"date":"2025-12-03T13:07:54","date_gmt":"2025-12-03T19:07:54","guid":{"rendered":"https:\/\/ucenfotec.ac.cr\/ecommerce\/?post_type=product&#038;p=175787"},"modified":"2026-02-24T13:49:47","modified_gmt":"2026-02-24T19:49:47","slug":"oracle-sql-y-administracion-de-bases-de-datos","status":"publish","type":"product","link":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/","title":{"rendered":"Oracle SQL y Administraci\u00f3n de Bases de Datos"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-1\"><p><span data-sheets-root=\"1\">Este curso desarrolla competencias en dise\u00f1o, consulta y administraci\u00f3n de bases de datos Oracle mediante SQL y Oracle APEX, fortaleciendo la gesti\u00f3n, seguridad e integridad de la informaci\u00f3n en entornos empresariales.<\/span><\/p>\n<hr \/>\n<p><strong>Contenidos<\/strong><\/p>\n<p><span data-sheets-root=\"1\">1. Oracle Application Express.<br \/>\n2. Tecnolog\u00eda de Base de Datos Relacional.<br \/>\n3. Anatom\u00eda de una Sentencia SQL.<br \/>\n4. Columnas, Caracteres y Filas.<br \/>\n5. Limitaci\u00f3n de Filas Seleccionadas.<br \/>\n6. Operadores de Comparaci\u00f3n, Comparaciones L\u00f3gicas y Reglas de Prioridad.<br \/>\n7. Ordenaci\u00f3n de Filas.<br \/>\n8. Introducci\u00f3n a las Funciones.<br \/>\n9. Manipulaci\u00f3n de May\u00fasculas Min\u00fasculas y de Caracteres.<br \/>\n10. Funciones Num\u00e9ricas.<br \/>\n11. Funciones de Fecha.<br \/>\n12. Funciones de Conversi\u00f3n,<br \/>\n13. Funciones NULL.<br \/>\n14. Expresiones Condicionales.<br \/>\n15. Uniones Cruzadas y Uniones Naturales.<br \/>\n16. Cl\u00e1usulas de Uni\u00f3n.<br \/>\n17. Uniones Internas vs Externas.<br \/>\n18. Autouniones y Consultas Jer\u00e1rquicas.<br \/>\n19. Uni\u00f3n Igualitaria y Producto Cartesiano de Oracle.<br \/>\n20. Uniones No Igualitarias y Uniones Externas de Oracle.<br \/>\n21. Funciones de Grupo.<br \/>\n22. COUNT DISTINCT NVL.<br \/>\n23. Group By y Having.<br \/>\n24. ROLLUP CUBE y GROUPING SETS.<br \/>\n25. Operadores SET.<br \/>\n26. Conceptos Fundamentales de Subconsultas.<br \/>\n27. Garant\u00eda de Resultados de Consultas de Calidad.<br \/>\n28. Sentencias INSERT, UPDATE y DELETE.<br \/>\n29. DEFAULT MERGE e Inserciones en Varias Tablas.<br \/>\n30. Creaci\u00f3n de Tablas.<br \/>\n31. Uso de Tipos de Dato.<br \/>\n32. Modificaci\u00f3n de una Tabla.<br \/>\n33. Restricciones NOT NULL y UNIQUE.<br \/>\n34. Restricciones PRIMARY KEY FOREIGN KEY y CHECK.<br \/>\n35. Gesti\u00f3n de Restricciones.<br \/>\n36. Creaci\u00f3n de Vistas.<br \/>\n37. Operaciones DML y Vistas.<br \/>\n38. Gesti\u00f3n de Vistas.<br \/>\n39. Trabajar con Secuencias, \u00cdndices y Sin\u00f3nimos.<br \/>\n40. Control del Acceso de los Usuarios.<br \/>\n41. Creaci\u00f3n y Revocaci\u00f3n de Privilegios de Objeto.<br \/>\n42. Expresiones Regulares.<br \/>\n43. Transacciones de Base de Datos (TCL).<\/span><\/p>\n<hr \/>\n<p><strong>Certificado e Insignia Digital<\/strong><\/p>\n<p>Al finalizar el curso el estudiante obtiene un t\u00edtulo e Insignia digital, socializable en tiempo real basada en tecnolog\u00eda blockchain que permite una vista m\u00e1s completa tras el logro alcanzado por el estudiante al poderla vincular con evidencias del resultado del aprendizaje en su perfil profesional. Es una certificaci\u00f3n segura.<\/p>\n<p><a href=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos.png\"><img decoding=\"async\" class=\"lazyload aligncenter size-full wp-image-175788\" src=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos.png\" data-orig-src=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos.png\" alt=\"\" width=\"300\" height=\"300\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%27300%27%20height%3D%27300%27%20viewBox%3D%270%200%20300%20300%27%3E%3Crect%20width%3D%27300%27%20height%3D%27300%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos-66x66.png 66w, https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos-100x100.png 100w, https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos-150x150.png 150w, https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos-200x200.png 200w, https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2025\/12\/TI-710-Oracle-SQL-y-Administracion-de-Bases-de-Datos.png 300w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<hr \/>\n<\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p><span data-sheets-root=\"1\">Este curso desarrolla competencias en dise\u00f1o, consulta y administraci\u00f3n de bases de datos Oracle mediante SQL y Oracle APEX, fortaleciendo la gesti\u00f3n, seguridad e integridad de la informaci\u00f3n en entornos empresariales.<\/span><\/p>\n","protected":false},"featured_media":53378,"template":"","meta":{"_relevanssi_hide_post":"on","_relevanssi_hide_content":"on","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"WooCommerce Yoast SEO Relevanssi index exclude"},"product_brand":[],"product_cat":[1087,16],"product_tag":[2821,1764,2180,2820],"class_list":{"0":"post-175787","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-agotado","7":"product_cat-tecnologias-de-informacion","8":"product_tag-administracion-de-bases-de-datos","9":"product_tag-funciones","10":"product_tag-tablas","11":"product_tag-tecnologias-de-informacion-ti-710-oracle-sql-y-administracion-de-bases-de-datos-oracle-sql","13":"first","14":"outofstock","15":"virtual","16":"sold-individually","17":"taxable","18":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle SQL y Administraci\u00f3n de Bases de Datos<\/title>\n<meta name=\"description\" content=\"Domine Oracle SQL y APEX para dise\u00f1ar, consultar y administrar bases de datos empresariales con eficiencia, seguridad e integridad de la informaci\u00f3n.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle SQL y Administraci\u00f3n de Bases de Datos\" \/>\n<meta property=\"og:description\" content=\"Domine Oracle SQL y APEX para dise\u00f1ar, consultar y administrar bases de datos empresariales con eficiencia, seguridad e integridad de la informaci\u00f3n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/\" \/>\n<meta property=\"og:site_name\" content=\"Cursos - CENFOTEC\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-24T19:49:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2022\/05\/Information-Technology.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"650\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/\",\"url\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/\",\"name\":\"Oracle SQL y Administraci\u00f3n de Bases de Datos\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/wp-content\\\/uploads\\\/sites\\\/13\\\/2022\\\/05\\\/Information-Technology.jpg\",\"datePublished\":\"2025-12-03T19:07:54+00:00\",\"dateModified\":\"2026-02-24T19:49:47+00:00\",\"description\":\"Domine Oracle SQL y APEX para dise\u00f1ar, consultar y administrar bases de datos empresariales con eficiencia, seguridad e integridad de la informaci\u00f3n.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/wp-content\\\/uploads\\\/sites\\\/13\\\/2022\\\/05\\\/Information-Technology.jpg\",\"contentUrl\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/wp-content\\\/uploads\\\/sites\\\/13\\\/2022\\\/05\\\/Information-Technology.jpg\",\"width\":500,\"height\":650,\"caption\":\"Tecnolog\u00edas de Informaci\u00f3n - Universidad CENFOTEC\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/oracle-sql-y-administracion-de-bases-de-datos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Todos los Cursos\",\"item\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/todos-los-cursos\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Oracle SQL y Administraci\u00f3n de Bases de Datos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/#website\",\"url\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/\",\"name\":\"Cursos - CENFOTEC\",\"description\":\"Tienda en l\u00ednea de cursos ofrecidos por CENFOTEC\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle SQL y Administraci\u00f3n de Bases de Datos","description":"Domine Oracle SQL y APEX para dise\u00f1ar, consultar y administrar bases de datos empresariales con eficiencia, seguridad e integridad de la informaci\u00f3n.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/","og_locale":"es_ES","og_type":"article","og_title":"Oracle SQL y Administraci\u00f3n de Bases de Datos","og_description":"Domine Oracle SQL y APEX para dise\u00f1ar, consultar y administrar bases de datos empresariales con eficiencia, seguridad e integridad de la informaci\u00f3n.","og_url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/","og_site_name":"Cursos - CENFOTEC","article_modified_time":"2026-02-24T19:49:47+00:00","og_image":[{"width":500,"height":650,"url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2022\/05\/Information-Technology.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/","url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/","name":"Oracle SQL y Administraci\u00f3n de Bases de Datos","isPartOf":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/#primaryimage"},"image":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2022\/05\/Information-Technology.jpg","datePublished":"2025-12-03T19:07:54+00:00","dateModified":"2026-02-24T19:49:47+00:00","description":"Domine Oracle SQL y APEX para dise\u00f1ar, consultar y administrar bases de datos empresariales con eficiencia, seguridad e integridad de la informaci\u00f3n.","breadcrumb":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/#primaryimage","url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2022\/05\/Information-Technology.jpg","contentUrl":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2022\/05\/Information-Technology.jpg","width":500,"height":650,"caption":"Tecnolog\u00edas de Informaci\u00f3n - Universidad CENFOTEC"},{"@type":"BreadcrumbList","@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/oracle-sql-y-administracion-de-bases-de-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/ucenfotec.ac.cr\/ecommerce\/"},{"@type":"ListItem","position":2,"name":"Todos los Cursos","item":"https:\/\/ucenfotec.ac.cr\/ecommerce\/todos-los-cursos\/"},{"@type":"ListItem","position":3,"name":"Oracle SQL y Administraci\u00f3n de Bases de Datos"}]},{"@type":"WebSite","@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/#website","url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/","name":"Cursos - CENFOTEC","description":"Tienda en l\u00ednea de cursos ofrecidos por CENFOTEC","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ucenfotec.ac.cr\/ecommerce\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"}]}},"_links":{"self":[{"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product\/175787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/media\/53378"}],"wp:attachment":[{"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/media?parent=175787"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product_brand?post=175787"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product_cat?post=175787"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product_tag?post=175787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}