{"id":4050,"date":"2021-03-16T10:07:34","date_gmt":"2021-03-16T13:07:34","guid":{"rendered":"https:\/\/Itapua.uy\/es\/?page_id=4050"},"modified":"2022-05-04T13:17:49","modified_gmt":"2022-05-04T16:17:49","slug":"curso-mssql-utilizacion-de-sql-y-tsql","status":"publish","type":"page","link":"https:\/\/itapua.com.uy\/es\/index.php\/curso-mssql-utilizacion-de-sql-y-tsql\/","title":{"rendered":"Curso-MSSQL-Utilizaci\u00f3n de SQL y TSQL"},"content":{"rendered":"
\n \n
\n \n \n
\n \n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n \n

Curso: Utilizaci\u00f3n de lenguaje SQL y TSQL sobre SQL Server<\/strong><\/h1>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/path><\/svg><\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n
\n \n \n
\n \n
\n \n
\n \n \n
DIRIGIDO A<\/span><\/h5>\n <\/div>\n <\/div>\n
\n \n \n
\n

Desarrolladores<\/span><\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/path><\/svg><\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n
\n \n \n
\n \n
\n \n
\n \n \n
BENEFICIOS<\/span><\/h5>\n <\/div>\n <\/div>\n
\n \n \n
\n
    \n
  • Familiarizarse con los conceptos b\u00e1sicos de las bases de datos Relacionales<\/span><\/li>\n
  • Comprender la sintaxis b\u00e1sica del lenguaje SQL<\/span><\/li>\n
  • Estudiar diferentes mecanismos de b\u00fasqueda, manipulaci\u00f3n y extracci\u00f3n de datos y construcci\u00f3n de scripts.<\/span><\/li>\n
  • Aprender a recuperar y manipular datos de una a o m\u00e1s tablas<\/span><\/li>\n
  • Definir consultas complejas basadas en m\u00faltiples condiciones<\/span><\/li>\n
  • Conocer el lenguaje TSQL de programaci\u00f3n y las construcciones que ofrece.<\/span><\/li>\n <\/ul>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
    \n
    \n \n \n
    \n \n
    \n \n
    \n \n
    \n
    \n \n \n
    \n \n
    \n <\/path><\/svg><\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n
    \n
    \n \n \n
    \n \n
    \n \n
    \n \n \n
    CARGA HORARIA<\/span><\/h5>\n <\/div>\n <\/div>\n
    \n \n \n
    \n

    32 horas<\/span><\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

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

    Modelo Relacional<\/strong><\/p>\n

      \n
    • Historia<\/li>\n
    • Tablas y Columnas<\/li>\n
    • Restricciones de integridad<\/li>\n
    • Caracter\u00edsticas del Lenguaje SQL<\/li>\n
    • Diccionario de Datos<\/li>\n <\/ul>\n

      \n
      \n <\/p>\n

      Introducci\u00f3n al SQL Server Management Studio<\/strong><\/p>\n

        \n
      • Caracter\u00edsticas B\u00e1sicas<\/li>\n
      • Interfaz<\/li>\n
      • Establecer conexiones<\/li>\n
      • Objetos de la base de datos<\/li>\n
      • Consultas SQL<\/li>\n <\/ul>\n

        \n
        \n <\/p>\n

        Sentencia SELECT<\/strong><\/p>\n

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

          \n
          \n <\/p>\n

          Manipulaci\u00f3n de datos<\/strong><\/p>\n

            \n
          • Inserci\u00f3n De Datos<\/li>\n
          • Modificaci\u00f3n De Datos<\/li>\n
          • Borrado De Datos<\/li>\n <\/ul>\n

            \n
            \n <\/p>\n

            Lenguaje Transact-SQL<\/strong><\/p>\n

              \n
            • Estructuras de Control y Transacciones<\/li>\n
            • Manejo de Excepciones<\/li>\n
            • Tipos de datos y declaraci\u00f3n de variables<\/li>\n
            • Tablas temporales<\/li>\n
            • Tablas variable<\/li>\n
            • Manejo de Cursores<\/li>\n <\/ul>\n

              \n
              \n <\/p>\n

              Funciones SQL<\/strong><\/p>\n

                \n
              • Funciones Num\u00e9ricas<\/li>\n
              • Funciones de Caracteres<\/li>\n
              • Funciones de Fechas<\/li>\n
              • Funciones de Conversi\u00f3n de Tipos<\/li>\n
              • Funciones de usuario<\/li>\n <\/ul>\n

                \n
                \n <\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"

                Curso: Utilizaci\u00f3n de lenguaje SQL y TSQL sobre SQL Server DIRIGIDO A Desarrolladores BENEFICIOS Familiarizarse con los conceptos b\u00e1sicos de las bases de datos Relacionales Comprender la sintaxis b\u00e1sica del lenguaje SQL Estudiar diferentes mecanismos de b\u00fasqueda, manipulaci\u00f3n y extracci\u00f3n de datos y construcci\u00f3n de scripts. Aprender a recuperar y manipular datos de una a […]<\/p>\n","protected":false},"author":1,"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-4050","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/4050","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/comments?post=4050"}],"version-history":[{"count":8,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/4050\/revisions"}],"predecessor-version":[{"id":10603,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/4050\/revisions\/10603"}],"wp:attachment":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/media?parent=4050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}