{"id":833,"date":"2019-12-27T18:27:34","date_gmt":"2019-12-27T21:27:34","guid":{"rendered":"http:\/\/escoladeprogramadores.com.br\/site\/?page_id=833"},"modified":"2025-08-18T20:10:42","modified_gmt":"2025-08-18T23:10:42","slug":"curso-de-sql-db2","status":"publish","type":"page","link":"https:\/\/escoladeprogramadores.com.br\/2025\/curso-de-sql-db2\/","title":{"rendered":"Curso de SQL DB2"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"833\" class=\"elementor elementor-833\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2b94cb56 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2b94cb56\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-209fb138\" data-id=\"209fb138\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ab0205a elementor-widget elementor-widget-image\" data-id=\"1ab0205a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"340\" height=\"171\" src=\"https:\/\/escoladeprogramadores.com.br\/2025\/wp-content\/uploads\/2019\/12\/SQL_DB2_miniBannerFinal.jpg\" class=\"attachment-large size-large wp-image-651\" alt=\"\" srcset=\"https:\/\/escoladeprogramadores.com.br\/2025\/wp-content\/uploads\/2019\/12\/SQL_DB2_miniBannerFinal.jpg 340w, https:\/\/escoladeprogramadores.com.br\/2025\/wp-content\/uploads\/2019\/12\/SQL_DB2_miniBannerFinal-300x151.jpg 300w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-365e1a21\" data-id=\"365e1a21\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d474c74 elementor-widget elementor-widget-text-editor\" data-id=\"4d474c74\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1><strong>Valor do curso <br><span style=\"color: #ff0000;\">R$ 149,00 <span style=\"font-size: 16px;\"> (em at\u00e9 4x) <\/span> <\/span><\/strong><\/h1>\n<p>Instrutor: Ivan<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4d86b82 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4d86b82\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-128d620d\" data-id=\"128d620d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6fea46ea elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"6fea46ea\" data-element_type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1871\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-1871\" aria-expanded=\"false\">Sobre o curso<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1872\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1872\" aria-expanded=\"false\">Conteudos abordados<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1873\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1873\" aria-expanded=\"false\">Como funciona o curso !<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1874\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"4\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1874\" aria-expanded=\"false\">Curriculo dos instrutores<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1875\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"5\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1875\" aria-expanded=\"false\">Aula Aberta<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-1871\" aria-expanded=\"false\">Sobre o curso<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1871\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1871\" tabindex=\"0\" hidden=\"false\"><div><div><h5><strong>Objetivo<\/strong><\/h5><p>Conhecer a linguagem SQL e o uso no DB2 em um ambiente de alta plataforma<\/p><h5><strong>Publico Alvo<\/strong><\/h5><p>Suporte, Produ\u00e7\u00e3o e Desenvolvedores de Sistemas.<\/p><\/div><h5><strong>Pr\u00e9-Requisitos<\/strong><\/h5><p>Conhecimento b\u00e1sico de TSO.<\/p><h5><strong>Equipamentos necess\u00e1rios:<\/strong><\/h5><p>Computador ou tablet com acesso a qualquer navegador WEB com 1GB mem\u00f3ria<\/p><div><h5><strong>Carga Horaria: <\/strong><\/h5><p>12 horas &#8211;\u00a0 ( Tempo previsto para conclus\u00e3o do curso e suporte as duvidas de 01 mes \/ <strong>As video aulas s\u00e3o vitalicias<\/strong> )<\/p><p>Todo o conteudo \u00e9 ministrado com video-aulas onde professor conduz cada aula com a conceituacao teorica e em seguida propoe a atividade pratica , que poder\u00e1 ser feita (dependendo do curso) na maquina do aluno ou no ambiente PRATICO\u00a0 exclusivamente educacional disponibilizado .O sucesso do curso esta no acompanhamento destas aulas e a disciplina de assistir e fazer os exercicios.<\/p><p><b>Observa\u00e7\u00e3o:<\/b> O acesso as aulas e laborat\u00f3rio pr\u00e1tico ser\u00e1 enviado por email em at\u00e9 04 (quatro) horas ap\u00f3s a confirma\u00e7\u00e3o da compra.\u00a0<\/p><\/div><\/div><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1872\" aria-expanded=\"false\">Conteudos abordados<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1872\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1872\" tabindex=\"0\" hidden=\"hidden\"><h4><span style=\"color: #000000;\"><strong>M\u00f3dulo: Modelagem de Dados<br \/><\/strong><\/span><\/h4><p><span style=\"color: #999999;\"><em>Breve introdu\u00e7\u00e3o a modelagem de um banco de dados<br \/><\/em><\/span><\/p><ul><li>Conceito de Banco de Dados<\/li><li>Tipos de Banco de Dados<\/li><li>Arquiteturas<\/li><li>Diagrama de Entidade e Relacionamento (DER)<\/li><li>Chaves Prim\u00e1rias e Estrangeiras<\/li><li>Normaliza\u00e7\u00e3o de tabelas (1a &#8211; 3a Forma Normal)<\/li><\/ul><h4><strong>M\u00f3dulo: <\/strong> Linguagem SQL na Pr\u00e1tica<\/h4><ul><li>Um pouco de TSO<\/li><li>Conhecendo o ambiente QMF<\/li><li>SQL &#8211; DDL<\/li><li>\u00a0\u00a0\u00a0 Create Table \/ Index<\/li><li>\u00a0\u00a0\u00a0 Integridade Referencial \/ Alter Table<\/li><li>SQL &#8211; DML<\/li><li>\u00a0\u00a0\u00a0 Insert \/ \u00a0Update \/ Delete<\/li><li>\u00a0\u00a0\u00a0 Select\u00a0<\/li><li>\u00a0\u00a0\u00a0\u00a0 Where<\/li><li>\u00a0\u00a0\u00a0\u00a0 Between<\/li><li>\u00a0\u00a0\u00a0 \u00a0 In<\/li><li>\u00a0\u00a0\u00a0 \u00a0 Distinct<\/li><li>\u00a0\u00a0\u00a0\u00a0 Sum\/Max\/Min\/AVG<\/li><li>\u00a0\u00a0\u00a0\u00a0 Join com where<\/li><li>\u00a0\u00a0\u00a0 \u00a0 Inner Join<\/li><li>\u00a0 \u00a0\u00a0\u00a0 Left e Rigth Join<\/li><li>\u00a0\u00a0\u00a0\u00a0 Like<\/li><li>\u00a0 \u00a0\u00a0\u00a0 Group BY<\/li><li>\u00a0\u00a0\u00a0\u00a0 Substr<\/li><li>\u00a0 \u00a0\u00a0\u00a0 Vis\u00f5es (View)<\/li><li>\u00a0\u00a0\u00a0 \u00a0 Check e Constraints<\/li><\/ul><hr \/><p><strong>IMPORTANTE : O curso contratado \u00e9 composto por VIDEO AULAS e apostilas de apoio.<\/strong><br \/><strong>Os exercicios propostos pelo professor podem ser exercitados em qualquer ambiente que possua TSO e QMF.<\/strong><br \/><strong>Oferecemos aos alunos acesso a um ambiente EXCLUSIVAMENTE educacional para pratica desses exercicios.<\/strong><br \/><strong><i>Esse ambiente n\u00e3o faz parte da compra do curso e sim \u00e9 oferecido como apoio apenas a fixacao dos exercicios.<\/i><\/strong><\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1873\" aria-expanded=\"false\">Como funciona o curso !<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1873\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1873\" tabindex=\"0\" hidden=\"hidden\"><div style=\"padding: 52.81% 0 0 0; position: relative;\">\u00a0<\/div><p><script src=\"https:\/\/player.vimeo.com\/api\/player.js\"><\/script><\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"4\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1874\" aria-expanded=\"false\">Curriculo dos instrutores<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1874\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"4\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1874\" tabindex=\"0\" hidden=\"hidden\"><p><img decoding=\"async\" class=\"alignnone wp-image-603 lazyload\" data-src=\"http:\/\/escoladeprogramadores.com.br\/site\/wp-content\/uploads\/2019\/12\/avatar_instrutor.jpg\" alt=\"\" width=\"53\" height=\"51\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 53px; --smush-placeholder-aspect-ratio: 53\/51;\" \/> <strong>Ivan Sanches<\/strong><\/p><p>Ivan Sanches \u00e9 p\u00f3s-graduado em Desenvolvimento Mobile. Possui certifica\u00e7\u00f5es Microsoft, Oracle e IBM. Atua como consultor de tecnologia e desenvolvedor de sistemas em PHP, JAVA, Phyton e Mainframe (Cobol, VSAM, DB2, CICS, Assembler). Atualmente desenvolvendo solu\u00e7\u00f5es de troca de dados entre mainframe e plataforma open atrav\u00e9s de Hadoop e Spark.<br \/><span style=\"text-decoration: underline;\">Instrutor dos cursos de <strong>Cobol, CICS e JCL<\/strong><\/span><\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"5\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1875\" aria-expanded=\"false\">Aula Aberta<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1875\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"5\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1875\" tabindex=\"0\" hidden=\"hidden\"><div style=\"padding: 52.81% 0 0 0; position: relative;\"><iframe style=\"position: absolute; top: 0; left: 0; width: 100%; height: 100%;\" data-src=\"https:\/\/player.vimeo.com\/video\/381701243?autoplay=0&amp;loop=0&amp;color=ffffff&amp;title=0&amp;byline=0&amp;portrait=0\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/div><p><script src=\"https:\/\/player.vimeo.com\/api\/player.js\"><\/script><\/p><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4c0906b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c0906b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4d456c2\" data-id=\"4d456c2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-45aceae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45aceae\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1b261006\" data-id=\"1b261006\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bd0d73c elementor-widget elementor-widget-html\" data-id=\"bd0d73c\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<!-- INICIO DO BOTAO PAGSEGURO --><a href=\"https:\/\/pag.ae\/7_YfepMYL\/button\" target=\"_blank\" title=\"Pagar com PagSeguro\"><img decoding=\"async\" data-src=\"\/\/assets.pagseguro.com.br\/ps-integration-assets\/botoes\/pagamentos\/205x30-pagar-azul.gif\" alt=\"Pague com PagSeguro - \u00e9 r\u00e1pido, gr\u00e1tis e seguro!\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/a><!-- FIM DO BOTAO PAGSEGURO -->\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-117ccf33 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"117ccf33\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Valor do curso R$ 149,00 (em at\u00e9 4x) Instrutor: Ivan Sobre o curso Conteudos abordados Como funciona o curso ! Curriculo dos instrutores Aula Aberta Sobre o curso Objetivo Conhecer a linguagem SQL e o uso no DB2 em um ambiente de alta plataforma Publico Alvo Suporte, Produ\u00e7\u00e3o e Desenvolvedores&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-833","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/pages\/833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/comments?post=833"}],"version-history":[{"count":18,"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/pages\/833\/revisions"}],"predecessor-version":[{"id":2707,"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/pages\/833\/revisions\/2707"}],"wp:attachment":[{"href":"https:\/\/escoladeprogramadores.com.br\/2025\/wp-json\/wp\/v2\/media?parent=833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}