{"id":8485,"date":"2022-03-14T22:00:37","date_gmt":"2022-03-15T01:00:37","guid":{"rendered":"https:\/\/Itapua.uy\/es\/?page_id=8485"},"modified":"2022-03-14T22:17:44","modified_gmt":"2022-03-15T01:17:44","slug":"curso-postgresql_desarrolloaplicaciones","status":"publish","type":"page","link":"https:\/\/itapua.com.uy\/es\/index.php\/curso-postgresql_desarrolloaplicaciones\/","title":{"rendered":"Curso-PostgreSQL_DesarrolloAplicaciones"},"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: Desarrollo de Aplicaciones Sobre PostgreSQL<\/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 una visi\u00f3n integrada de un ambiente de trabajo con un servidor de Base de Datos PostgreSQL y herramientas de desarrollo. <\/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 Estudiar diferentes mecanismos de b\u00fasqueda, manipulaci\u00f3n y extracci\u00f3n de datos y construcci\u00f3n de scripts. <\/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 Estudiar las diferentes alternativas de programaci\u00f3n en las bases de datos y, en particular, estudiar el lenguaje PL\/pgSQL. <\/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 Conocer m\u00e9todos de dise\u00f1o de BD y aplicaciones para obtener la m\u00e1xima performance. <\/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 reconocer y solucionar diferentes problemas de performance. <\/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
      \r\n
    • Desarrolladores de Aplicaciones sobre Bases de Datos <\/span><\/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<\/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

      Introducci\u00f3n al servidor\u202fPostgreSQL\u200b<\/strong>\r\n  <\/span>\r\n <\/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\u200b <\/span><\/li>\r\n
      • Principales caracter\u00edsticas\u200b <\/span><\/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

        Arquitectura<\/strong> <\/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
        • Estructura f\u00edsica de un cl\u00faster de\u202fPostgreSQL\u200b <\/span><\/li>\r\n
        • Estructuras de memoria\u200b <\/span><\/li>\r\n
        • Archivos de configuraci\u00f3n\u200b <\/span><\/li>\r\n
        • Procesos del cl\u00faster\u200b <\/span><\/li>\r\n
        • Establecimiento de conexiones y sesiones.\u200b <\/span><\/li>\r\n
        • Mecanismos de\u202flogging\u200b <\/span><\/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

          Estructuras de la capa l\u00f3gica\u200b<\/strong>\r\n  <\/span>\r\n <\/p>\r\n <\/div>\r\n <\/div>\r\n

          \r\n \r\n \r\n
          \r\n
            \r\n
          • Objetos globales y objetos de un esquema\u200b <\/span><\/li>\r\n
          • Tablas y vistas\u200b <\/span><\/li>\r\n
          • \u00cdndices\u200b <\/span><\/li>\r\n
          • Secuencias\u202f\u200b <\/span><\/li>\r\n
          • Funciones y\u202ftriggers\u200b <\/span><\/li>\r\n
          • Elementos del diccionario de datos\u200b <\/span><\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n
            \r\n \r\n \r\n
            \r\n

            Seguridad<\/strong><\/p>\r\n <\/div>\r\n <\/div>\r\n

            \r\n \r\n \r\n
            \r\n
              \r\n
            • Usuarios y esquemas\u200b <\/span><\/li>\r\n
            • Privilegios y roles <\/span><\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n
              \r\n \r\n \r\n
              \r\n

              Utilizaci\u00f3n del Servidor para Consultas<\/strong>\r\n  <\/span>\r\n <\/p>\r\n <\/div>\r\n <\/div>\r\n

              \r\n \r\n \r\n
              \r\n
                \r\n
              • Soporte para Globalizaci\u00f3n <\/span><\/li>\r\n
              • Tipos de datos de columnas. Escalares y compuestos.  <\/span><\/li>\r\n
              • Expresiones y operadores.  <\/span><\/li>\r\n
              • Manipulaci\u00f3n de datos en el servidor, inserci\u00f3n y actualizaci\u00f3n  <\/span><\/li>\r\n
              • Uso de psql. <\/span><\/li>\r\n
              • Capacidades de extensi\u00f3n del servidor <\/span><\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n
                \r\n \r\n \r\n
                \r\n

                Concurrencia y consistencia<\/strong>\r\n  <\/span>\r\n <\/p>\r\n <\/div>\r\n <\/div>\r\n

                \r\n \r\n \r\n
                \r\n
                  \r\n
                • Mecanismo MVCC  <\/span><\/li>\r\n
                • Manejo de Transacciones y consistencia de lectura <\/span><\/li>\r\n
                • Concurrencia: Bloqueos y Deadlock <\/span><\/li>\r\n
                • Transacciones distribuidas usando dblinks <\/span><\/li>\r\n
                • Vacuum y vacuum full <\/span><\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n
                  \r\n \r\n \r\n
                  \r\n

                  Lenguaje PL\/PgSQL<\/strong><\/p>\r\n <\/div>\r\n <\/div>\r\n

                  \r\n \r\n \r\n
                  \r\n
                    \r\n
                  • Bloques, variables, constantes y par\u00e1metros <\/span><\/li>\r\n
                  • Estructuras de Control y Transacciones <\/span><\/li>\r\n
                  • Manejo de Excepciones <\/span><\/li>\r\n
                  • Manejo de Cursores <\/span><\/li>\r\n
                  • Funciones <\/span><\/li>\r\n
                  • Estructuras de Datos <\/span><\/li>\r\n
                  • Cargas masivas de datos <\/span><\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n
                    \r\n \r\n \r\n
                    \r\n

                    Conceptos de Optimizaci\u00f3n de Aplicaciones<\/strong><\/p>\r\n <\/div>\r\n <\/div>\r\n

                    \r\n \r\n \r\n
                    \r\n
                      \r\n
                    • Tipos de aplicaci\u00f3n <\/span><\/li>\r\n
                    • Diferencias entre optimizaci\u00f3n de instancia y de aplicaciones  <\/span><\/li>\r\n
                    • Problemas t\u00edpicos de performance y sugerencias generales  <\/span><\/li>\r\n
                    • Herramientas para Optimizaci\u00f3n <\/span><\/li>\r\n
                    •    Vistas para Performance <\/span><\/li>\r\n
                    •    PG_Log y PG_Budger <\/span><\/li>\r\n
                    •    Registro de Aplicaciones usando Set Application Name. <\/span><\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n
                      \r\n \r\n \r\n
                      \r\n

                      Optimizaci\u00f3n de Sentencias SQL<\/strong>\r\n  <\/span>\r\n <\/p>\r\n <\/div>\r\n <\/div>\r\n

                      \r\n \r\n \r\n
                      \r\n
                        \r\n
                      • Procesamiento de Sentencias SQL <\/span><\/li>\r\n
                      • Obtenci\u00f3n de Plan de Ejecuci\u00f3n <\/span><\/li>\r\n
                      • Recolecci\u00f3n de Estad\u00edsticas <\/span><\/li>\r\n
                      • Recomendaciones para Uso de \u00edndices <\/span><\/li>\r\n
                      • Particionamiento de tablas <\/span><\/li>\r\n <\/ul>\r\n <\/div>\r\n <\/div>\r\n
                        \r\n \r\n \r\n
                        \r\n

                        Recomendaciones y buenas pr\u00e1cticas de uso de Servidores de Aplicaciones sobre PostgreSQL<\/strong><\/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: Desarrollo de Aplicaciones Sobre PostgreSQL BENEFICIOS Presentar una visi\u00f3n integrada de un ambiente de trabajo con un servidor de Base de Datos PostgreSQL y herramientas de desarrollo. Estudiar diferentes mecanismos de b\u00fasqueda, manipulaci\u00f3n y extracci\u00f3n de datos y construcci\u00f3n de scripts. Estudiar las diferentes alternativas de programaci\u00f3n en las bases de datos y, en […]<\/p>\n","protected":false},"author":16,"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-8485","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/8485","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\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/comments?post=8485"}],"version-history":[{"count":3,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/8485\/revisions"}],"predecessor-version":[{"id":8501,"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/pages\/8485\/revisions\/8501"}],"wp:attachment":[{"href":"https:\/\/itapua.com.uy\/es\/index.php\/wp-json\/wp\/v2\/media?parent=8485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}