{"id":1882,"date":"2023-10-28T14:01:08","date_gmt":"2023-10-28T12:01:08","guid":{"rendered":"https:\/\/abacformacio.com\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/"},"modified":"2025-12-08T20:34:17","modified_gmt":"2025-12-08T19:34:17","slug":"el-lenguaje-de-manipulacion-de-la-base-de-datos","status":"publish","type":"post","link":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/","title":{"rendered":"El lenguaje de manipulaci\u00f3n de la base de datos"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[49],"tags":[],"class_list":["post-1882","post","type-post","status-publish","format-standard","hentry","category-online-es"],"acf":{"codi_de_referencia":"CT2628","objectius":"<ul>\n \t<li>Formular consultas de manipulaci\u00f3n y definici\u00f3n de datos, a partir del dise\u00f1o de la BBDD y de los requisitos de usuario Explicar el tipo de consultas (de selecci\u00f3n, actualizaci\u00f3n, inserci\u00f3n, borrado) que se pueden realizar utilizando el lenguaje DML Describir las herramientas de la base de datos para la optimizaci\u00f3n de consultas.<\/li>\n<\/ul>","continguts":"1 El lenguaje de definici\u00f3n de datos (DDL).\n\n2. El lenguaje de manipulaci\u00f3n de datos (DML).\n\n3. Cl\u00e1usulas de la lengua para agrupar y ordenar las consultas.\n\n4. Habilidades aritm\u00e9ticas, l\u00f3gicas y de lenguaje de comparaci\u00f3n.\n\n5. Funciones agregadas del lenguaje.\n\n6. Tratamiento de valores nulos.\n\n7. Construcci\u00f3n de consultas imbricadas.\n\n8. Uni\u00f3n, intersecci\u00f3n y diferencia de consultas.\n\n9. Consultas entre tablas.\n\n10. Otras cl\u00e1usulas de la lengua.\n\n11. Extensiones de idioma.\n\n12. El lenguaje de control de datos (DCL).\n\n13. Procesamiento y optimizaci\u00f3n de consultas.","avaluacio_i_certificat":"S\u00cd","hores_lectives":70,"filtros_tematica":["Ofim\u00e0tica"]},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>El lenguaje de manipulaci\u00f3n de la base de datos - Abac Formaci\u00f3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"El lenguaje de manipulaci\u00f3n de la base de datos - Abac Formaci\u00f3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/\" \/>\n<meta property=\"og:site_name\" content=\"Abac Formaci\u00f3\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-28T12:01:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-08T19:34:17+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#\\\/schema\\\/person\\\/0c5171c1077314e832716c749877c53c\"},\"headline\":\"El lenguaje de manipulaci\u00f3n de la base de datos\",\"datePublished\":\"2023-10-28T12:01:08+00:00\",\"dateModified\":\"2025-12-08T19:34:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/\"},\"wordCount\":10,\"publisher\":{\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#organization\"},\"articleSection\":[\"Online\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/\",\"url\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/\",\"name\":\"El lenguaje de manipulaci\u00f3n de la base de datos - Abac Formaci\u00f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#website\"},\"datePublished\":\"2023-10-28T12:01:08+00:00\",\"dateModified\":\"2025-12-08T19:34:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/el-lenguaje-de-manipulacion-de-la-base-de-datos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"El lenguaje de manipulaci\u00f3n de la base de datos\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/\",\"name\":\"Abac Formaci\u00f3\",\"description\":\"Formaci\u00f3 subvencionada i bonificada a Lleida\",\"publisher\":{\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#organization\",\"name\":\"Abac Formaci\u00f3\",\"url\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/abacformacio.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/formacio-empreses-lleida-abac-e1698183049887.png\",\"contentUrl\":\"https:\\\/\\\/abacformacio.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/formacio-empreses-lleida-abac-e1698183049887.png\",\"width\":1042,\"height\":203,\"caption\":\"Abac Formaci\u00f3\"},\"image\":{\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/#\\\/schema\\\/person\\\/0c5171c1077314e832716c749877c53c\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08a944ee45f3e1d24dff60115a23744b8132a2f21f620a513dcee8557d94a9f9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08a944ee45f3e1d24dff60115a23744b8132a2f21f620a513dcee8557d94a9f9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08a944ee45f3e1d24dff60115a23744b8132a2f21f620a513dcee8557d94a9f9?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/abacformacio.com\"],\"url\":\"https:\\\/\\\/abacformacio.com\\\/es\\\/author\\\/lagrafica\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"El lenguaje de manipulaci\u00f3n de la base de datos - Abac Formaci\u00f3","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:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/","og_locale":"es_ES","og_type":"article","og_title":"El lenguaje de manipulaci\u00f3n de la base de datos - Abac Formaci\u00f3","og_url":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/","og_site_name":"Abac Formaci\u00f3","article_published_time":"2023-10-28T12:01:08+00:00","article_modified_time":"2025-12-08T19:34:17+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/#article","isPartOf":{"@id":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/"},"author":{"name":"admin","@id":"https:\/\/abacformacio.com\/es\/#\/schema\/person\/0c5171c1077314e832716c749877c53c"},"headline":"El lenguaje de manipulaci\u00f3n de la base de datos","datePublished":"2023-10-28T12:01:08+00:00","dateModified":"2025-12-08T19:34:17+00:00","mainEntityOfPage":{"@id":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/"},"wordCount":10,"publisher":{"@id":"https:\/\/abacformacio.com\/es\/#organization"},"articleSection":["Online"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/","url":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/","name":"El lenguaje de manipulaci\u00f3n de la base de datos - Abac Formaci\u00f3","isPartOf":{"@id":"https:\/\/abacformacio.com\/es\/#website"},"datePublished":"2023-10-28T12:01:08+00:00","dateModified":"2025-12-08T19:34:17+00:00","breadcrumb":{"@id":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/abacformacio.com\/es\/el-lenguaje-de-manipulacion-de-la-base-de-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/abacformacio.com\/es\/"},{"@type":"ListItem","position":2,"name":"El lenguaje de manipulaci\u00f3n de la base de datos"}]},{"@type":"WebSite","@id":"https:\/\/abacformacio.com\/es\/#website","url":"https:\/\/abacformacio.com\/es\/","name":"Abac Formaci\u00f3","description":"Formaci\u00f3 subvencionada i bonificada a Lleida","publisher":{"@id":"https:\/\/abacformacio.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/abacformacio.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/abacformacio.com\/es\/#organization","name":"Abac Formaci\u00f3","url":"https:\/\/abacformacio.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abacformacio.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/abacformacio.com\/wp-content\/uploads\/2023\/10\/formacio-empreses-lleida-abac-e1698183049887.png","contentUrl":"https:\/\/abacformacio.com\/wp-content\/uploads\/2023\/10\/formacio-empreses-lleida-abac-e1698183049887.png","width":1042,"height":203,"caption":"Abac Formaci\u00f3"},"image":{"@id":"https:\/\/abacformacio.com\/es\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/abacformacio.com\/es\/#\/schema\/person\/0c5171c1077314e832716c749877c53c","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/08a944ee45f3e1d24dff60115a23744b8132a2f21f620a513dcee8557d94a9f9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/08a944ee45f3e1d24dff60115a23744b8132a2f21f620a513dcee8557d94a9f9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08a944ee45f3e1d24dff60115a23744b8132a2f21f620a513dcee8557d94a9f9?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/abacformacio.com"],"url":"https:\/\/abacformacio.com\/es\/author\/lagrafica\/"}]}},"publishpress_future_action":{"enabled":false,"date":"2026-06-02 07:25:25","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/posts\/1882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/comments?post=1882"}],"version-history":[{"count":1,"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/posts\/1882\/revisions"}],"predecessor-version":[{"id":3601,"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/posts\/1882\/revisions\/3601"}],"wp:attachment":[{"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/media?parent=1882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/categories?post=1882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/abacformacio.com\/es\/wp-json\/wp\/v2\/tags?post=1882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}