{"id":5207,"date":"2023-03-22T00:50:25","date_gmt":"2023-03-21T21:50:25","guid":{"rendered":"http:\/\/professor.norton.net.br\/?p=5207"},"modified":"2023-03-22T03:41:08","modified_gmt":"2023-03-22T00:41:08","slug":"lbd-join","status":"publish","type":"post","link":"https:\/\/professor.norton.net.br\/index.php\/2023\/03\/22\/lbd-join\/","title":{"rendered":"LBD &#8211; JOIN"},"content":{"rendered":"\n<p><a href=\"https:\/\/professor.norton.net.br\/wp-content\/uploads\/2021\/03\/lbd05.pptx\">Apresenta\u00e7\u00e3o<\/a><\/p>\n\n\n\n<p><strong>Exemplo<\/strong><\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-aed46eaa-8b96-4c6f-b8c2-fe50e8eed40a\" href=\"https:\/\/professor.norton.net.br\/wp-content\/uploads\/2023\/03\/lbd05_exemplo.zip\">Exemplo<\/a><a href=\"https:\/\/professor.norton.net.br\/wp-content\/uploads\/2023\/03\/lbd05_exemplo.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-aed46eaa-8b96-4c6f-b8c2-fe50e8eed40a\"><\/a><\/div>\n\n\n\n<p>Atividade<\/p>\n\n\n\n<p>1-Utilizando inner join extraia do banco de dados biblioteca&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>As reservas efetuadas pelos leitores exibindo o nome do leitor, nome da obra e data da reserva<\/li>\n\n\n\n<li>Os&nbsp;empr\u00e9stimos efetuados pelos leitores exibindo o nome do leitor, nome da obra, e c\u00f3digo da copia e nome do funcionarios<\/li>\n<\/ul>\n\n\n\n<p>2-Utilizando left outer join extraia do banco de dados biblioteca&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>os leitores que nunca fizeram reservas&nbsp;<\/li>\n\n\n\n<li>os leitores que nunca fizeram empr\u00e9stimos<\/li>\n\n\n\n<li>as obras que nunca foram emprestadas<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Apresenta\u00e7\u00e3o Exemplo Atividade 1-Utilizando inner join extraia do banco de dados biblioteca&nbsp; 2-Utilizando left outer join extraia do banco de dados biblioteca&nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-5207","post","type-post","status-publish","format-standard","hentry","category-laboratorio-de-banco-de-dados"],"_links":{"self":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts\/5207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/comments?post=5207"}],"version-history":[{"count":9,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts\/5207\/revisions"}],"predecessor-version":[{"id":5628,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/posts\/5207\/revisions\/5628"}],"wp:attachment":[{"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/media?parent=5207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/categories?post=5207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/professor.norton.net.br\/index.php\/wp-json\/wp\/v2\/tags?post=5207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}