{"id":4843,"date":"2022-02-11T16:15:38","date_gmt":"2022-02-11T22:15:38","guid":{"rendered":"https:\/\/gsb.lat\/?p=4843"},"modified":"2023-03-31T14:37:14","modified_gmt":"2023-03-31T20:37:14","slug":"querying-data-with-transact-sql-2","status":"publish","type":"post","link":"https:\/\/gsb.lat\/pt\/querying-data-with-transact-sql-2\/","title":{"rendered":"Querying Data with Transact-SQL"},"content":{"rendered":"\r\n<div class=\"cust-template\"><!-- Informacion 1 -->\r\n<div class=\"dp-flex-desk\">\r\n<div class=\"w-60-desk padding-10\">\r\n<h2>Descri\u00e7\u00e3o<\/h2>\r\n<p>Este programa tem como principal objetivo proporcionar aos alunos uma boa compreens\u00e3o da linguagem Transact-SQL que \u00e9 utilizada em todas as disciplinas relacionadas com SQL Server; ou seja, administra\u00e7\u00e3o de banco de dados, desenvolvimento de banco de dados e intelig\u00eancia de neg\u00f3cios.<\/p>\r\n<\/div>\r\n<div class=\"w-40-desk padding-10 dp-flex-res\">\r\n<div class=\"mr-30\">\r\n<h2>Endere\u00e7ado a<\/h2>\r\n<ul>\r\n<li><i class=\"fas fa-check\"><\/i>Administradores de banco de dados<\/li>\r\n<li><i class=\"fas fa-check\"><\/i>Desenvolvedores de banco de dados<\/li>\r\n<li><i class=\"fas fa-check\"><\/i>Profissionais de BI.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<h2>Dura\u00e7\u00e3o<\/h2>\r\n<p><i class=\"fas fa-clock\"><\/i> 35 horas<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<!-- Informacion 2 -->\r\n<div class=\"dp-flex-desk cus-mt-40\">\r\n<div class=\"blue-box\">\r\n<h2>Modalidades<\/h2>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Cara a cara<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Ao vivo virtual atrav\u00e9s de plataformas digitais<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>no local<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div class=\"blue-box\">\r\n<h2>Cursos Relacionados<\/h2>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i> 20764-C: Administrando uma infraestrutura de banco de dados SQL<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>20762-C: Desenvolvendo Bancos de Dados SQL<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div class=\"blue-box\">\r\n<h2>Inclui<\/h2>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i> 35 horas de treinamento<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Instrutores treinados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Manual do participante em formato digital<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Comprovante de participa\u00e7\u00e3o<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li>\u00a0<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<!-- Temario -->\r\n<div class=\"padding-img\"><img decoding=\"async\" class=\"tam-img\" src=\"https:\/\/gsb.lat\/wp-content\/uploads\/2022\/01\/isotipo.png\" \/>\r\n<div class=\"flex-center\"><hr class=\"cust-w-100\" \/>\r\n<h3>tem\u00e1rio<\/h3>\r\n<hr class=\"cust-w-100\" \/><\/div>\r\n<\/div>\r\n<div class=\"dp-flex-desk flex-wrap-desk cus-mt-20\">\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 1: Introdu\u00e7\u00e3o ao Microsoft SQL Server<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>A arquitetura b\u00e1sica do SQL Server<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Edi\u00e7\u00f5es e vers\u00f5es do SQL Server<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Introdu\u00e7\u00e3o ao SQL Server Management Studio<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Trabalhando com ferramentas do SQL Server<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Trabalhar com o SQL Server Management Studio<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Criando e organizando scripts T-SQL<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use livros on-line<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 2: Introdu\u00e7\u00e3o \u00e0s consultas T-SQL<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Apresenta\u00e7\u00e3o do T-SQL<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Definir compreens\u00e3o<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Entendendo a l\u00f3gica de predicados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Entendendo a ordem l\u00f3gica das opera\u00e7\u00f5es em instru\u00e7\u00f5es SELECT<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Introdu\u00e7\u00e3o \u00e0s consultas T-SQL<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Execu\u00e7\u00e3o de instru\u00e7\u00f5es SELECT b\u00e1sicas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Como executar consultas que filtram dados usando predicados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Executando consultas que ordenam dados usando ORDER BY<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 3: Escrevendo consultas SELECT<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva instru\u00e7\u00f5es SELECT simples<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Removendo duplicatas com DISTINCT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usar aliases de coluna e tabela<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva express\u00f5es CASE simples<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Escrevendo instru\u00e7\u00f5es SELECT b\u00e1sicas<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva instru\u00e7\u00f5es SELECT simples<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Elimine duplicatas com DISTINCT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usar aliases de coluna e tabela<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use uma express\u00e3o CASE simples<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 4: consultando v\u00e1rias tabelas<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Entendendo as jun\u00e7\u00f5es<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Consulta com associa\u00e7\u00f5es internas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Consulta com associa\u00e7\u00f5es externas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Consulta com Cross Joins e Self Joins<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Consultar v\u00e1rias tabelas<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam associa\u00e7\u00f5es internas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam jun\u00e7\u00f5es internas de v\u00e1rias tabelas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Como escrever consultas que usam autojun\u00e7\u00f5es<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam associa\u00e7\u00f5es externas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam jun\u00e7\u00f5es cruzadas<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 5: Classifica\u00e7\u00e3o e filtragem de dados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>classifica\u00e7\u00e3o de dados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Filtrar dados com predicados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Filtragem de dados com TOP e OFFSET-FETCH<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Trabalhar com valores desconhecidos<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Classifica\u00e7\u00e3o e filtragem de dados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que filtram dados usando uma cl\u00e1usula WHERE<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que ordenam dados usando uma cl\u00e1usula ORDER BY<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que filtram dados com a op\u00e7\u00e3o TOP<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que filtram dados usando a cl\u00e1usula OFFSET-FETCH<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 6: Trabalhando com tipos de dados do SQL Server<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Introdu\u00e7\u00e3o aos tipos de dados do SQL Server<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Trabalhar com dados de caracteres<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Trabalhar com dados de data e hora<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Trabalhando com tipos de dados do SQL Server<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva consultas que retornam dados de data e hora<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam fun\u00e7\u00f5es de data e hora<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que retornam dados de caracteres<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que retornam fun\u00e7\u00f5es de caractere<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 7: usando DML para modificar dados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Adicionar dados \u00e0s tabelas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Modificar e excluir dados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Gerando valores de coluna autom\u00e1ticos<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Usando DML para modificar dados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Inserir registros com DML<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Atualizando e excluindo registros usando DML<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 8: Usando fun\u00e7\u00f5es integradas<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva consultas com fun\u00e7\u00f5es integradas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usar fun\u00e7\u00f5es de convers\u00e3o<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usar fun\u00e7\u00f5es l\u00f3gicas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usando fun\u00e7\u00f5es para trabalhar com NULL<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Usando recursos integrados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva consultas que usam fun\u00e7\u00f5es de convers\u00e3o<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam fun\u00e7\u00f5es l\u00f3gicas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva consultas que testam a nulidade<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 9: Agrupamento e Agrega\u00e7\u00e3o de Dados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use fun\u00e7\u00f5es adicionais<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usando a cl\u00e1usula GROUP BY<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Filtrar grupos com HAVING<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Agrupamento e Agrega\u00e7\u00e3o de Dados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam a cl\u00e1usula GROUP BY<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam fun\u00e7\u00f5es agregadas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam diferentes fun\u00e7\u00f5es de agrega\u00e7\u00e3o<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que filtram grupos com a cl\u00e1usula HAVING<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 10: Usando Subconsultas<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever subconsultas independentes<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever subconsultas correlacionadas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usando o predicado EXISTS com subconsultas<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Usando subconsultas<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam subconsultas separadas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam subconsultas escalares e de v\u00e1rios resultados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam subconsultas correlacionadas e uma cl\u00e1usula EXISTS<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 11: Usando express\u00f5es de tabela<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>usar visualiza\u00e7\u00f5es<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usando fun\u00e7\u00f5es com valor de tabela online<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usar tabelas derivadas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usar express\u00f5es de tabela comuns<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Usando express\u00f5es de tabela<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam visualiza\u00e7\u00f5es<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam tabelas derivadas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam express\u00f5es de tabela comuns (CTEs)<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam express\u00f5es com valor de tabela (TVFs) embutidas<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 12: Usando Operadores de Conjunto<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas com o operador UNION<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usando EXCEPT e INTERSECT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usando APLICAR<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Usando operadores de conjunto<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam os operadores de conjunto UNION e UNION ALL<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam os operadores CROSS APPLY e OUTER APPLY<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva consultas que usam os operadores EXCEPT e INTERSECT<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 13: Usando os recursos de classifica\u00e7\u00e3o, compensa\u00e7\u00e3o e agrega\u00e7\u00e3o do Windows<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Criando janelas com OVER<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Explorando os recursos da janela<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio : Usando os Recursos de Classifica\u00e7\u00e3o, Compensa\u00e7\u00e3o e Agrega\u00e7\u00e3o do Windows<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam fun\u00e7\u00f5es de classifica\u00e7\u00e3o<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escreva consultas que usam fun\u00e7\u00f5es de compensa\u00e7\u00e3o<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam fun\u00e7\u00f5es de agrega\u00e7\u00e3o de janela<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 14: Agrupando e Girando Conjuntos<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas com PIVOT e UNPIVOT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Trabalhar com conjuntos de agrupamento<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Conjuntos de pool e piv\u00f4<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrever consultas que usam o operador PIVOT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam o operador UNPIVOT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Escrevendo consultas que usam as subcl\u00e1usulas GROUPING SETS CUBE e ROLLUP<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Li\u00e7\u00e3o 15: Executando Procedimentos Armazenados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Consultar dados com procedimentos armazenados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Passar par\u00e2metros para procedimentos armazenados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Criando procedimentos armazenados simples<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Trabalhar com SQL din\u00e2mico<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Laborat\u00f3rio: Executando Procedimentos Armazenados<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Usando a instru\u00e7\u00e3o EXECUTE para chamar procedimentos armazenados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Passar par\u00e2metros para procedimentos armazenados<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Execu\u00e7\u00e3o de procedimentos armazenados no sistema<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<!-- Script -->\r\n<p><script src='https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/3.5.1\/jquery.min.js'><\/script><script type='text\/javascript'>$(function() {'use strict';$('.show_btn').click(function() {if ($(this).hasClass('fa-chevron-down')) {$(this).parent().parent().children('ul').removeClass('dp-none');$(this).removeClass('fa-chevron-down');$(this).addClass('fa-chevron-up');} else {$(this).parent().parent().children('ul').addClass('dp-none');$(this).addClass('fa-chevron-down');$(this).removeClass('fa-chevron-up');}});});<\/script><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Descri\u00e7\u00e3o Este programa tem como principal objetivo proporcionar aos alunos uma boa compreens\u00e3o da linguagem Transact-SQL que \u00e9 utilizada em todas as disciplinas relacionadas com SQL Server; ou seja, administra\u00e7\u00e3o de banco de dados, desenvolvimento de banco de dados e intelig\u00eancia de neg\u00f3cios. Endere\u00e7ado a Administradores de banco de dados Desenvolvedores de banco de dados&hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[467],"tags":[],"class_list":["post-4843","post","type-post","status-publish","format-standard","hentry","category-uncategorized-pt","category-467","description-off"],"_links":{"self":[{"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/posts\/4843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/comments?post=4843"}],"version-history":[{"count":1,"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/posts\/4843\/revisions"}],"predecessor-version":[{"id":10441,"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/posts\/4843\/revisions\/10441"}],"wp:attachment":[{"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/media?parent=4843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/categories?post=4843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gsb.lat\/pt\/wp-json\/wp\/v2\/tags?post=4843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}