{"id":320868,"date":"2026-04-01T08:33:50","date_gmt":"2026-04-01T14:33:50","guid":{"rendered":"https:\/\/ucenfotec.ac.cr\/ecommerce\/?post_type=product&#038;p=320868"},"modified":"2026-07-10T13:03:02","modified_gmt":"2026-07-10T19:03:02","slug":"sql-360-programacion-y-optimizacion-de-consultas","status":"publish","type":"product","link":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/","title":{"rendered":"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas"},"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:1331.2px;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\">SQL 360 constituye un enfoque de aprendizaje hol\u00edstico y de inmersi\u00f3n total en el ecosistema de bases de datos relacionales, dise\u00f1ado para transformar la interacci\u00f3n con los motores de datos desde una perspectiva de consulta declarativa b\u00e1sica hacia un dominio completo de programaci\u00f3n y optimizaci\u00f3n f\u00edsica.<\/span><\/p>\n<p><span data-sheets-root=\"1\">Las principales tem\u00e1ticas por abordar en el curso se agrupan en tres fases de especializaci\u00f3n: los fundamentos relacionales avanzados y subconsultas complejas, la programaci\u00f3n SQL en el servidor (procedimientos, funciones, triggers, control transaccional y comparaci\u00f3n sint\u00e1ctica de dialectos), y finalmente, la optimizaci\u00f3n operativa de consultas mediante la interpretaci\u00f3n t\u00e9cnica de planes de ejecuci\u00f3n, indexaci\u00f3n avanzada, prevenci\u00f3n de bloqueos (deadlocks) y monitoreo con Dynamic Management Views (DMVs).<\/span><\/p>\n<p><span data-sheets-root=\"1\">El curso est\u00e1 dise\u00f1ado por competencias y alineado con el marco global de habilidades y competencias para un mundo digital SFIA, por lo que se propone que los estudiantes logren responder a un nivel de responsabilidad 4, de manera que desarrollan y mantienen conocimientos especializados sobre conceptos de bases de datos y almacenes de datos, principios de dise\u00f1o, arquitecturas, software e instalaciones.<\/span><\/p>\n<hr \/>\n<p><strong>Contenidos<\/strong><\/p>\n<p><span data-sheets-root=\"1\">1. Introducci\u00f3n a bases de datos.<br \/>\n2. Consultas b\u00e1sicas.<br \/>\n3. Manipulaci\u00f3n de datos.<br \/>\n4. Relaciones entre tablas.<br \/>\n5. An\u00e1lisis de datos.<br \/>\n6. Subconsultas.<br \/>\n7. Introducci\u00f3n a programaci\u00f3n SQL.<br \/>\n8. Procedimientos almacenados.<br \/>\n9. Funciones SQL.<br \/>\n10. Triggers.<br \/>\n11. Transacciones.<br \/>\n12. Manejo de errores.<br \/>\n13. Comparaci\u00f3n entre dialectos SQL.<br \/>\n14. Arquitectura de ejecuci\u00f3n de consultas.<br \/>\n15. Execution Plans.<br \/>\n16. Indexaci\u00f3n.<br \/>\n17. Optimizaci\u00f3n de consultas.<br \/>\n18. Concurrencia.<br \/>\n19. Monitoreo de rendimiento.<\/span><\/p>\n<hr \/>\n<\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p><span data-sheets-root=\"1\">Este curso integra la programaci\u00f3n avanzada y optimizaci\u00f3n de bases de datos mediante procedimientos, triggers y planes de ejecuci\u00f3n para potenciar el rendimiento t\u00e9cnico y la escalabilidad de consultas en entornos corporativos.<\/span><\/p>\n","protected":false},"featured_media":373037,"template":"","meta":{"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_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":""},"product_brand":[],"product_cat":[3082,44],"product_tag":[1072,1335,3195,2974,2977,3197,2886,2018,1991,2179,2976,3199,786,1828,3198,1035,787,1070,2975,3196,884,3194,885],"class_list":["post-320868","product","type-product","status-publish","has-post-thumbnail","product_cat-cenfotec-360","product_cat-ingenieria-del-software","product_tag-analisis-de-datos","product_tag-bases-de-datos","product_tag-consultas-basicas","product_tag-consultas-sql","product_tag-data-querying","product_tag-dialectos-de-bases-de-datos","product_tag-execution-plans","product_tag-manejo-de-errores","product_tag-manipulacion-de-datos","product_tag-modelo-relacional","product_tag-modelos-relacionales","product_tag-monitoreo-de-rendimiento","product_tag-mysql","product_tag-optimizacion-de-consultas","product_tag-optimizacion-sql","product_tag-oracle","product_tag-postgresql","product_tag-programacion","product_tag-programacion-sql","product_tag-relaciones-entre-tablas","product_tag-sql","product_tag-sql-360","product_tag-sql-server","first","instock","virtual","sold-individually","taxable","purchasable","product-type-simple"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.0 (Yoast SEO v28.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas<\/title>\n<meta name=\"description\" content=\"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.\" \/>\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\/sql-360-programacion-y-optimizacion-de-consultas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas\" \/>\n<meta property=\"og:description\" content=\"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/\" \/>\n<meta property=\"og:site_name\" content=\"Cursos - CENFOTEC\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-10T19:03:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2026\/04\/360-WebBannerArtboard-1-80.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:description\" content=\"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/\",\"url\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/\",\"name\":\"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/wp-content\\\/uploads\\\/sites\\\/13\\\/2026\\\/04\\\/360-WebBannerArtboard-1-80.jpg\",\"datePublished\":\"2026-04-01T14:33:50+00:00\",\"dateModified\":\"2026-07-10T19:03:02+00:00\",\"description\":\"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/wp-content\\\/uploads\\\/sites\\\/13\\\/2026\\\/04\\\/360-WebBannerArtboard-1-80.jpg\",\"contentUrl\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/wp-content\\\/uploads\\\/sites\\\/13\\\/2026\\\/04\\\/360-WebBannerArtboard-1-80.jpg\",\"width\":500,\"height\":650,\"caption\":\"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas - Universidad CENFOTEC\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ucenfotec.ac.cr\\\/ecommerce\\\/producto\\\/sql-360-programacion-y-optimizacion-de-consultas\\\/#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\":\"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas\"}]},{\"@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":"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas","description":"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.","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\/sql-360-programacion-y-optimizacion-de-consultas\/","og_locale":"es_ES","og_type":"article","og_title":"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas","og_description":"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.","og_url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/","og_site_name":"Cursos - CENFOTEC","article_modified_time":"2026-07-10T19:03:02+00:00","og_image":[{"width":500,"height":650,"url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2026\/04\/360-WebBannerArtboard-1-80.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_description":"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/","url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/","name":"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas","isPartOf":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/#primaryimage"},"image":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/#primaryimage"},"thumbnailUrl":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2026\/04\/360-WebBannerArtboard-1-80.jpg","datePublished":"2026-04-01T14:33:50+00:00","dateModified":"2026-07-10T19:03:02+00:00","description":"Domina la arquitectura de ejecuci\u00f3n y el monitoreo de rendimiento SQL para optimizar consultas complejas y gestionar transacciones con alta eficiencia.","breadcrumb":{"@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/#primaryimage","url":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2026\/04\/360-WebBannerArtboard-1-80.jpg","contentUrl":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-content\/uploads\/sites\/13\/2026\/04\/360-WebBannerArtboard-1-80.jpg","width":500,"height":650,"caption":"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas - Universidad CENFOTEC"},{"@type":"BreadcrumbList","@id":"https:\/\/ucenfotec.ac.cr\/ecommerce\/producto\/sql-360-programacion-y-optimizacion-de-consultas\/#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":"SQL 360: Programaci\u00f3n y Optimizaci\u00f3n de Consultas"}]},{"@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\/320868","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\/373037"}],"wp:attachment":[{"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/media?parent=320868"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product_brand?post=320868"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product_cat?post=320868"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/ucenfotec.ac.cr\/ecommerce\/wp-json\/wp\/v2\/product_tag?post=320868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}