
{"id":12661,"date":"2024-10-03T10:43:23","date_gmt":"2024-10-03T13:43:23","guid":{"rendered":"https:\/\/goias.gov.br\/escoladegoverno\/?p=12661"},"modified":"2025-04-22T10:08:03","modified_gmt":"2025-04-22T13:08:03","slug":"sql-para-analise-de-dados","status":"publish","type":"post","link":"https:\/\/goias.gov.br\/escoladegoverno\/sql-para-analise-de-dados\/","title":{"rendered":"SQL para An\u00e1lise de Dados"},"content":{"rendered":"\n<div class=\"wp-block-group alignwide\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:25%\">\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-8057eaf3 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"https:\/\/sgc.escoladegoverno.go.gov.br\/\" style=\"background-color:#ec9c00\" target=\"_blank\" rel=\"noreferrer noopener\">Inscreva-se<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:25%\"><div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"213\" height=\"41\" src=\"https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2020\/07\/ead-assincrono-2.png\" alt=\"\" class=\"wp-image-9457\" style=\"object-fit:cover\"\/><\/figure>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-medium\"><img decoding=\"async\" width=\"300\" height=\"41\" src=\"https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-300x41.png\" alt=\"\" class=\"wp-image-12876\" srcset=\"https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-300x41.png 300w, https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-1024x140.png 1024w, https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1-768x105.png 768w, https:\/\/goias.gov.br\/escoladegoverno\/wp-content\/uploads\/sites\/28\/2024\/10\/Sempre-Aberto-1.png 1254w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center has-black-color has-text-color has-link-color wp-elements-b771095c89635cd46cdf19b995819baa is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:20%\">\n<p><\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100\"><a class=\"wp-block-button__link has-black-color has-text-color has-background has-link-color wp-element-button\" style=\"border-radius:0px;background-color:#f9f9f9\"><strong>Sobre o Curso<\/strong><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n<h4><strong>Modalidade<\/strong><\/h4>\n<p>EaD Ass\u00edncrono \u2013 conte\u00fados gravados e material para leitura,\u00a0sem aulas ao vivo e sem intera\u00e7\u00e3o com o professor no f\u00f3rum.<\/p>\n<h4><strong>Carga Hor\u00e1ria<\/strong><\/h4>\n<p>40 horas.<\/p>\n<h4><strong>Objetivo Geral<\/strong><\/h4>\n<p>Capacitar os discentes a utilizar a linguagem SQL (<em>Structure Query Language<\/em>) para manipular dados estruturados em sistemas gerenciadores de banco de dados, habilidade essencial para a an\u00e1lise de dados.<\/p>\n<h4><strong>Pr\u00e9-requisitos<\/strong><\/h4>\n<p>Ser concluinte do N\u00edvel B\u00e1sico da Trilha Analista de Dados ou dos cursos de Power BI &#8211; B\u00e1sico \/ Avan\u00e7ado.<\/p>\n<h4><strong>P\u00fablico-Alvo<\/strong><\/h4>\n<p>Servidores P\u00fablicos do Poder Executivo Estadual concluintes\u00a0do N\u00edvel B\u00e1sico da Trilha Analista de Dados ou dos\u00a0cursos de Power BI &#8211; B\u00e1sico \/ Avan\u00e7ado.<\/p>\n<h4><strong>Conte\u00fado Program\u00e1tico<\/strong><\/h4>\n<ul>\n<li>Introdu\u00e7\u00e3o ao SQL;<\/li>\n<li>Consultas Simples;<\/li>\n<li>Consultas Avan\u00e7adas;<\/li>\n<li>Jun\u00e7\u00e3o de Tabelas;<\/li>\n<li>Subconsultas e Agrupamentos;<\/li>\n<li>Fun\u00e7\u00f5es de Agrega\u00e7\u00e3o.<\/li>\n<\/ul>\n<h4><strong>Crit\u00e9rios para aprova\u00e7\u00e3o<\/strong><\/h4>\n<p>Aproveitamento igual ou superior a 70% (setenta por cento) nas atividades avaliativas do curso.<\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(EaD  Ass\u00edncrono) \u2013 Capacitar os alunos a usar SQL para manipular dados em sistemas de gerenciamento de banco de dados, uma habilidade essencial para a an\u00e1lise de dados.<\/p>\n","protected":false},"author":179,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,102],"tags":[118],"class_list":["post-12661","post","type-post","status-publish","format-standard","hentry","category-cursos-ead","category-area-analista-dados","tag-sempre-abertas"],"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"ilaneluz","author_link":"https:\/\/goias.gov.br\/escoladegoverno\/author\/ilaneluz\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/goias.gov.br\/escoladegoverno\/categoria\/capacitacao\/modalidade\/cursos-ead\/\" rel=\"category tag\">Cursos EaD<\/a> <a href=\"https:\/\/goias.gov.br\/escoladegoverno\/categoria\/capacitacao\/areas-cursos\/area-analista-dados\/\" rel=\"category tag\">Trilha Analista de Dados<\/a>","rttpg_excerpt":"(EaD Ass\u00edncrono) \u2013 Capacitar os alunos a usar SQL para manipular dados em sistemas de gerenciamento de banco de dados, uma habilidade essencial para a an\u00e1lise de dados.","_links":{"self":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts\/12661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/users\/179"}],"replies":[{"embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/comments?post=12661"}],"version-history":[{"count":2,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts\/12661\/revisions"}],"predecessor-version":[{"id":14272,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/posts\/12661\/revisions\/14272"}],"wp:attachment":[{"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/media?parent=12661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/categories?post=12661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goias.gov.br\/escoladegoverno\/wp-json\/wp\/v2\/tags?post=12661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}