{"id":8834,"date":"2025-02-07T14:44:42","date_gmt":"2025-02-07T17:44:42","guid":{"rendered":"https:\/\/lstreinamentos.luizsantanadb.com\/loja\/imersao-azure-big-data-turma-10\/"},"modified":"2026-04-10T04:44:21","modified_gmt":"2026-04-10T07:44:21","slug":"imersao-azure-big-data-turma-10","status":"publish","type":"product","link":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/loja\/imersao-azure-big-data-turma-10\/","title":{"rendered":"Imers\u00e3o Azure Big Data &#8211; Turma 10 (Gravado)"},"content":{"rendered":"<p>Neste curso de imers\u00e3o abordaremos desde a ingest\u00e3o\/tratamento de dados utilizando o Azure Data Factory, tratamento de dados utilizando o Azure Databricks, armazenamento de dados utilizando o Azure SQL Database\/Azure Data Lake e visualiza\u00e7\u00e3o com PBI com foco na Engenharia de Dados.<\/p>\n<p style=\"font-weight: 400;\"><strong>O que n\u00e3o realizaremos no treinamento:<\/strong><\/p>\n<ul style=\"font-weight: 400;\">\n<li>N\u00e3o resolveremos problemas de trabalho de nenhum participante.<\/li>\n<li>N\u00e3o mostraremos assuntos fora do conte\u00fado program\u00e1tico proposto no treinamento.<\/li>\n<li>N\u00e3o realizaremos o provisionamento com os participantes.<\/li>\n<li><strong>Emitimos NOTA FISCAL para treinamentos comprados pela plataforma.<\/strong><\/li>\n<\/ul>\n<p style=\"font-weight: 400;\"><strong>O que terei de benef\u00edcios:<\/strong><\/p>\n<ul style=\"font-weight: 400;\">\n<li>Treinamento baseado em viv\u00eancias de projetos reais.<\/li>\n<li>Networking<\/li>\n<li>Instrutores com bastante experi\u00eancia no mercado e em projetos de Big Data com grandes clientes. Todos s\u00e3o certificados Microsoft e com\u00a0experi\u00eancia em projetos com clientes nacionais e internacionais.<\/li>\n<li><strong><u>Portal com todos os conte\u00fados do treinamento \u2014 VITALICIO, ou seja, PARA SEMPRE.<\/u><\/strong><\/li>\n<li><strong><u>V\u00eddeos das aulas gravadas &#8211; Ao final de cada dia, disponibilizamos a aula gravada na plataforma<\/u><\/strong><\/li>\n<li>Slides<\/li>\n<li>PDFs<\/li>\n<li>Scripts<\/li>\n<li>Links de apoio<\/li>\n<li>Arquivos utilizados nos laborat\u00f3rios<\/li>\n<li>Certificado de participa\u00e7\u00e3o do treinamento.\u00a0O certificado \u00e9 validado digitalmente para evitar fraudes e poss\u00edveis copias.<\/li>\n<li>Canal de comunica\u00e7\u00e3o com os instrutores e demais alunos.<\/li>\n<li>Dicas de certifica\u00e7\u00e3o<\/li>\n<\/ul>\n<h1><b>Conte\u00fados Configura\u00e7\u00e3o do Ambiente Azure<\/b><\/h1>\n<ul style=\"font-weight: 400;\">\n<li><strong>Conceitos de Big Data<\/strong><\/li>\n<li><strong>Conceitos de ETL X ELT<\/strong><\/li>\n<li><strong>Conceitos Apresenta\u00e7\u00e3o dos servi\u00e7os de big data do Azure<\/strong><\/li>\n<li><strong>Conceitos do Azure Databricks <\/strong><\/li>\n<li><strong>Conceitos do Apache Spark<\/strong><\/li>\n<li><strong>Apresenta\u00e7\u00e3o da plataforma do Databricks <\/strong><\/li>\n<li><strong>Provisionamento dos servi\u00e7os da Azure<\/strong>\n<ul>\n<li><strong>Azure Data Factory<\/strong><\/li>\n<li><strong>Azure Data Lake<\/strong><\/li>\n<li><strong>Azure Key Vault<\/strong><\/li>\n<li><strong>Azure SQL Database<\/strong><\/li>\n<li><strong>Azure Databricks<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Configura\u00e7\u00e3o do ADF<\/strong>\n<ul>\n<li><strong>Integration Runtime Self-Hosted<\/strong><\/li>\n<li><strong>Linked Services <\/strong><\/li>\n<li><strong>Datasets<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Configura\u00e7\u00e3o do Databricks<\/strong>\n<ul style=\"font-weight: 400;\">\n<li><strong>Cria\u00e7\u00e3o de clusters<\/strong><\/li>\n<li><strong>Cria\u00e7\u00e3o do escopo (scope)<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Integra\u00e7\u00f5es<\/strong>\n<ul>\n<li><strong>Azure Databricks<\/strong><\/li>\n<li><strong>Azure Data Lake<\/strong><\/li>\n<li><strong>Azure Key Vault<\/strong><\/li>\n<li><strong>GitHub \/ Azure DevOps<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h1><b>Conte\u00fados Azure Data Factory<\/b><\/h1>\n<ul style=\"font-weight: 400;\">\n<li><strong>Desenvolvimento de Pipelines<\/strong>\n<ul>\n<li><strong>Copy Data <\/strong><\/li>\n<li><strong>Get Metadata <\/strong><\/li>\n<li><strong>Lookup <\/strong><\/li>\n<li><strong>Stored Procedure<\/strong><\/li>\n<li><strong>Execute Pipeline <\/strong><\/li>\n<li><strong>Filter <\/strong><\/li>\n<li><strong>ForEach <\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Triggers<\/strong>\n<ul>\n<li><strong>Schedule<\/strong><\/li>\n<li><strong>Tumbling Window<\/strong><\/li>\n<li><strong>Storage Events<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Monitoramento de Execu\u00e7\u00e3o<\/strong><\/li>\n<li><strong>Transforma\u00e7\u00e3o de dados com:<\/strong>\n<ul>\n<li><strong>Data Flow<\/strong><\/li>\n<li><strong>Power Query<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1><b>Conte\u00fados Azure Databricks<\/b><\/h1>\n<ul style=\"font-weight: 400;\">\n<li><strong>Conceitos de Delta Lake<\/strong><\/li>\n<li><strong>Aplicabilidade Python x SQL X Delta<\/strong><\/li>\n<li><strong>Notebooks de conex\u00e3o com:<\/strong>\n<ul>\n<li><strong>Data Lake<\/strong><\/li>\n<li><strong>Azure SQL Database<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Notebooks de tratamento de dados<\/strong>\n<ul>\n<li><strong>PySpark<\/strong><\/li>\n<li><strong>SparkSQL<\/strong><\/li>\n<li><strong>Leitura\/Escrita no Delta Table<\/strong><\/li>\n<li><strong>Leitura\/Escrita no Data Lake<\/strong><\/li>\n<li><strong>Leitura\/Escrita no Azure SQL Database<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Orquestra\u00e7\u00e3o dos notebooks a partir do Azure Data Factory<\/strong><\/li>\n<\/ul>\n<h1><\/h1>\n<h1><b>Conte\u00fados Azure Synapse Analytcs<\/b><\/h1>\n<ul style=\"font-weight: 400;\">\n<li><strong style=\"font-weight: 400;\">Serverless<\/strong>\n<ul>\n<li style=\"font-weight: 400;\"><strong>Cria\u00e7\u00e3o da Database Serverless<\/strong><\/li>\n<li><b><strong>Cria\u00e7\u00e3o SCOPED CREDENTIAL<\/strong><\/b><\/li>\n<li style=\"font-weight: 400;\"><strong>Cria\u00e7\u00e3o EXTERNAL DATA SOURCE<\/strong><\/li>\n<li><strong>Cria\u00e7\u00e3o EXTERNAL FILE FORMAT<\/strong><\/li>\n<li><strong>Cria\u00e7\u00e3o de SCHEMA<\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong>Cria\u00e7\u00e3o de view dinamica via parametros do ADF<\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong>Libera\u00e7\u00e3o de permiss\u00e3o a schemas e tabelas<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1><b>Conte\u00fados Power BI para Engenheiro de dados<\/b><\/h1>\n<ul style=\"font-weight: 400;\">\n<li><strong>Entendendo a necessidade da visualiza\u00e7\u00e3o e compartilhamento dos dados.<\/strong><\/li>\n<li><strong>O que \u00e9 o Power BI?<\/strong><\/li>\n<li><strong>Fontes de Dados<\/strong><\/li>\n<li><strong>Tipos de Conex\u00e3o<\/strong><\/li>\n<li><strong>Power BI Desktop<\/strong><\/li>\n<li><strong>Power BI Service<\/strong><\/li>\n<li><strong>Power BI Mobile<\/strong><\/li>\n<li><strong>Modelagem<\/strong><\/li>\n<li><strong>Compartilhamento (Apps, Dashboards, Reports) <\/strong><\/li>\n<li><strong>Licenciamento do Power BI (planos e capacidades)<\/strong><\/li>\n<li><strong>Laborat\u00f3rio Power BI:<\/strong>\n<ul>\n<li><strong>Ingest\u00e3o<\/strong><\/li>\n<li><strong>Power Query (Linguagem M);<\/strong><\/li>\n<li><strong>DAX<\/strong><\/li>\n<li><strong>Analysis Services<\/strong><\/li>\n<li><strong>Gr\u00e1ficos<\/strong><\/li>\n<li><strong>Compartilhamento<\/strong><\/li>\n<li><strong>Workspaces<\/strong><\/li>\n<li><strong>Conjunto de dados<\/strong><\/li>\n<li><strong>Fluxo de Dados<\/strong><\/li>\n<li><strong>On Premises Data Gateway<\/strong><\/li>\n<li><strong>Atualiza\u00e7\u00e3o Agendada<\/strong><\/li>\n<li><strong>Alertas<\/strong><\/li>\n<li><strong>Assinaturas<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1><b>Conte\u00fado Program\u00e1tico Unity Catalog<\/b><\/h1>\n<ul>\n<li><strong>OVERVIEW SOBRE GOVERNAN\u00c7A DE DADOS<\/strong><\/li>\n<li><strong>O QUE \u00c9 O UNITY CATALOG?<\/strong><\/li>\n<li><strong>PREMISSAS PARA IMPLANTA\u00c7\u00c3O DO UNITY<\/strong><\/li>\n<li><strong>PROVISIONAMENTO<\/strong><\/li>\n<li><strong>CONFIGURA\u00c7\u00c3O<\/strong>\n<ul>\n<li><strong>METASTORE<\/strong><\/li>\n<li><strong>GRUPO DE USUARIOS<\/strong><\/li>\n<li><strong>SERVICE PRINCIPAL<\/strong><\/li>\n<li><strong>CREDENTIALS<\/strong><\/li>\n<li><strong>EXTERNAL LOCATIONS<\/strong><\/li>\n<li><strong>CAT\u00c1LOGOS<\/strong><\/li>\n<li><strong>SCHEMAS (DATABASES)<\/strong><\/li>\n<li><strong>TABELAS<\/strong><\/li>\n<li><strong>PERMISS\u00d5ES<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>APLICA\u00c7\u00c3O DE TAGS<\/strong><\/li>\n<li><strong>UTILIZA\u00c7\u00c3O DA DATABASE INFORMATION_SCHEMA<\/strong><\/li>\n<li><strong>UTILIZA\u00c7\u00c3O DE AI<\/strong><\/li>\n<li><strong>AN\u00c1LISE DE LINHAGEM<\/strong><\/li>\n<li><strong>MIGRA\u00c7\u00c3O DE TABELAS DO HIVE_METASTORE\u00a0 PARA O UNITY CATALOG<\/strong><\/li>\n<li><strong>CRIA\u00c7\u00c3O DE TABELAS NO UNITY CATALOG<\/strong><\/li>\n<li><strong>DATA QUALITY COM UNITY CATALOG<\/strong><\/li>\n<\/ul>\n<h1><b>Conte\u00fados <\/b><b>Program\u00e1tico Azure DevOps para Big Data<\/b><\/h1>\n<ul>\n<li><strong>Introdu\u00e7\u00e3o ao Azure DevOps e seus recursos<\/strong><\/li>\n<li><strong>Pr\u00e1ticas de DevOps em ambientes de Big Data<\/strong><\/li>\n<li><strong>Configura\u00e7\u00e3o e gerenciamento de pipelines de implanta\u00e7\u00e3o<\/strong><\/li>\n<li><strong>Integra\u00e7\u00e3o cont\u00ednua e entrega cont\u00ednua (CI\/CD) em projetos de Big Data<\/strong><\/li>\n<li><strong>Automa\u00e7\u00e3o de processos de implanta\u00e7\u00e3o e monitoramento em ambientes de Big Data utilizando o Azure DevOps<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<ul>\n<li><span class=\"OYPEnA text-decoration-none text-strikethrough-none\">Carga Hor\u00e1ria: 30 horas<\/span><\/li>\n<li><span class=\"OYPEnA text-decoration-none text-strikethrough-none\">Modalidade: GRAVADO (Conte\u00fado da TURMA 10 &#8211; Maio\/2025)<\/span><\/li>\n<li>Certificado: SIM<\/li>\n<li>Nota Fiscal: SIM<\/li>\n<li><span class=\"OYPEnA text-decoration-none text-strikethrough-none\">Observa\u00e7\u00f5es<\/span>: Algumas telas e features podem sofrer altera\u00e7\u00e3o conforme atualiza\u00e7\u00e3o da ferramenta. <strong><span class=\"OYPEnA text-decoration-none text-strikethrough-none\">ATUALIZA\u00c7\u00d5ES DA TECNOLOGIA N\u00c3O S\u00c3O CONTEMPLADAS NO CONTE\u00daDO GRAVADO.<\/span><\/strong>\n<div class=\"woocommerce-product-details__short-description\"><\/div>\n<\/li>\n<\/ul>\n","protected":false},"featured_media":8345,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[96],"product_tag":[],"class_list":{"0":"post-8834","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-azure-big-data","8":"first","9":"instock","10":"sale","11":"virtual","12":"sold-individually","13":"purchasable","14":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/product\/8834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/comments?post=8834"}],"version-history":[{"count":2,"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/product\/8834\/revisions"}],"predecessor-version":[{"id":9885,"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/product\/8834\/revisions\/9885"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/media\/8345"}],"wp:attachment":[{"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/media?parent=8834"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/product_brand?post=8834"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/product_cat?post=8834"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/lstreinamentos.luizsantanadb.com\/plataforma\/wp-json\/wp\/v2\/product_tag?post=8834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}