{"id":7031,"date":"2021-03-30T11:05:53","date_gmt":"2021-03-30T14:05:53","guid":{"rendered":"https:\/\/Itapua.uy\/es\/?page_id=7031"},"modified":"2023-08-08T11:31:15","modified_gmt":"2023-08-08T14:31:15","slug":"lenguaje-sql","status":"publish","type":"page","link":"https:\/\/itapua.com.uy\/es\/index.php\/lenguaje-sql\/","title":{"rendered":"Curso-FundamentosBasesDatos-LenguajeSQL"},"content":{"rendered":"
\r\n \r\n
\r\n \r\n \r\n
\r\n \r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n \r\n \r\n
\r\n \r\n
\r\n \r\n
\r\n \r\n \r\n

Curso: Lenguaje SQL<\/strong><\/h1>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n \r\n \r\n
\r\n \r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n \r\n \r\n
\r\n \r\n
\r\n <\/path><\/svg><\/span><\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
\r\n
\r\n \r\n \r\n
\r\n \r\n
\r\n \r\n
\r\n \r\n \r\n
BENEFICIOS<\/h5>\r\n <\/div>\r\n <\/div>\r\n
\r\n \r\n
    \r\n \r\n
  • \r\n \r\n
    <\/div>
    <\/path><\/svg><\/span><\/div>\r\n Presentar los conceptos b\u00e1sicos de las bases de datos Relacionales<\/span><\/span>\r\n <\/div>\r\n <\/span>\r\n
    \r\n \r\n <\/div>\r\n <\/li>\r\n
  • \r\n \r\n
    <\/path><\/svg><\/span><\/div>\r\n Comprender la sintaxis b\u00e1sica del lenguaje SQL<\/span><\/span>\r\n <\/div>\r\n <\/span>\r\n
    \r\n \r\n <\/div>\r\n <\/li>\r\n
  • \r\n \r\n
    <\/path><\/svg><\/span><\/div>\r\n Aprender a recuperar y manipular datos de una a o m\u00e1s tablas<\/span><\/span>\r\n <\/div>\r\n <\/span>\r\n
    \r\n \r\n <\/div>\r\n <\/li>\r\n
  • \r\n \r\n
    <\/path><\/svg><\/span><\/div>\r\n Definir consultas complejas basadas en m\u00faltiples condiciones<\/span><\/span>\r\n <\/div>\r\n <\/span>\r\n
    \r\n \r\n <\/div>\r\n <\/li>\r\n
  • \r\n \r\n
    <\/path><\/svg><\/span><\/div>\r\n Aprender a construir y mantener estructuras de bases de datos<\/span><\/span>\r\n <\/div>\r\n <\/span>\r\n
    \r\n \r\n <\/div>\r\n
    <\/div>\r\n <\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
    \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n <\/path><\/svg><\/span><\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
    \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    DIRIGIDO A<\/span><\/h5>\r\n <\/div>\r\n <\/div>\r\n
    \r\n \r\n \r\n
    \r\n

    Usuarios finales, Desarrolladores, Testers, Administradores de Bases de Datos <\/span><\/p>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n

    \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n <\/path><\/svg><\/span><\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
    \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    ReqUISITOS PREVIOS<\/span><\/h5>\r\n <\/div>\r\n <\/div>\r\n
    \r\n \r\n
      \r\n \r\n
    • \r\n \r\n
      <\/div>
      <\/path><\/svg><\/span><\/div>\r\n Curso: Fundamentos de Bases de Datos <\/span><\/span>\r\n <\/div>\r\n <\/span>\r\n
      \r\n \r\n <\/div>\r\n
      <\/div>\r\n <\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
      \r\n
      \r\n \r\n \r\n
      \r\n \r\n
      \r\n \r\n
      \r\n \r\n
      \r\n
      \r\n \r\n \r\n
      \r\n \r\n
      \r\n <\/path><\/svg><\/span><\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
      \r\n
      \r\n \r\n \r\n
      \r\n \r\n
      \r\n \r\n
      \r\n \r\n \r\n
      CARGA HORARIA<\/span><\/h5>\r\n <\/div>\r\n <\/div>\r\n
      \r\n \r\n \r\n
      \r\n

      30 horas<\/span><\/p>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n

      \r\n
      \r\n \r\n \r\n
      \r\n \r\n
      \r\n \r\n
      \r\n \r\n
      \r\n
      \r\n \r\n \r\n
      \r\n \r\n
      \r\n <\/path><\/svg><\/span><\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
      \r\n
      \r\n \r\n \r\n
      \r\n \r\n
      \r\n \r\n
      \r\n \r\n \r\n
      Contenido<\/span><\/h5>\r\n <\/div>\r\n <\/div>\r\n
      \r\n \r\n \r\n
      \r\n

      Modelo Relacional y RDBMS<\/strong><\/p>\r\n <\/div>\r\n <\/div>\r\n

      \r\n \r\n
      \r\n \r\n
      \r\n
      \r\n \r\n \r\n
      \r\n \r\n
      \r\n \r\n \r\n
      \r\n
        \r\n
      • Historia<\/li>\r\n
      • Tablas y Columnas<\/li>\r\n
      • Restricciones de integridadCaracter\u00edsticas del Lenguaje SQL<\/li>\r\n
      • Funciones del Sistema de Gesti\u00f3n de Bases de Datos (RDBMS) (*)<\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
        \r\n
        \r\n \r\n \r\n
        \r\n \r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
        \r\n \r\n \r\n
        \r\n

        Introducci\u00f3n a la Herramienta de Acceso a Base de Datos (*)<\/strong><\/p>\r\n <\/div>\r\n <\/div>\r\n

        \r\n \r\n
        \r\n \r\n
        \r\n
        \r\n \r\n \r\n
        \r\n \r\n
        \r\n \r\n \r\n
        \r\n
          \r\n
        • Caracter\u00edsticas B\u00e1sicas<\/li>\r\n
        • Interfaz<\/li>\r\n
        • Establecer conexiones<\/li>\r\n
        • \u00c1rboles de objetos de la base de datos<\/li>\r\n
        • Diagramas<\/li>\r\n
        • Escritura y ejecuci\u00f3n de consultas SQL<\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
          \r\n
          \r\n \r\n \r\n
          \r\n \r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
          \r\n \r\n \r\n
          \r\n

          Sentencia SELECT est\u00e1ndar:<\/span><\/p>\r\n <\/div>\r\n <\/div>\r\n

          \r\n \r\n
          \r\n \r\n
          \r\n
          \r\n \r\n \r\n
          \r\n \r\n
          \r\n \r\n \r\n
          \r\n
            \r\n
          • Consulta b\u00e1sica<\/li>\r\n
          • Selecci\u00f3n condicional<\/li>\r\n
          • Operadores l\u00f3gicos<\/li>\r\n
          • Listas y rangos de valores<\/li>\r\n
          • Operadores LIKE<\/li>\r\n
          • Cl\u00e1usula DISTINCT<\/li>\r\n
          • Ordenamiento de los datos<\/li>\r\n
          • Joins<\/li>\r\n
          • Subconsultas<\/li>\r\n
          • Funciones de Agregaci\u00f3n y agrupamiento de filas<\/li>\r\n
          • Operadores de Conjuntos (Uni\u00f3n, Intersecci\u00f3n, Diferencia)<\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
            \r\n
            \r\n \r\n \r\n
            \r\n \r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
            \r\n \r\n \r\n
            \r\n

            Extensiones al SELECT provistas por el RDBMS (*)<\/strong><\/p>\r\n <\/div>\r\n <\/div>\r\n

            \r\n \r\n \r\n
            \r\n

            Conceptos b\u00e1sicos de optimizaci\u00f3n<\/strong><\/p>\r\n <\/div>\r\n <\/div>\r\n

            \r\n \r\n \r\n
            \r\n

            Sentencias de manipulaci\u00f3n de datos (DML):<\/span><\/p>\r\n <\/div>\r\n <\/div>\r\n

            \r\n \r\n
            \r\n \r\n
            \r\n
            \r\n \r\n \r\n
            \r\n \r\n
            \r\n \r\n \r\n
            \r\n
              \r\n
            • INSERT<\/li>\r\n
            • UPDATE<\/li>\r\n
            • DELETE<\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
              \r\n
              \r\n \r\n \r\n
              \r\n \r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
              \r\n \r\n \r\n
              \r\n

              Sentencias de creaci\u00f3n de tablas y vistas (DDL)<\/span><\/p>\r\n <\/div>\r\n <\/div>\r\n

              \r\n \r\n
              \r\n \r\n
              \r\n
              \r\n \r\n \r\n
              \r\n \r\n
              \r\n \r\n \r\n
              \r\n
                \r\n
              • CREATE<\/li>\r\n
              • ALTER<\/li>\r\n
              • DROP<\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
                \r\n
                \r\n \r\n \r\n
                \r\n \r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n
                \r\n \r\n \r\n
                \r\n

                (*) El contenido se adec\u00faa al Sistema de Gesti\u00f3n de Bases de Datos (RDBMS) y herramienta de acceso a Base de Datos que el cliente requiera.<\/em><\/p>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>","protected":false},"excerpt":{"rendered":"

                Curso: Lenguaje SQL BENEFICIOS Presentar los conceptos b\u00e1sicos de las bases de datos Relacionales Comprender la sintaxis b\u00e1sica del lenguaje SQL Aprender a recuperar y manipular datos de una a o m\u00e1s tablas Definir consultas complejas basadas en m\u00faltiples condiciones Aprender a construir y mantener estructuras de bases de datos DIRIGIDO A Usuarios finales, Desarrolladores, Testers, Administradores […]<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/full-width-page.php","meta":{"footnotes":""},"class_list":["post-7031","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/7031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/comments?post=7031"}],"version-history":[{"count":17,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/7031\/revisions"}],"predecessor-version":[{"id":7948,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/7031\/revisions\/7948"}],"wp:attachment":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/media?parent=7031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}