{"id":968,"date":"2024-05-14T19:40:43","date_gmt":"2024-05-14T22:40:43","guid":{"rendered":"https:\/\/thiagorossi.com.br\/blog\/?p=968"},"modified":"2024-12-04T15:06:38","modified_gmt":"2024-12-04T18:06:38","slug":"lidando-com-celulas-vazias","status":"publish","type":"post","link":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/","title":{"rendered":"Lidando com C\u00e9lulas Vazias"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Tempo de leitura: <\/span> <span class=\"rt-time\"> 3<\/span> <span class=\"rt-label rt-postfix\">minutos<\/span><\/span>\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Lidando com C\u00e9lulas Vazias:<\/strong> Ao trabalhar com bancos de dados, \u00e9 comum encontrarmos c\u00e9lulas vazias ou com valores nulos. Essas c\u00e9lulas podem representar informa\u00e7\u00f5es ausentes, dados n\u00e3o coletados ou simplesmente valores n\u00e3o aplic\u00e1veis. Saber como lidar com essas c\u00e9lulas \u00e9 fundamental para garantir a integridade e a precis\u00e3o dos seus dados. <\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Neste artigo, vamos explorar as diferentes formas de identificar, tratar e manipular c\u00e9lulas vazias em SQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>O que s\u00e3o c\u00e9lulas vazias?<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Em SQL, uma c\u00e9lula vazia pode ser representada por:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>NULL:<\/strong> Indica a aus\u00eancia de qualquer valor.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>String vazia:<\/strong> Uma cadeia de caracteres com zero comprimento (&#8221;).<\/li>\n<\/ul>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">\u00c9 importante distinguir entre os dois:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>NULL:<\/strong> Representa um valor desconhecido ou n\u00e3o aplic\u00e1vel.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>String vazia:<\/strong> Representa um valor que existe, mas n\u00e3o tem conte\u00fado.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Identificando C\u00e9lulas Vazias<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Para identificar c\u00e9lulas vazias, utilizamos o operador <code>IS NULL<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM clientes WHERE nome IS NULL;<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Este comando retornar\u00e1 todos os registros da tabela &#8220;clientes&#8221; onde o campo &#8220;nome&#8221; est\u00e1 vazio.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Para verificar se um campo \u00e9 igual a uma string vazia, utilizamos o operador de igualdade.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM produtos WHERE descricao = '';<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Tratando C\u00e9lulas Vazias<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Existem diversas formas de tratar c\u00e9lulas vazias, dependendo da sua necessidade:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>Ignorar:<\/strong> Em algumas consultas, voc\u00ea pode simplesmente ignorar as c\u00e9lulas vazias.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>Substituir por um valor:<\/strong> Voc\u00ea pode substituir as c\u00e9lulas vazias por um valor padr\u00e3o, como &#8220;N\u00e3o informado&#8221; ou 0.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>Excluir registros:<\/strong> Se um registro possui muitas c\u00e9lulas vazias, voc\u00ea pode optar por exclu\u00ed-lo.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>Filtrar resultados:<\/strong> Voc\u00ea pode filtrar os resultados para excluir registros com c\u00e9lulas vazias em colunas espec\u00edficas.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Fun\u00e7\u00f5es para Tratar Valores NULL<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Muitos sistemas de gerenciamento de bancos de dados oferecem fun\u00e7\u00f5es espec\u00edficas para lidar com valores NULL. Algumas das fun\u00e7\u00f5es mais comuns s\u00e3o:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>ISNULL(valor, valor_padr\u00e3o):<\/strong> Substitui um valor NULL por um valor padr\u00e3o.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>COALESCE(valor1, valor2, &#8230;):<\/strong> Retorna o primeiro valor n\u00e3o nulo em uma lista de valores.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>NVL(valor, valor_padr\u00e3o):<\/strong> Similar \u00e0 fun\u00e7\u00e3o ISNULL.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Exemplo:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT nome, COALESCE(endereco, 'Endere\u00e7o n\u00e3o informado') AS endereco FROM clientes;<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Este comando substitui os valores NULL na coluna &#8220;endereco&#8221; por &#8220;Endere\u00e7o n\u00e3o informado&#8221;.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Constraints para Evitar Valores NULL<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Para garantir que um campo n\u00e3o possa ser nulo, voc\u00ea pode utilizar a constraint <code>NOT NULL<\/code> ao criar a tabela:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE produtos (\n    id INT PRIMARY KEY,\n    nome VARCHAR(100) NOT NULL,\n    preco DECIMAL(10,2)\n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Considera\u00e7\u00f5es Importantes<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>\u00cdndices:<\/strong> C\u00e9lulas vazias podem afetar o desempenho de \u00edndices.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>Join:<\/strong> Ao realizar jun\u00e7\u00f5es entre tabelas, \u00e9 importante considerar como lidar com valores NULL.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>Agrupamento:<\/strong> As fun\u00e7\u00f5es de agrega\u00e7\u00e3o geralmente ignoram valores NULL.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Conclus\u00e3o<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Lidando com C\u00e9lulas Vazias:<\/strong> Lidar com c\u00e9lulas vazias \u00e9 uma parte essencial do trabalho com bancos de dados. Ao entender os diferentes tipos de valores vazios e as ferramentas dispon\u00edveis para trat\u00e1-los, voc\u00ea poder\u00e1 garantir a qualidade e a integridade dos seus dados.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Toda jornada tem um in\u00edcio, e o in\u00edcio para se tornar um desenvolvedor back-end \u00e9 dominar as seguintes tecnologias, que voc\u00ea encontra aqui mesmo:<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"\/category\/sql\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"426\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp\" alt=\"SQL\" class=\"wp-image-942\" srcset=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp 758w, https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2-300x169.webp 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/a><figcaption class=\"wp-element-caption\">SQL<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"\/category\/php\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"426\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Capa-PHP.png\" alt=\"Capa Curso PHP\" class=\"wp-image-2835\" srcset=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Capa-PHP.png 758w, https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Capa-PHP-300x169.png 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/a><figcaption class=\"wp-element-caption\">PHP<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"\/category\/laravel\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"426\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Laravel.webp\" alt=\"Laravel\" class=\"wp-image-1642\" srcset=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Laravel.webp 758w, https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Laravel-300x169.webp 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/a><figcaption class=\"wp-element-caption\">Laravel<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">E se voc\u00ea gosta do nosso conte\u00fado, n\u00e3o deixe de contribuir adquirindo os servi\u00e7os e produtos dos nossos apoiadores e empresas que somos associados:<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/hostinger.com.br\/?REFERRALCODE=1THIAGO62\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"250\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/03\/hostinger.png\" alt=\"Hospedagem Hostinger\" class=\"wp-image-92\"\/><\/a><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/amzn.to\/3SNDYlc\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"250\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/08\/ofertas-amazon.webp\" alt=\"Ofertas Amazon\" class=\"wp-image-1308\"\/><\/a><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/amzn.to\/3SNKmt0\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"250\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/08\/amazonprime.webp\" alt=\"Amazon Prime\" class=\"wp-image-1307\"\/><\/a><\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Tempo de leitura: <\/span> <span class=\"rt-time\"> 3<\/span> <span class=\"rt-label rt-postfix\">minutos<\/span><\/span>Lidando com C\u00e9lulas Vazias: Ao trabalhar com bancos de dados, \u00e9 comum encontrarmos c\u00e9lulas vazias&#8230;<\/p>\n","protected":false},"author":1,"featured_media":942,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-968","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","wpcat-10-id"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Lidando com C\u00e9lulas Vazias - BLOG THIAGO ROSSI<\/title>\n<meta name=\"description\" content=\"Lidando com C\u00e9lulas Vazias: Neste artigo, vamos explorar as diferentes formas de identificar, tratar e manipular c\u00e9lulas vazias em SQL...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lidando com C\u00e9lulas Vazias - BLOG THIAGO ROSSI\" \/>\n<meta property=\"og:description\" content=\"Lidando com C\u00e9lulas Vazias: Neste artigo, vamos explorar as diferentes formas de identificar, tratar e manipular c\u00e9lulas vazias em SQL...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/\" \/>\n<meta property=\"og:site_name\" content=\"BLOG THIAGO ROSSI\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-14T22:40:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-04T18:06:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"758\" \/>\n\t<meta property=\"og:image:height\" content=\"426\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Thiago Rossi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Thiago Rossi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/\"},\"author\":{\"name\":\"Thiago Rossi\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/5f28286948ec2afdeb2e044a2196cd87\"},\"headline\":\"Lidando com C\u00e9lulas Vazias\",\"datePublished\":\"2024-05-14T22:40:43+00:00\",\"dateModified\":\"2024-12-04T18:06:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/\"},\"wordCount\":522,\"publisher\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/\",\"name\":\"Lidando com C\u00e9lulas Vazias - BLOG THIAGO ROSSI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"datePublished\":\"2024-05-14T22:40:43+00:00\",\"dateModified\":\"2024-12-04T18:06:38+00:00\",\"description\":\"Lidando com C\u00e9lulas Vazias: Neste artigo, vamos explorar as diferentes formas de identificar, tratar e manipular c\u00e9lulas vazias em SQL...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/#primaryimage\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"contentUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"width\":758,\"height\":426,\"caption\":\"SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/lidando-com-celulas-vazias\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lidando com C\u00e9lulas Vazias\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/\",\"name\":\"THIAGO ROSSI\",\"description\":\"Mais de 20 anos de experi\u00eancia no mercado de TI!\",\"publisher\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#organization\"},\"alternateName\":\"TR | CURSO WEB DEV\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#organization\",\"name\":\"THIAGO ROSSI\",\"alternateName\":\"TR | CURSO WEB DEV\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/new-logo.webp\",\"contentUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/new-logo.webp\",\"width\":300,\"height\":300,\"caption\":\"THIAGO ROSSI\"},\"image\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/linkedin.com\\\/in\\\/thiagox86\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/5f28286948ec2afdeb2e044a2196cd87\",\"name\":\"Thiago Rossi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g\",\"caption\":\"Thiago Rossi\"},\"description\":\"Com mais de 20 anos de jornada na tecnologia, minha trajet\u00f3ria evoluiu do ensino t\u00e9cnico \u00e0 arquitetura de sistemas complexos. Hoje, foco minha expertise no desenvolvimento de solu\u00e7\u00f5es de Intelig\u00eancia Artificial nativa e an\u00e1lise de dados p\u00fablicos, utilizando o ecossistema PHP para transformar dados brutos em transpar\u00eancia e efici\u00eancia. Como autor e desenvolvedor, acredito na democratiza\u00e7\u00e3o do conhecimento. Essa vis\u00e3o resultou em uma biblioteca de mais de 530 artigos gratuitos, cobrindo desde a base do WebDev e Infraestrutura at\u00e9 os bastidores da ind\u00fastria de Jogos e IA. No universo de Game Design, sou autor do livro \\\"GDD \u2013 O Guia Definitivo\\\" e documento ativamente meus processos atrav\u00e9s de DevLogs, unindo rigor t\u00e9cnico e criatividade em projetos desenvolvidos com GDevelop 5. Meu compromisso \u00e9 conectar engenharia de ponta com as reais oportunidades do mercado de tecnologia.\",\"sameAs\":[\"https:\\\/\\\/thiagorossi.com.br\\\/blog\",\"https:\\\/\\\/instagram.com\\\/thiagorossix86\",\"https:\\\/\\\/linkedin.com\\\/in\\\/thiagox86\"],\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/author\\\/thiagorossi\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lidando com C\u00e9lulas Vazias - BLOG THIAGO ROSSI","description":"Lidando com C\u00e9lulas Vazias: Neste artigo, vamos explorar as diferentes formas de identificar, tratar e manipular c\u00e9lulas vazias em SQL...","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:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/","og_locale":"pt_BR","og_type":"article","og_title":"Lidando com C\u00e9lulas Vazias - BLOG THIAGO ROSSI","og_description":"Lidando com C\u00e9lulas Vazias: Neste artigo, vamos explorar as diferentes formas de identificar, tratar e manipular c\u00e9lulas vazias em SQL...","og_url":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/","og_site_name":"BLOG THIAGO ROSSI","article_published_time":"2024-05-14T22:40:43+00:00","article_modified_time":"2024-12-04T18:06:38+00:00","og_image":[{"width":758,"height":426,"url":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","type":"image\/webp"}],"author":"Thiago Rossi","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Thiago Rossi","Est. tempo de leitura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/#article","isPartOf":{"@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/"},"author":{"name":"Thiago Rossi","@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/person\/5f28286948ec2afdeb2e044a2196cd87"},"headline":"Lidando com C\u00e9lulas Vazias","datePublished":"2024-05-14T22:40:43+00:00","dateModified":"2024-12-04T18:06:38+00:00","mainEntityOfPage":{"@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/"},"wordCount":522,"publisher":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/#primaryimage"},"thumbnailUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","articleSection":["SQL"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/","url":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/","name":"Lidando com C\u00e9lulas Vazias - BLOG THIAGO ROSSI","isPartOf":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/#primaryimage"},"image":{"@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/#primaryimage"},"thumbnailUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","datePublished":"2024-05-14T22:40:43+00:00","dateModified":"2024-12-04T18:06:38+00:00","description":"Lidando com C\u00e9lulas Vazias: Neste artigo, vamos explorar as diferentes formas de identificar, tratar e manipular c\u00e9lulas vazias em SQL...","breadcrumb":{"@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/#primaryimage","url":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","contentUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","width":758,"height":426,"caption":"SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/thiagorossi.com.br\/blog\/lidando-com-celulas-vazias\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/thiagorossi.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Lidando com C\u00e9lulas Vazias"}]},{"@type":"WebSite","@id":"https:\/\/thiagorossi.com.br\/blog\/#website","url":"https:\/\/thiagorossi.com.br\/blog\/","name":"THIAGO ROSSI","description":"Mais de 20 anos de experi\u00eancia no mercado de TI!","publisher":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#organization"},"alternateName":"TR | CURSO WEB DEV","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/thiagorossi.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/thiagorossi.com.br\/blog\/#organization","name":"THIAGO ROSSI","alternateName":"TR | CURSO WEB DEV","url":"https:\/\/thiagorossi.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/04\/new-logo.webp","contentUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/04\/new-logo.webp","width":300,"height":300,"caption":"THIAGO ROSSI"},"image":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/linkedin.com\/in\/thiagox86"]},{"@type":"Person","@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/person\/5f28286948ec2afdeb2e044a2196cd87","name":"Thiago Rossi","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g","caption":"Thiago Rossi"},"description":"Com mais de 20 anos de jornada na tecnologia, minha trajet\u00f3ria evoluiu do ensino t\u00e9cnico \u00e0 arquitetura de sistemas complexos. Hoje, foco minha expertise no desenvolvimento de solu\u00e7\u00f5es de Intelig\u00eancia Artificial nativa e an\u00e1lise de dados p\u00fablicos, utilizando o ecossistema PHP para transformar dados brutos em transpar\u00eancia e efici\u00eancia. Como autor e desenvolvedor, acredito na democratiza\u00e7\u00e3o do conhecimento. Essa vis\u00e3o resultou em uma biblioteca de mais de 530 artigos gratuitos, cobrindo desde a base do WebDev e Infraestrutura at\u00e9 os bastidores da ind\u00fastria de Jogos e IA. No universo de Game Design, sou autor do livro \"GDD \u2013 O Guia Definitivo\" e documento ativamente meus processos atrav\u00e9s de DevLogs, unindo rigor t\u00e9cnico e criatividade em projetos desenvolvidos com GDevelop 5. Meu compromisso \u00e9 conectar engenharia de ponta com as reais oportunidades do mercado de tecnologia.","sameAs":["https:\/\/thiagorossi.com.br\/blog","https:\/\/instagram.com\/thiagorossix86","https:\/\/linkedin.com\/in\/thiagox86"],"url":"https:\/\/thiagorossi.com.br\/blog\/author\/thiagorossi\/"}]}},"_links":{"self":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/posts\/968","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/comments?post=968"}],"version-history":[{"count":0,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/posts\/968\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/media\/942"}],"wp:attachment":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/media?parent=968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/categories?post=968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/tags?post=968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}