{"id":10017,"date":"2020-05-29T18:39:12","date_gmt":"2020-05-29T21:39:12","guid":{"rendered":"https:\/\/geekblogti.wpengine.com\/?p=10017"},"modified":"2024-10-10T17:48:08","modified_gmt":"2024-10-10T20:48:08","slug":"sql-basico-com-pokemon","status":"publish","type":"post","link":"https:\/\/www.geekhunter.com/pt/blog\/sql-basico-com-pokemon\/","title":{"rendered":"SQL b\u00e1sico: uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon"},"content":{"rendered":"\r\n<p class=\"wp-block-paragraph\">Que tal aprender o b\u00e1sico sobre SQL de uma forma simples e descontra\u00edda com Pok\u00e9mon? \u00c9 a inten\u00e7\u00e3o deste artigo.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-o-que-a-linguagem-sql\">O que \u00e9 a linguagem SQL?<\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">A Structured Query Language, conhecida como SQL, \u00e9 uma das ferramentas mais conhecidas por programadores, analistas, cientistas de dados e DBAs para a extra\u00e7\u00e3o e execu\u00e7\u00e3o de comandos em <strong><a href=\"https:\/\/www.geekhunter.com/pt/blog\/banco-de-dados-nosql\/\">bancos de dados<\/a><\/strong> relacionais e estruturados.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">N\u00e3o s\u00f3 isso, mas segundo a ANSI (American National Standards Institute), SQL \u00e9 a linguagem padr\u00e3o para gest\u00e3o de sistemas de bases de dados relacionais.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Essa linguagem permite, al\u00e9m da visualiza\u00e7\u00e3o de tabelas e a aplica\u00e7\u00e3o de diversos filtros nela, atrav\u00e9s de consultas, a cria\u00e7\u00e3o de novas tabelas e colunas no mesmo banco de dados.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">\u00c9 relativamente f\u00e1cil de aprender SQL e pode ser uma \u00f3tima porta de entrada para o mundo da programa\u00e7\u00e3o. Possibilitando, por exemplo, uma comunica\u00e7\u00e3o flu\u00edda entre profissionais que lidam com dados e os devs de sua empresa.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Sabia que, segundo a Stack Overflow, <a href=\"https:\/\/insights.stackoverflow.com\/survey\/2019#most-popular-technologies\" target=\"_blank\" rel=\"noreferrer noopener\">SQL \u00e9 a 3\u00b0 linguagem mais popular para os devs<\/a>?<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-como-come-ar-a-escrever-em-sql\">Como come\u00e7ar a escrever em SQL?<\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Para ilustrar, iremos aplicar os comandos b\u00e1sicos do SQL num<a href=\"https:\/\/www.kaggle.com\/dizzypanda\/gen-1-pokemon\" target=\"_blank\" rel=\"noreferrer noopener\"> banco de dados<\/a> que cont\u00e9m os 151 Pok\u00e9mons originais, que irei chamar de \u201cPokemonData\u201d!<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Sinta-se \u00e0 vontade em baixar esse banco e utilizar algum leitor de SQL on-line, caso n\u00e3o tenha nenhum software baixado. Recomendo Sqlite!<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Iremos abordar comandos b\u00e1sicos aqui, que podem ser entendidos como a \u201csintaxe\u201d da linguagem.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-a-import-ncia-dos-comandos-select-e-from-em-sql\">A import\u00e2ncia dos comandos \u201cSELECT\u201d e \u201cFROM\u201d em SQL<\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Os comandos \u201cSELECT\u201d e \u201cFROM\u201d s\u00e3o b\u00e1sicos de SQL porque executam a sele\u00e7\u00e3o de algum dado, select definindo o que voc\u00ea quer extrair, e o from dizendo de onde.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT *\r\nFROM PokemonData<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Este comando retorna todos (*) os dados da tabela PokemonData<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-comando-count-contagem-em-sql\">&#8211; Comando \u201cCOUNT\u201d (Contagem em SQL)<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">\u00c9 o comando que retorna uma contagem atrelada a alguma coluna:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT COUNT (Number)\r\nFROM PokemonData<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O output deste comando \u00e9 151, confirmando que temos 151 pok\u00e9mons no banco de dados.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-comando-distinct-distin-o-em-sql\">&#8211; Comando DISTINCT (Distin\u00e7\u00e3o em SQL)<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">\u00c9 o comando que retorna valores distintos de uma coluna:<\/p>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\" id=\"h-select-distinct-name\">SELECT DISTINCT (NAME)<\/h4>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O output deste comando s\u00e3o os nomes \u00fanicos de cada pok\u00e9mon que, neste caso, s\u00e3o tamb\u00e9m 151 nomes.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Mas, se tiv\u00e9ssemos uma linha na tabela com os dados do Bulbasaur repetidos, por exemplo, o comando SELECT DISTINCT iria \u201cexcluir\u201d uma dessas linhas.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-comando-where\">&#8211; Comando WHERE<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">\u00c9 um comando de SQL b\u00e1sico que serve como um filtro, restringindo os dados que contemplem a condi\u00e7\u00e3o definida.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT *\r\nFROM PokemonData\r\nWHERE Type1 = \u2018fire\u2019<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O output desta query retornar\u00e1 todos os dados dos Pok\u00e9mons que tem como \u201ctipo\u201d principal o elemento fogo.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Isso inclui Pok\u00e9mons como Charizard, Ninetales e Moltres!<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-condi-es-de-compara-o-em-sql\">&#8211; Condi\u00e7\u00f5es de compara\u00e7\u00e3o em SQL<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O comando WHERE pode ser utilizado com diversas compara\u00e7\u00f5es, e n\u00e3o somente igual (=), por exemplo, maior que (&gt;) e menor que (&lt;), entre outros!<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT *\r\nFROM PokemonData\r\nWhere Number &gt; 132<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O output desta query ir\u00e1 retornar todos os dados dos Pok\u00e9mons que tem um \u201cNumber\u201d (n\u00famero utilizado para registrar eles no Pokedex) maior que 132, come\u00e7ando pelo Pok\u00e9mon 133, o Eevee.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-condi-es-l-gicas-no-sql-and-or\">&#8211; Condi\u00e7\u00f5es l\u00f3gicas no SQL (and, or)<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">AND e OR s\u00e3o condi\u00e7\u00f5es que podemos utilizar junto do meu WHERE para definir mais de um \u201cfiltro\u201d.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT *\r\nFROM PokemonData\r\nWhere Type1 = \u2018water\u2019 AND Type2 = \u2018fighting\u2019<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O output da query ir\u00e1 retornar somente 1 linha de dado, os dados do Poliwrath, \u00fanico pok\u00e9mon da nossa base que cont\u00e9m como tipo principal: \u00e1gua; e secund\u00e1rio: luta.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT *\r\nFROM PokemonData\r\nWhere Type1 = \u2018water\u2019 OR Type2 = \u2018fighting\u2019<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Se aplicarmos um OR no lugar do AND, a query retorna todos os dados dos Pok\u00e9mons que tem como tipo principal \u00e1gua OU luta, incluindo pok\u00e9mons como Squirtle (\u00e1gua) e Machop (luta).<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-comando-de-ordena-o-de-dados-order-by\">&#8211; Comando de ordena\u00e7\u00e3o de dados (ORDER BY)<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">O comando ORDER BY permite organizar, de forma crescente ou decrescente (adicionando um DESC ap\u00f3s a coluna que voc\u00ea deseja usar como crit\u00e9rio de ordena\u00e7\u00e3o) os resultados da sua query.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT *\r\nFROM PokemonData\r\nORDER BY Name DESC<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Esta query retorna os nomes de todos os pok\u00e9mons, ordenados de maneira decrescente, come\u00e7ando pelo Zubat e acabando pelo Abra.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Para finalizar sobre SQL b\u00e1sico, \u00e9 muito importante cuidar com a ordem dos seus comandos! Se aplic\u00e1ssemos tudo o que foi citado anteriormente numa query s\u00f3, poder\u00edamos fazer o seguinte:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT Name\r\nFROM PokemonData\r\nWHERE Type1 = \u2018Water\u2019 OR Type1= \u2018Fire\u2019\r\nORDER BY Name DESC<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Esta query retorna o nome, ordenado de maneira decrescente, de pok\u00e9mons que s\u00e3o de tipo \u00e1gua ou fogo.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-conclus-o\">Conclus\u00e3o<\/h2>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Neste artigo vimos algumas opera\u00e7\u00f5es de SQL b\u00e1sico, de maneira divertida.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Com a leitura dele, qualquer pessoa pode come\u00e7ar a aplicar esse conhecimento e tentar estressar ao m\u00e1ximo o banco de dados, tanto em projetos pessoais como na sua vida profissional.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">SQL ensina de maneira menos complexa (como Python) l\u00f3gicas para analisar dados, como agrupamentos e contagens. Al\u00e9m de ter se tornando um pr\u00e9-requisito para diversas vagas no mercado de trabalho.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">No entanto, a quantidade de material on-line e gratuito dispon\u00edvel j\u00e1 consegue capacitar qualquer desenvolvedor iniciante na ferramenta.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Recomendo sites como mode, sqlbolt, w3schools e hackerrank, para treinar sua escrita de queries!<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p>Quer saber mais? SQL, NoSQL, NewSQL: <a href=\"https:\/\/geekblogti.wpengine.com\/sql-nosql-newsql-qual-banco-de-dados-usar\/\" target=\"_blank\" rel=\"noreferrer noopener\">Qual banco de dados usar<\/a>?<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">At\u00e9 a pr\u00f3xima! \ud83d\ude09<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Que tal aprender o b\u00e1sico sobre SQL de uma forma simples e descontra\u00edda com Pok\u00e9mon? \u00c9 a inten\u00e7\u00e3o deste artigo. O que \u00e9 a linguagem SQL? A Structured Query Language, conhecida como SQL, \u00e9 uma das ferramentas mais conhecidas por programadores, analistas, cientistas de dados e DBAs para a extra\u00e7\u00e3o e execu\u00e7\u00e3o de comandos em [&hellip;]<\/p>\n","protected":false},"author":167,"featured_media":10019,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-10017","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-desenvolvimiento-de-software"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.3 (Yoast SEO v28.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon<\/title>\n<meta name=\"description\" content=\"E que tal aprender SQL b\u00e1sico montando uma Pok\u00e9dex? Foi isso que fizemos neste artigo de introdu\u00e7\u00e3o ao SQL. Aprenda de forma descontra\u00edda!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL b\u00e1sico: uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon\" \/>\n<meta property=\"og:description\" content=\"Que tal aprender o b\u00e1sico sobre SQL de uma forma simples e descontra\u00edda com Pok\u00e9mon? \u00c9 a inten\u00e7\u00e3o deste artigo. O que \u00e9 a linguagem SQL? A Structured\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Geekhunter\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/geekhunterbr\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-29T21:39:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-10T20:48:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2020\/05\/pokemon-1600484_1280.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"959\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Geekhunter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@geekhunterbr\" \/>\n<meta name=\"twitter:site\" content=\"@geekhunterbr\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Geekhunter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/\"},\"author\":{\"name\":\"Geekhunter\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/person\\\/9f62b173345139f7bbdaf55312c3d400\"},\"headline\":\"SQL b\u00e1sico: uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon\",\"datePublished\":\"2020-05-29T21:39:12+00:00\",\"dateModified\":\"2024-10-10T20:48:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/\"},\"wordCount\":863,\"publisher\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/pokemon-1600484_1280.jpg\",\"articleSection\":[\"Desenvolvimiento de software\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/\",\"name\":\"Uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/pokemon-1600484_1280.jpg\",\"datePublished\":\"2020-05-29T21:39:12+00:00\",\"dateModified\":\"2024-10-10T20:48:08+00:00\",\"description\":\"E que tal aprender SQL b\u00e1sico montando uma Pok\u00e9dex? Foi isso que fizemos neste artigo de introdu\u00e7\u00e3o ao SQL. Aprenda de forma descontra\u00edda!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/sql-basico-com-pokemon\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/pokemon-1600484_1280.jpg\",\"contentUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/pokemon-1600484_1280.jpg\",\"width\":1280,\"height\":959,\"caption\":\"sql-basico\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/sql-basico-com-pokemon\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mundo TI\",\"item\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/category\\\/mundo-ti\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Desenvolvimiento de software\",\"item\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/category\\\/mundo-ti\\\/desenvolvimiento-de-software\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"SQL b\u00e1sico: uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/\",\"name\":\"Blog de TI\",\"description\":\"Dicas para o RH e profissionais da \u00e1rea TI\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#organization\",\"name\":\"GeekHunter\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/icon-1.png\",\"contentUrl\":\"https:\\\/\\\/www.geekhunter.com/pt/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/icon-1.png\",\"width\":300,\"height\":300,\"caption\":\"GeekHunter\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/geekhunterbr\\\/\",\"https:\\\/\\\/x.com\\\/geekhunterbr\",\"https:\\\/\\\/www.instagram.com\\\/geekhunterbr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/geekhunter-brasil\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@GeekHunterOfficial\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/#\\\/schema\\\/person\\\/9f62b173345139f7bbdaf55312c3d400\",\"name\":\"Geekhunter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g\",\"caption\":\"Geekhunter\"},\"url\":\"https:\\\/\\\/www.geekhunter.com\\\/pt\\\/blog\\\/author\\\/matias\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon","description":"E que tal aprender SQL b\u00e1sico montando uma Pok\u00e9dex? Foi isso que fizemos neste artigo de introdu\u00e7\u00e3o ao SQL. Aprenda de forma descontra\u00edda!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/","og_locale":"pt_BR","og_type":"article","og_title":"SQL b\u00e1sico: uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon","og_description":"Que tal aprender o b\u00e1sico sobre SQL de uma forma simples e descontra\u00edda com Pok\u00e9mon? \u00c9 a inten\u00e7\u00e3o deste artigo. O que \u00e9 a linguagem SQL? A Structured","og_url":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/","og_site_name":"Blog Geekhunter","article_publisher":"https:\/\/www.facebook.com\/geekhunterbr\/","article_published_time":"2020-05-29T21:39:12+00:00","article_modified_time":"2024-10-10T20:48:08+00:00","og_image":[{"width":1280,"height":959,"url":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2020\/05\/pokemon-1600484_1280.jpg","type":"image\/jpeg"}],"author":"Geekhunter","twitter_card":"summary_large_image","twitter_creator":"@geekhunterbr","twitter_site":"@geekhunterbr","twitter_misc":{"Escrito por":"Geekhunter","Est. tempo de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/#article","isPartOf":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/"},"author":{"name":"Geekhunter","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/person\/9f62b173345139f7bbdaf55312c3d400"},"headline":"SQL b\u00e1sico: uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon","datePublished":"2020-05-29T21:39:12+00:00","dateModified":"2024-10-10T20:48:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/"},"wordCount":863,"publisher":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#organization"},"image":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/#primaryimage"},"thumbnailUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2020\/05\/pokemon-1600484_1280.jpg","articleSection":["Desenvolvimiento de software"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/","url":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/","name":"Uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon","isPartOf":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/#primaryimage"},"image":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/#primaryimage"},"thumbnailUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2020\/05\/pokemon-1600484_1280.jpg","datePublished":"2020-05-29T21:39:12+00:00","dateModified":"2024-10-10T20:48:08+00:00","description":"E que tal aprender SQL b\u00e1sico montando uma Pok\u00e9dex? Foi isso que fizemos neste artigo de introdu\u00e7\u00e3o ao SQL. Aprenda de forma descontra\u00edda!","breadcrumb":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.geekhunter.com/pt/blog\/sql-basico-com-pokemon\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/#primaryimage","url":"https:\/\/www.geekhunter.com\/pt\/blog\/wp-content\/uploads\/2020\/05\/pokemon-1600484_1280.jpg","contentUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2020\/05\/pokemon-1600484_1280.jpg","width":1280,"height":959,"caption":"sql-basico"},{"@type":"BreadcrumbList","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/sql-basico-com-pokemon\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.geekhunter.com/pt/blog\/"},{"@type":"ListItem","position":2,"name":"Mundo TI","item":"https:\/\/www.geekhunter.com/pt/blog\/category\/mundo-ti\/"},{"@type":"ListItem","position":3,"name":"Desenvolvimiento de software","item":"https:\/\/www.geekhunter.com/pt/blog\/category\/mundo-ti\/desenvolvimiento-de-software\/"},{"@type":"ListItem","position":4,"name":"SQL b\u00e1sico: uma introdu\u00e7\u00e3o ao SQL com Pok\u00e9mon"}]},{"@type":"WebSite","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#website","url":"https:\/\/www.geekhunter.com\/pt\/blog\/","name":"Blog de TI","description":"Dicas para o RH e profissionais da \u00e1rea TI","publisher":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.geekhunter.com/pt/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#organization","name":"GeekHunter","url":"https:\/\/www.geekhunter.com\/pt\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.geekhunter.com\/pt\/blog\/wp-content\/uploads\/2024\/10\/icon-1.png","contentUrl":"https:\/\/www.geekhunter.com/pt/blog\/wp-content\/uploads\/2024\/10\/icon-1.png","width":300,"height":300,"caption":"GeekHunter"},"image":{"@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/geekhunterbr\/","https:\/\/x.com\/geekhunterbr","https:\/\/www.instagram.com\/geekhunterbr\/","https:\/\/www.linkedin.com\/company\/geekhunter-brasil\/","https:\/\/www.youtube.com\/@GeekHunterOfficial"]},{"@type":"Person","@id":"https:\/\/www.geekhunter.com\/pt\/blog\/#\/schema\/person\/9f62b173345139f7bbdaf55312c3d400","name":"Geekhunter","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09a0f76de8cf1fa3621f8b73417ce43344b42e1324a07a9af24f57c5eef49840?s=96&d=mm&r=g","caption":"Geekhunter"},"url":"https:\/\/www.geekhunter.com\/pt\/blog\/author\/matias\/"}]}},"_links":{"self":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/posts\/10017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/users\/167"}],"replies":[{"embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/comments?post=10017"}],"version-history":[{"count":0,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/posts\/10017\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/media\/10019"}],"wp:attachment":[{"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/media?parent=10017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/categories?post=10017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.geekhunter.com/pt/blog\/wp-json\/wp\/v2\/tags?post=10017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}